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 vote193 views1 answer
In clause db2 c#
C#
0 vote227 views1 answer
BOTON PARA CAMBIAR DE VIEW ASP.NET
C#
2 votes320 views1 answer
How to do a web request unity
C#Unity
0 vote240 views1 answer
C# substring reverse
C#
0 vote258 views1 answer
Convert int to uint C#
C#
0 vote193 views1 answer
Windows forms webbrowser goback
C#
1 vote175 views1 answer
Assign boolean value c#
C#
2 votes182 views2 answers
The value '1990-10-23' is not valid for DOB. Data Annotation C#
C#
0 vote170 views1 answer
C# web scraping get images from specific url
C#
1 vote420 views1 answer
How set element in middle in bootstrap
C#