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 vote299 views1 answer
How to cast list to observablecollection c#
C#
5 votes250 views1 answer
Open new window c# wpf
C#
0 vote244 views1 answer
Font dialog c# code
C#
1 vote247 views1 answer
Check two lists are equal c#
C#
10 votes251 views4 answers
Unity array c#
C#
11 votes254 views1 answer
How to copy last element in list c#
C#
3 votes205 views1 answer
Winforms textbox placeholder
C#
16 votes213 views1 answer
For loop on enum c#
C#
0 vote270 views1 answer
C# date type no time
C#
2 votes256 views1 answer
C# empty IEnumerable
C#