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

2 votes175 views1 answer
How to make something addforce in the direction of something in untiy
C#
0 vote200 views1 answer
C# same folder path
C#
0 vote184 views1 answer
.net core get runtime version
C#
4 votes195 views1 answer
Make winforms full-screen c#
C#
47 votes196 views5 answers
Remove last character from string c#
C#
0 vote185 views1 answer
G2
C#
0 vote210 views1 answer
Yes no confirmation modal javascript
C#
1 vote246 views3 answers
Get key in dictionary c#
C#
0 vote226 views1 answer
Button not working unity
C#Unity
0 vote192 views1 answer
How to store user input into list c#
C#