private void SetDataSource(ReportDocument Report) { string TransactionNo = Session["tranno"].ToString(); ReportDataset rptds = new ReportDataset(); Stock clsStock = new Stock(); DataTable dt = clsStock.Search(TransactionNo); clsStock.CommitAndDispose(); long StockID = Convert.ToInt64(dt.Rows[0]["StockID"].ToString()); StockItem clsStockItem = new StockItem(); DataTable dtItems = clsStockItem.ListAsDataTable(StockID); clsStockItem.CommitAndDispose(); foreach(DataRow dr in dt.Rows) { DataRow drNew = rptds.Stocks.NewRow(); foreach (DataColumn dc in rptds.Stocks.Columns) drNew[dc] = dr[dc.ColumnName]; rptds.Stocks.Rows.Add(drNew); } foreach(DataRow dr in dtItems.Rows) { DataRow drNew = rptds.StockItems.NewRow(); foreach (DataColumn dc in rptds.StockItems.Columns) drNew[dc] = dr[dc.ColumnName]; rptds.StockItems.Rows.Add(drNew); } Report.SetDataSource(rptds); SetParameters(Report); }
private void LoadItems() { DataClass clsDataClass = new DataClass(); StockItem clsStockItem = new StockItem(); lstItem.DataSource = clsStockItem.ListAsDataTable(Convert.ToInt64(lblStockID.Text)).DefaultView; lstItem.DataBind(); clsStockItem.CommitAndDispose(); ComputeAmount(); }