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

21 votes144 views3 answers
How to detect collision in unity
C#Unity
1 vote105 views1 answer
C# array remove first element
C#
0 vote114 views1 answer
C# treeview keep selected node highlight
C#
0 vote100 views1 answer
Assign int value c#
C#
0 vote118 views2 answers
C# program exit
C#
0 vote116 views1 answer
Oldest living language
C#
1 vote116 views1 answer
{} is this used for code blcoks in c#
C#
-1 vote112 views1 answer
C# unhandled exception in thread
C#
1 vote123 views2 answers
C# int positive only
C#
0 vote119 views2 answers
Mongodb c# batch find
C#