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

1 vote328 views1 answer
C# count specific element in list
C#
0 vote314 views1 answer
Entityframework command to build model from database
C#
1 vote333 views1 answer
Unity detect keyboard not mouse
C#
1 vote305 views2 answers
Declare enum c#
C#
0 vote304 views1 answer
List equals in order c#
C#
0 vote346 views1 answer
Polling data source c# using threads
C#
0 vote342 views1 answer
Csc is not recognized
C#
5 votes389 views1 answer
If unity
C#Unity
24 votes324 views3 answers
Check Directory Exist
C#
0 vote345 views2 answers
Change line color in c#
C#