Call user defined procedures in ASP.NET

Hi Saifullah,

You have call the stored procedure from the Code behind using SQL Objects, following is the code snippet ( I am assuming that you have the stored procedure already written):

SqlConnection MyConn = new SqlConnection("ConnectionString");
SqlCommand MyCMD = new SqlCommand("ProcedureName", MyConn);

MyCMD.CommandType = CommandType.StoredProcedure;

SqlParameter RetVal = MyCMD.Parameters.Add("RetVal", SqlDbType.Int);
RetVal.Direction = ParameterDirection.ReturnValue;

MyConn.Open();

MyCMD.ExecuteNonQuery();

Console.WriteLine("Return Value: " + RetVal.Value);

MyConn.Close();

Please do not forget to mark "Accepted Answer".