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 vote124 views1 answer
Rigidbody.addforce not working
C#
3 votes132 views2 answers
Unity how to add force
C#Unity
0 vote114 views1 answer
C# code skripte kommunizieren
C#
1 vote155 views1 answer
Change size of a unity object
C#Unity
14 votes168 views3 answers
String to int c# unity
C#Unity
0 vote120 views1 answer
Ef core seed data bogus data without migration
C#
0 vote123 views1 answer
ASP.NET Core using of ValidationScriptsPartial
C#
0 vote148 views1 answer
Garbage collect every 30 frames unity
C#Unity
1 vote119 views1 answer
How To Copy a text C# unity
C#
6 votes124 views1 answer
How to change a image with code unity
C#