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 vote318 views1 answer
Convert dto to dictionary c#
C#
4 votes281 views3 answers
Rigidbody.velocity.magnitude
C#
0 vote249 views1 answer
Changing color of material of renderer with multiple materias
C#
0 vote261 views1 answer
ASP.NET Core using of ValidationScriptsPartial
C#
1 vote297 views2 answers
Get tag unity
C#Unity
0 vote241 views1 answer
C# make file writable
C#
1 vote279 views1 answer
How to change the axis of a Vector3 variable
C#
0 vote287 views1 answer
Allow edit in Datagrid C#
C#
0 vote269 views1 answer
How to pass optional guid parameters in c#
C#
0 vote254 views1 answer
C# order a sorted list by key
C#