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 vote280 views1 answer
C# get all occurrences of a string
C#
0 vote284 views1 answer
Listview inter thread operation not valid
C#
0 vote339 views1 answer
Don't want to update revision while updating field by code in sitecore c#
C#
0 vote282 views1 answer
Pick random point inside box collider unity
C#
3 votes272 views1 answer
C# writeline
C#
1 vote290 views1 answer
How to configure session timeout in asp.net core
C#
0 vote249 views1 answer
C# json contains property
C#
2 votes280 views2 answers
Commenting on C#
C#
0 vote327 views1 answer
C# file watcher specific file
C#
0 vote309 views1 answer
Get the current directory in unity
C#Unity