How to connect 2 table in one database.

Hi everyone.

Please Help Me.

Asp.net using C#.Net and Backend Sql server 2005.

1. How to conection 2 table at the same time.in c#.net.

2.How to Insert,update and delete for 1 or 2 table connections.

all the code give C#.Net in asp.net.

Thanks.

Hi, don't quite get your questions. What are you trying to do? What do you mean by connect 2 tables at the same time? Once you open a connection, you can access as many tables as you want through the connection; if the two tables are in two different database, you can open one connection for each database and then access yor tables.

Same confusion with the question 2. Don't know what you are asking.

Sorry

|||You should do some research on the SQL Join clause. Here's a starter for you: http://www.google.com/search?hl=en&q=sql+join&btnG=Google+Search&meta=|||

single database. 2 table at a time insert a values.

for example :

viswa is database.

student is a one table.

college fees is a one table.

student id is uni key

at a time 2 table insert a values.

please giveinsert, update and delete in c#.Net

|||

Those tables are not related. There is no reason that you should be performing operations on both tables at the same time. Nothing in college fees should relate to anything in student. If it does, then you need to look at your database design.

Also, C# does not offer any INSERT, UPDATE or DELETE procedures. You use the SQL language to perform operations against a database. You then use C# (or VB.Net, or J# etc) to get ADO.NET to present SQL commands to the database.

|||

I have Only one database and mutiple table.

database name = employee

table name = employee details

table name = employee salary

table name = department

morte...

I connect a database . how to select 2 tables.

my question isbatch process (multiple insert, update and delete ) in 2 tables