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 vote142 views2 answers
How to loop through a list and skip first element in c#
C#
1 vote237 views1 answer
Generate random name c#
C#
0 vote137 views1 answer
C# datafield change cell background color
C#
-1 vote180 views1 answer
Center mouse unity
C#Unity
0 vote129 views1 answer
Or operator in shell
C#
1 vote126 views1 answer
C# edit element in list
C#
4 votes177 views1 answer
Unity how to set rigidbody velocity
C#Unity
0 vote154 views1 answer
C# draggable controls
C#
0 vote135 views1 answer
IQueryable Query camleCase properties
C#
0 vote136 views1 answer
If exist request c#
C#