Saving data into multiple tables

Hello @Ashish if you want to insert data into multiple tables at the same time .

 Then there are several methods  like

1. using Create command at application level

 

sqlcmd.CommandText = "INSERT INTO Table1(Name, Address) VALUES(@Name, @Address)";   
  sqlcmd.CommandText = "INSERT INTO Table2(Company, Address2) VALUES(@Company, @Address2)";  
    sqlcmd.Parameters.Clear(); 
    sqlcmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = Name; 
    sqlcmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = Address;  
   sqlcmd.Parameters.Add("@Company", SqlDbType.VarChar).Value = Company;
 sqlcmd.Parameters.Add("@Address2", SqlDbType.VarChar).Value = Address2; 
 sqlcmd.Connection = sqlcon;  
   sqlcmd.ExecuteNonQuery();

Method 2.

you can create a stored procedure that hold all insert commands for all tables

 

Method 3:

you can also create   triggers 

 

you can select any method depend upon your requirement and  choice

if you want to ask about any   method then  Please Write........ 

hii aashish..

 you can use multiple insert statements as

http://stackoverflow.com/questions/16092895/insert-some-data-into-multiple-tables-using-c-sharp 

 

or you can use trigger