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 votes273 views1 answer
Get out of foreach statement c#
C#
31 votes311 views4 answers
C# string to datetime
C#
0 vote343 views1 answer
Unity error log
C#Unity
0 vote263 views1 answer
How to start a timer in c# forms application
C#
19 votes285 views3 answers
C# thread sleep
C#
0 vote379 views1 answer
Qcombobox delegate text filter
C#
0 vote287 views1 answer
How to detect ajax request in asp.net core
C#
0 vote323 views2 answers
How to save file on shared file xamarin forms
C#
0 vote280 views1 answer
Get array from column datatable c#
C#
0 vote323 views1 answer
Get all properties of an object including children c#
C#