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

0 vote123 views1 answer
C# clamp
C#
1 vote126 views2 answers
C# random choice
C#
41 votes169 views3 answers
C# split text by spaces
C#
0 vote178 views1 answer
Qtablewidget add image
C#
11 votes179 views1 answer
How to make a hello world program in c#
C#
0 vote165 views1 answer
Project mongodb c#
C#
0 vote171 views1 answer
More than one migrations configuration type was found in the assembly 'EFCodeFirst'. Specify the name of the one to use
C#
0 vote151 views1 answer
Connection string of bulk insert with csv in c#
C#
0 vote156 views1 answer
Tuple parameter name
C#
0 vote177 views1 answer
C# asp.net gridview selected row unselect
C#