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

0 vote247 views1 answer
Interpolate rotation unity3d
C#
4 votes155 views1 answer
C# int max
C#
0 vote171 views1 answer
Find gameobject by name in root
C#
0 vote166 views1 answer
Rename join table ef core
C#
7 votes141 views2 answers
How to check if an animation is playing unity
C#Unity
1 vote147 views2 answers
C# set cursor pos
C#
0 vote137 views2 answers
System.Data.SqlClient.SqlException: 'Execution Timeout Expired.
C#
0 vote150 views1 answer
C# sprintf equivalent
C#
0 vote151 views1 answer
C# type of string
C#
1 vote146 views1 answer
Audiomixer get float
C#