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

Accepted 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

Hi,

Please follow steps given by Yogesh Ghorpade

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;

}

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

Can i create a new data table??

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