c# result set from stored procedure
SqlConnection connection = new SqlConnection(ConnectionString);
command = new SqlCommand("TestProcedure", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
DataTable dt = new DataTable();
dt.Load(command.ExecuteReader());
gvGrid.DataSource = dt;
gvGrid.DataBind();set a value by excuting stored procedure
// Call to the stored procedure, with an OUTPUT parameter
DECLARE @OutputParameter datetime
,@ReturnValue int
EXEC @ReturnValue= [YourStoredProcedure] [comma separated parameters if any] @OutputParameter OUTPUT
PRINT(@ReturnValue)Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
