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 vote157 views1 answer
How to turn off sprite renderer in unity
C#Unity
0 vote163 views1 answer
Unity set sprite image from script
C#Unity
30 votes233 views4 answers
How to wait in c#
C#
0 vote164 views1 answer
How to make colliders collide with some things but not other in unity
C#Unity
13 votes122 views6 answers
C# function
C#
0 vote132 views1 answer
Listview item click c#
C#
1 vote123 views1 answer
How to index ireadonlycollection c#
C#
0 vote129 views1 answer
Unity trigger not detecting collision
C#
0 vote161 views4 answers
Enum in c#
C#
2 votes145 views2 answers
Unity don't destroy on load
C#