how to get the data from storedprocedure and how to bind the

Question

how to get the data from storedprocedure and how to bind the data in data table from stored procedure please help me

Jenith Thakkar · Answer

Basic Example DataTable table = new DataTable(); using(var con = new SqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString)) using(var cmd = new SqlCommand("usp_GetABCD", con)) using(var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.StoredProcedure; da.Fill(table); } I hope it will helpful for you

Yogesh Ghorpade · Answer

public DataTable MethodName(int Var1, int Var2) { DataSet ds = new DataSet(); DataTable dtDetail = new DataTable(); SqlParameter[] Parram = new SqlParameter[2]; Parram[0] = new SqlParameter("@SpVar1", Var1); Parram[1] = new SqlParameter("@SpVar1", Var2); ds = SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "StoreProcedureName", Parram); if (ds.Tables.Count > 0) { dtDetail = ds.Tables[0]; } return dtDetail; }

Jenith Thakkar · Answer

Yes you can create a new DataTable and Fill Stored Procedure Result in to that datatable.

Mahesh Babu · Answer

Can i create a new data table??

Mahesh Babu · Answer

how to get the data from storedprocedure and how to bind the data in data table in stored procedure in asp.net

Packiaraj Santhiyagu · Answer

Hi, Please follow steps given by Yogesh Ghorpade

how to get the data from storedprocedure and how to bind the

Answers (6)