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 vote168 views2 answers
Insert SQLite
C#
0 vote210 views1 answer
How to draw gizmos unity
C#Unity
4 votes181 views1 answer
Make winforms full-screen c#
C#
3 votes213 views2 answers
Aspx textarea
C#
49 votes201 views8 answers
C# hello world
C#
1 vote193 views1 answer
C# read from text documenmt
C#
3 votes168 views1 answer
Unity how to get y value
C#
0 vote167 views1 answer
Computing a Cartesian product or Combinations with LINQ
C#
0 vote180 views3 answers
.net return manual status code
C#
0 vote184 views1 answer
All SQL Server Tables in a Schema
C#