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

13 votes307 views2 answers
C# ip address translate localhost
C#
8 votes271 views2 answers
Sum in c#
C#
3 votes256 views2 answers
Dotnet new project
C#
0 vote276 views1 answer
Json serialize object capitalization config
C#
0 vote278 views1 answer
Fill dataset with list c#
C#
0 vote244 views1 answer
Solidity get address of contract
C#
5 votes308 views2 answers
C# datetime iso 8601 format
C#
46 votes258 views6 answers
Unity C# random number
C#
0 vote304 views1 answer
C# url relative path remove
C#
0 vote297 views2 answers
How to get src value from img tag in c#
C#