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

21 votes182 views4 answers
Generate Random String
C#
2 votes171 views2 answers
Get Properties of a Class
C#
1 vote195 views1 answer
C# add byte to byte array
C#
0 vote183 views1 answer
C# condition and
C#
7 votes216 views1 answer
C# funtion
C#
1 vote175 views1 answer
Asp net c# compare date to current
C#
4 votes176 views2 answers
Byte array to hex c#
C#
2 votes192 views3 answers
C# generic type converter
C#
1 vote178 views1 answer
Fon der lajen
C#
0 vote228 views1 answer
Set dirty a property unity custom inspector
C#Unity