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

32 votes346 views2 answers
C# how to write an array in a single line
C#
0 vote360 views1 answer
How to get the ip asp.net mvc
C#
2 votes310 views2 answers
Default route in asp.net core
C#
3 votes306 views1 answer
Check connection c#
C#
3 votes307 views1 answer
Check object is in layermask unity
C#
0 vote309 views1 answer
Find gameobject by name in root
C#
0 vote323 views1 answer
Unity deactive all object in list
C#
0 vote318 views1 answer
C# signalr console app client example
C#
0 vote282 views1 answer
C# in equivalent
C#
2 votes281 views1 answer
Power cfg on
C#