How to use Button Click Event to insert data in two tables

Create two table Emp and Manager

Create two stored procedure

CREATE PROCEDURE insert1
(@ID varchar(50),@Name varchar(50),@Location varchar(50))
AS
insert Emp(ID,Name,Location) values (@ID,@Name,@Location)

CREATE PROCEDURE insert2
(@ID varchar(50),@Name varchar(50),@Location varchar(50))
AS
insert Manager(ID,Name,Location) values (@ID,@Name,@Location)

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm11.aspx.cs" Inherits="WebApplication16.WebForm11" %>

    Untitled Page



using System;
using System.Collections;
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;
namespace WebApplication16
{
    public partial class WebForm11 : 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("@ID", SqlDbType.VarChar).Value = TextBox1.Text;
            com.Parameters.Add("@Name", SqlDbType.VarChar).Value = TextBox2.Text;
            com.Parameters.Add("@Location", SqlDbType.VarChar).Value = TextBox3.Text;
            con.Open();
            com.ExecuteNonQuery();
            con.Close();

            com = new SqlCommand("insert2", con);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@ID", SqlDbType.VarChar).Value = TextBox4.Text;
            com.Parameters.Add("@Name", SqlDbType.VarChar).Value = TextBox5.Text;
            com.Parameters.Add("@Location", SqlDbType.VarChar).Value = TextBox6.Text;
            con.Open();
            com.ExecuteNonQuery();
            con.Close();

            Response.Write("Record Successfully Inserted");
        }
    }
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak13y ago
Accepted answer
Create two table Emp and Manager

Create two stored procedure

CREATE PROCEDURE insert1
(@ID varchar(50),@Name varchar(50),@Location varchar(50))
AS
insert Emp(ID,Name,Location) values (@ID,@Name,@Location)

CREATE PROCEDURE insert2
(@ID varchar(50),@Name varchar(50),@Location varchar(50))
AS
insert Manager(ID,Name,Location) values (@ID,@Name,@Location)

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm11.aspx.cs" Inherits="WebApplication16.WebForm11" %>

    Untitled Page




















                    onclick="btn_insert_Click" />





using System;
using System.Collections;
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;
namespace WebApplication16
{
    public partial class WebForm11 : 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("@ID", SqlDbType.VarChar).Value = TextBox1.Text;
            com.Parameters.Add("@Name", SqlDbType.VarChar).Value = TextBox2.Text;
            com.Parameters.Add("@Location", SqlDbType.VarChar).Value = TextBox3.Text;
            con.Open();
            com.ExecuteNonQuery();
            con.Close();

            com = new SqlCommand("insert2", con);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.AddWithValue("@ID", SqlDbType.VarChar).Value = TextBox4.Text;
            com.Parameters.Add("@Name", SqlDbType.VarChar).Value = TextBox5.Text;
            com.Parameters.Add("@Location", SqlDbType.VarChar).Value = TextBox6.Text;
            con.Open();
            com.ExecuteNonQuery();
            con.Close();

            Response.Write("Record Successfully Inserted");
        }
    }
}
Ashutosh Chaturvedi13y ago
Yes dude I got It
Vishal Gilbile13y ago
Hello Friend,
As Satyapriya said you can create two procedures to insert data in more than one tabl, but if you want to maintain consistency and reliability then you need to implement transaction while inserting data in your two tables. That means in your procedure you need to make use of transaction.

Hope that gives you a better understanding.

With Regards,
Vishal Gilbile.