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 vote124 views1 answer
Unity mesh showing Instance
C#
0 vote148 views1 answer
Create new .net core project visual studio
C#
2 votes150 views1 answer
How to turn string to int in unity
C#Unity
0 vote126 views1 answer
Base64 bit string to pdf c#
C#
0 vote146 views1 answer
C# print decimal with zero at the end
C#
0 vote124 views1 answer
Commit help
C#
3 votes129 views2 answers
C# read file by line
C#
0 vote88 views1 answer
Clock in wpf
C#
2 votes121 views2 answers
Unity how get random color to material
C#
0 vote124 views1 answer
C # c^b
C#