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 vote155 views1 answer
Unity flexiable space
C#
0 vote145 views1 answer
C# get all id of list object
C#
2 votes139 views1 answer
Linq query select top 1 c#
C#
0 vote270 views1 answer
Object escape player unity
C#Unity
52 votes158 views6 answers
How to print something in c#
C#
4 votes142 views1 answer
C# check if type implements interface
C#
0 vote216 views1 answer
Adding number of day remaining to future date from now
C#
0 vote222 views1 answer
10x10 table matrix C#
C#
0 vote206 views1 answer
How to access a dictionary in c#
C#
0 vote137 views1 answer
C# compress string
C#