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

4 votes196 views1 answer
Unity foreach child
C#
0 vote213 views1 answer
Difference between awake and start unity
C#Unity
1 vote136 views1 answer
C# integer to bit string
C#
13 votes171 views3 answers
C# join array
C#
0 vote123 views1 answer
Npm add auth token
C#
0 vote137 views1 answer
How to create a class and objects in C#
C#
1 vote103 views2 answers
C# random choice
C#
0 vote141 views1 answer
Flutter find a widget
C#
0 vote148 views1 answer
Unity master volume changer
C#
0 vote144 views4 answers
Hovercraft Physics in Unity
C#