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 vote140 views1 answer
Csharp read input from console as array
C#
0 vote109 views2 answers
How to convert list of string to single string in c#
C#
23 votes143 views2 answers
Unity serializefield
C#Unity
2 votes134 views1 answer
C# import class from another file
C#
7 votes108 views2 answers
Unity float from another script
C#
0 vote118 views1 answer
Jeng InitDb
C#
0 vote126 views1 answer
Uninitialized array c#
C#
0 vote108 views1 answer
Reverse a linked list C#
C#
0 vote114 views1 answer
Move files from one folder to another using c#
C#
1 vote116 views1 answer
How to declare an dinamic array in c#
C#