How can we return table from stored procedure

Question

Hi all How can we return table from stored procedure or function? Thanks

Manas Mohapatra · Answer

Follow below links tha may help you: For SQLServer function: http://www.c-sharpcorner.com/blogs/calluse-a-sql-function-in-c-sharp1 For SP: CREATE PROCEDURE sp_Name AS BEGIN SELECT ID Name FROM Test END SqlConnection connection = new SqlConnection(ConnectionString); command = new SqlCommand( sp_Name  connection); command.CommandType = System.Data.CommandType.StoredProcedure; connection.Open(); DataTable dt = new DataTable(); dt.Load(command.ExecuteReader()); gvGrid.DataSource = dt; gvGrid.DataBind();

Puneet Kankar · Answer

CREATE PROCEDURE [Student_USP] AS BEGIN SELECT * FROM student END