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 vote122 views1 answer
C# print multiplication table
C#
0 vote114 views1 answer
C# compress string
C#
0 vote151 views1 answer
Code to disable Debug.log
C#
0 vote120 views1 answer
How to open onscreen keyboard c#
C#
0 vote114 views1 answer
How long dose it take for formate a currupt USB?
C#
14 votes120 views2 answers
How to make multiplayer game in unity
C#
3 votes120 views2 answers
C# console play sound
C#
0 vote84 views1 answer
ActionExecutingContext result response return objects
C#
0 vote102 views1 answer
C# Convert range
C#
0 vote113 views1 answer
Sort array dotnet
C#