Using store Procedure to insert in 2 tables

arnabghosh · September 28th, 2009, 02:55 AM

Hi,

I need a store procedure that will take 2 parameters Name & age. It will be entered in 2 tables namely employee - will contain Name & employee_details - will contain age. employee is the main table which has a identity column empID as Primary key & employee_detail table is the detail table with empID as Foreign Key.

Now what would be the code for my store procedure if I have to insert 2 values - Name & Age for employees from a Asp.Net page using this store procedure.

Urgent Pls help !!!

om_prakash · September 28th, 2009, 07:17 AM

Please check the following link for examples:
http://www.csharpfriends.com/Article...x?articleID=78
http://www.dotnetspider.com/forum/39...rocedures.aspx

Example:

Code:

string username = ... // get username from user
string password = ... // get password from user
SqlConnection conn = new SqlConnection("Data 
Source=localhost;Database=MyDB;Integrated Security=SSPI");
SqlCommand command = new SqlCommand("InsertUser", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Username", SqlDbType.VarChar).Value = username;
command.Parameters.Add("@Password", SqlDbType.VarChar).Value = password;
conn.Open();
int rows = command.ExecuteNonQuery();
conn.Close();

You can write SP which will accept the required parameters and insert data in one or more tables.