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

0 vote314 views2 answers
1.1 0da14962afa287e5ba55c7d30c902392.cloudfront.net w
C#
0 vote355 views1 answer
Select list that does not exis in another C# list
C#
2 votes296 views1 answer
Camera follow player unity smooth
C#
12 votes367 views2 answers
How to get ip address in c#
C#
-1 vote365 views2 answers
Double quotes in a string c#
C#
13 votes334 views1 answer
Change sprite of gameobject unity
C#
1 vote322 views1 answer
Gcd of list of number
C#
0 vote329 views1 answer
Why doesnt the if command work in C#
C#
0 vote343 views1 answer
Rotate along normal unity
C#
96 votes396 views6 answers
C# how to convert string to int
C#