sql - Bind multiple datatable into DataSet.xsd -
i'm working reportviewer tool , i'm using loop in stored procedure , returns multiple tables, how can bind these multiples table columns dataset.xsd page? can please help..
cmd.commandtext = sp_name;
cmd.commandtype = commandtype.storedprocedure;
cmd.parameters.addwithvalue("@ddo_code", ddlddocode.selectedvalue);
cmd.connection = con;
con.open();
sqldataadapter da = new sqldataadapter(cmd);
![the table fields returns sp not showing][1] dataset ds = new dataset();
da.fill(ds);
int count = ds.tables.count;
for (int = 0; < count; i++)
{
datatable dt = new datatable();
dt = ds.tables[i];
rv_saldetails.localreport.reportembeddedresource = "reportview.report_sal_det.rdlc";
rv_saldetails.localreport.datasources.add(new microsoft.reporting.webforms.reportdatasource("dataset_sal",dt));
}
Comments
Post a Comment