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 vote90 views1 answer
Unity put children in list
C#Unity
0 vote94 views1 answer
Asp.net core user.identity.name is null
C#
3 votes95 views1 answer
Linq include
C#
37 votes110 views5 answers
Unity key down
C#
0 vote94 views1 answer
C# Isolation Levels
C#
0 vote102 views1 answer
Spreate by captial char in c#
C#
1 vote101 views3 answers
Typeerror:
C#
0 vote95 views1 answer
C# datatable column alias
C#
0 vote98 views1 answer
C# use enum in class
C#
0 vote105 views1 answer
Dotween dovalue
C#