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

3 votes367 views1 answer
Unity on mousewheel down
C#Unity
0 vote330 views1 answer
Unity set dictionary value
C#
0 vote401 views1 answer
Unity Texture2D efficient performance draw pixels
C#
0 vote341 views2 answers
Datagridview mouse click event c#
C#
0 vote335 views1 answer
C# gridview summary item displayformat
C#
0 vote357 views1 answer
C# using rename class
C#
11 votes368 views4 answers
C# remove all whitespaces from string
C#
0 vote371 views2 answers
How to encode and decode a string in c#
C#
0 vote341 views1 answer
C# if isset
C#
26 votes348 views4 answers
Unity print
C#