TrialUser
asked on
ado.net code to get the id of the column inserted using stored procedure
In my stored procedure I insert a record. After the insert my stored procedure does soemthing like :
select @userid = SCOPE_IDENTITY()
select @userid
Using ado.net code how can i get the value of @userid. please help
c#.net code:
SqlCommand cmd = new SqlCommand("user_ins");
cmd.CommandType = CommandType.StoredProcedur e;
cmd.Parameters.AddWithValu e("@userNa me", username
cmd.Parameters.AddWithValu e("@End_dt ", enddt);
using (SqlConnection conn = new SqlConnection(ConnectionSt ring))
{
conn.Open();
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
select @userid = SCOPE_IDENTITY()
select @userid
Using ado.net code how can i get the value of @userid. please help
c#.net code:
SqlCommand cmd = new SqlCommand("user_ins");
cmd.CommandType = CommandType.StoredProcedur
cmd.Parameters.AddWithValu
cmd.Parameters.AddWithValu
using (SqlConnection conn = new SqlConnection(ConnectionSt
{
conn.Open();
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER