Stored procedure to update multiple table same time

[parshupooja]

Hello ,

I am using asp.net C# SQL Server . I have form on asp.net page consists various fields.
field 1, field 2 ------ upto field 10
on click of submit button i need to save all information entered by user into table1, table2, table3 tables.
field 1 to field5 is new record in table1 whereas field 6, field 7 , field 8 will update some columns in table 2 and rest fields will be updated to table 3.

To acheive this I need to write Stored procedure which saves this information to tables. Please help

[bhar]

Hi,

After you enter the data into the fields, user will press the button control. The code is based on C# 2005. You need to pass the values from the page as parameters to the stored procedure.

void Button_Click(object sender, System.EventArgs e)
{
 
SqlConnection conJobs;
string strConString;
SqlCommand cmdInsert;
SqlParameter parmReturn;
 
        if (IsValid)
        {
     strConString = "DataSource=localhost;database=jobsabc;User ID=jobs123;Password=cd546dc;";
 
           conJobs = new SqlConnection(strConString);
            cmdInsert = new SqlCommand("addUser", conJobs);
            cmdInsert.CommandType = CommandType.StoredProcedure;
            parmReturn = cmdInsert.Parameters.Add("@return", SqlDbType.Int);
            parmReturn.Direction = ParameterDirection.ReturnValue;
 
            cmdInsert.Parameters.Add("@username", txtUsername.Text);
            cmdInsert.Parameters.Add("@password", txtPassword.Text);
            cmdInsert.Parameters.Add("@firstname", txtFirstname.Text);
            cmdInsert.Parameters.Add("@lastname", txtLastname.Text);
 
 
            conJobs.Open();
            cmdInsert.ExecuteNonQuery();
            conJobs.Close();
 
        if ((int)cmdInsert.Parameters["@Return"].Value == 0)
            {
 
                Response.Redirect("registeraccept.aspx");
            }
 
         if ((int)cmdInsert.Parameters["@Return"].Value == -1) 
            {
                lblError.Visible = true;
            }
  }
}
 
The code for the stored procedure is given below.
 
CREATE   procedure addUser
(
  @username Varchar( 20 ),
  @password varchar( 20 ),
  @firstname varchar( 30 ),
  @lastname varchar( 30 )
 )
As
 
If Exists( SELECT ul_username FROM UserList
           WHERE ul_username = @username ) 
BEGIN  
RETURN -1
END
 
If Exists( SELECT ul_email FROM UserList
           WHERE ul_email = @email ) 
BEGIN  
RETURN -2
END
 
ELSE
  INSERT UserList (
    ul_username,
    ul_password,
    ul_firstname,
    ul_lastname
 
     ) VALUES (
    @username,
    @password,
    @firstname,
    @lastname
  )

[parshupooja]

Hello bhar,

Thank You for reply but please read my doubt again.
I am trying to insert and update multiplte tables simultaneouly in single stored procedure