April 27, 2011

Pass output parameter to stored procedure in ASP.Net

SqlParameter ss = new SqlParameter("@RegID", SqlDbType.Int, 4, ParameterDirection.Output.ToString());
ss.Direction = ParameterDirection.Output;
cmd.Parameters.Add(ss);

con.Open();
SqlDataReader reader = cmd.ExecuteReader();
string regID = (ss.Value).ToString();
con.Close();

No comments:

Post a Comment