Saving data into multiple tables

Question

How to insert data into multiple tables at the same time using ado.net ???

Ashish Deo · Answer

Thank You...!!!

Pankaj Kumar Choudhary · Answer

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........

madhuri Gamane · Answer

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