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

Saving data into multiple tables

Answers (3)