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 vote217 views1 answer
Unity get a position inside sphere
C#
0 vote245 views1 answer
Unity android plugin callback
C#Unity
57 votes240 views6 answers
Unity find objects with tag
C#
0 vote225 views1 answer
Xamarin forms XAML change value
C#
0 vote211 views1 answer
C# directory entry invoke
C#
9 votes227 views3 answers
Unity get rigidbody
C#Unity
1 vote252 views1 answer
How to turn off sprite renderer in unity
C#Unity
0 vote206 views1 answer
C# arrow
C#
4 votes231 views2 answers
Vue transition enter before
C#
2 votes284 views1 answer
Simple reset transform.rotation c#
C#