how to insert into two tables from one button click?

Question

Hi guys I am trying to insert data from a form in asp.net using c# into two different tables from one button click action. Some of the data will go into one specified table and the rest will go into the other specified table. Is there any examples of similar type action or is this even possible? Kind regards Kieran

Satyapriya Nayak · Answer

Hi Kieran Try this... Create two stored procedure as below ALTER PROCEDURE insert1 (@custid varchar(50)@custname varchar(50)@custaddress varchar(50)@prodid varchar (50)) AS insert Customer(custidcustnamecustaddressprodid) values (@custid@custname@custaddress@prodid) ALTER PROCEDURE insert2 (@prodid varchar(50)@prodname varchar(50)@price int) AS insert Product(prodidprodnameprice) values (@prodid@prodname@price) Default.aspx code Untitled Page onclick=btn_insert_Click /> Default.aspx.cs code using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; protected void btn_insert_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); com = new SqlCommand(insert1 con); com.CommandType = CommandType.StoredProcedure; com.Parameters.Add(@custid SqlDbType.VarChar).Value = TextBox1.Text; com.Parameters.Add(@custname SqlDbType.VarChar).Value = TextBox2.Text; com.Parameters.Add(@custaddress SqlDbType.VarChar).Value = TextBox3.Text; com.Parameters.Add(@prodid SqlDbType.VarChar).Value = TextBox4.Text; con.Open(); com.ExecuteNonQuery(); con.Close(); com = new SqlCommand(insert2 con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue(@prodid SqlDbType.VarChar).Value = TextBox4.Text; com.Parameters.Add(@prodname SqlDbType.VarChar).Value = TextBox5.Text; com.Parameters.Add(@price SqlDbType.Int).Value = TextBox6.Text; con.Open(); com.ExecuteNonQuery(); con.Close(); Label7.Text = Record Successfully Inserted; TextBox1.Text=; TextBox2.Text=; TextBox3.Text=; TextBox4.Text=; TextBox5.Text=; TextBox6.Text=; } } Thanks If this post helps you mark it as answer

Upamanyu Roy Choudhury · Answer

Hi Sita and Kieran You need not use two separte preocudres to insert data in two separae tables. Inside one preocdure itself you can add logic to insert into differnt tables. infact without using store procs also you can insert data by using inline queries

sita k · Answer

Hi satya Your post really helped me.I wanted to know if i need to update the column values do i need to write separate update procedures for both the tables or can i write the update stmt for both tables in c#.Will it work?