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

1 vote154 views1 answer
Togl unity
C#Unity
22 votes117 views3 answers
Change scene unity
C#
0 vote125 views1 answer
C# usermanager update user
C#
0 vote143 views1 answer
Flutterwave c# api integration
C#
3 votes120 views2 answers
Unity pause scene
C#
1 vote116 views2 answers
Cursor position c#
C#
0 vote133 views1 answer
Migrationbuilder insert data example
C#
0 vote159 views1 answer
Billboard canvas unity
C#Unity
3 votes126 views3 answers
C# int to byte Array
C#
0 vote136 views1 answer
Button color uwp c#
C#