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 vote171 views2 answers
Unity slider decimal 0.01
C#
4 votes153 views1 answer
Instantiate list with values c#
C#
0 vote163 views1 answer
Dotween dovalue
C#
19 votes149 views6 answers
Bootstrap popup
C#
2 votes203 views1 answer
Unity comparetag
C#Unity
0 vote151 views1 answer
LsbCat.Items.Clear();lsbCat.Items.AddRange(Cats.ToArray());txtCat.Clear();
C#
11 votes155 views2 answers
Unity how to change rotation
C#
13 votes163 views2 answers
C# list to array
C#
1 vote156 views1 answer
Unity how to end a game with esc
C#
0 vote175 views1 answer
Unity get rid of mouse
C#