65.9K
CodeProject is changing. Read more.
Home

Combining Insert/Update to one Procedure

emptyStarIconemptyStarIconemptyStarIconemptyStarIconemptyStarIcon

0/5 (0 vote)

Jan 3, 2012

CPOL
viewsIcon

7450

CREATE PROCEDURE sp_Insert ( @ID int, @Name char(20), @Mode char(20) ) ASif @Mode='Insert in Employee'Begin insert into Employee(Employee_ID,Employee_Name)values(@ID,@Name)Endelse if @Mode='Insert in Student'Begin insert into...

CREATE PROCEDURE sp_Insert
	
	(
	@ID int,
	@Name char(20),
	@Mode char(20)
	)
	
AS
if @Mode='Insert in Employee'
Begin
	insert into Employee(Employee_ID,Employee_Name)values(@ID,@Name)
End
else if @Mode='Insert in Student'
Begin
    insert into Student(Student_ID,Student_Name)values(@ID,@Name)
End

	RETURN
============================================================================and on the buttons_click this will be coding...!
 private void Employee_Save_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(" ");
            conn.Open();
            SqlCommand cmd=new SqlCommand("SP_INSERT",conn);
            cmd.CommandType=CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@ID",txtEmployeeID);
            cmd.Parameters.AddWithValue("@Name",txtEmployeeName);
            cmd.Parameters.AddWithValue("@Mode","Insert in Employee");
            cmd.ExecuteNonQuery();
            conn.Close();
           
        }
        private void Student_Save_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("")
            conn.Open();
            SqlCommand cmd = new SqlCommand("SP_INSERT", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@ID", txtStudentID);
            cmd.Parameters.AddWithValue("@Name",txtStudentName);
            cmd.Parameters.AddWithValue("@Mode", "Insert in Student");
            cmd.ExecuteNonQuery();
            conn.Close();
        }
May be there would be difference coding Format...!