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

7 votes393 views3 answers
How to change scenes on collision unity
C#Unity
0 vote397 views1 answer
Asserting exceptions c#
C#
20 votes372 views3 answers
C# thread wait
C#
0 vote353 views1 answer
Add variable to the beginning of a list c#
C#
3 votes406 views2 answers
How to add a force to an object unity
C#
0 vote337 views1 answer
World space constant size
C#
0 vote333 views1 answer
System.IO.FileNotFoundException: 'Could not load file or assembly 'Microsoft.Bcl.AsyncInterfaces, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'.
C#
7 votes364 views1 answer
For loop unity
C#Unity
0 vote358 views1 answer
C# if debug
C#
1 vote339 views1 answer
Unity lookrotation lerp
C#