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

74 votes257 views10 answers
Webp to jpg
C#
0 vote146 views1 answer
C# constant list
C#
0 vote263 views1 answer
Get width of image unity
C#Unity
0 vote184 views1 answer
Disable Debug.log Unity
C#
0 vote173 views1 answer
C# form
C#
4 votes191 views2 answers
C# readline char
C#
0 vote167 views1 answer
Rock paper scissors c#
C#
0 vote191 views1 answer
C# map number range
C#
-1 vote172 views1 answer
Multithreading in .net core
C#
-1 vote230 views3 answers
Google tradutor
C#