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 vote306 views1 answer
Large blank file C#
C#
2 votes363 views2 answers
C# stop process
C#
3 votes292 views2 answers
C# open file
C#
1 vote299 views1 answer
Listview disable resize columns
C#
7 votes312 views3 answers
C# datetime to timestamp
C#
2 votes350 views1 answer
How to reset rotation in unity
C#Unity
8 votes280 views3 answers
Save byte array to file c#
C#
0 vote276 views3 answers
C# example code
C#
0 vote301 views1 answer
C# system dont let write txt file
C#
7 votes292 views4 answers
C# list index
C#