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();

Source: stackoverflow.com

Similar codes

1 vote201 views1 answer
C# iformfile to string
C#
0 vote219 views1 answer
C# modify dictionary in loop
C#
5 votes174 views2 answers
How to deactivate an object unity
C#
0 vote206 views1 answer
Show empty message in data table angular material, If no data found
C#
0 vote173 views1 answer
Static variable in c#
C#
0 vote197 views1 answer
Meaning of ??= in c#
C#
0 vote172 views1 answer
Afaik
C#
0 vote194 views1 answer
Mvc invalidOperationException: Method 'InvokeAsync' of view component should be declared to return Task<t>
C#
0 vote176 views2 answers
How to find the text position in excel in c#
C#
2 votes166 views1 answer
Snx disconnect linux
C#