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 vote210 views1 answer
How to set a transform equal to something unity
C#
0 vote241 views1 answer
How to call method in different project in c# visual studio
C#
6 votes301 views1 answer
Unity rotate vector
C#Unity
1 vote244 views2 answers
Unity create random string
C#Unity
0 vote250 views1 answer
Store Images In SQL Server Using EF Core And ASP.NET Core
C#
0 vote231 views1 answer
Convert bool to uint in solidity
C#
0 vote258 views1 answer
Cosmos db get all items in container
C#
0 vote242 views2 answers
System.Data.Entity.Core.EntityException: The underlying provider failed on Open
C#
0 vote225 views1 answer
Monogame button
C#
0 vote260 views1 answer
Override GetHashCode
C#