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

6 votes173 views1 answer
Generate model from database entity framework
C#
0 vote167 views1 answer
Startup c# class winform
C#
2 votes163 views1 answer
Unity default rotation
C#
23 votes182 views3 answers
C# write to console
C#
0 vote168 views1 answer
C# read key without writing
C#
2 votes167 views1 answer
Unity how to refrsh scene
C#
0 vote168 views1 answer
C# square symbol
C#
1 vote175 views2 answers
C# catch two exceptions in one block
C#
3 votes182 views1 answer
C# linq include
C#
28 votes187 views3 answers
Unity check gameobject active
C#Unity