private void LoadItems() { CreditMemoItems clsCreditMemoItems = new CreditMemoItems(); lstItem.DataSource = clsCreditMemoItems.ListAsDataTable(Convert.ToInt64(lblCreditMemoID.Text)).DefaultView; lstItem.DataBind(); clsCreditMemoItems.CommitAndDispose(); }
private void SetDataSource(ReportDocument Report) { long iID = 0; try { if (Request.QueryString["task"].ToString().ToLower() == "reportfromposted" && Request.QueryString["retid"].ToString() != null) { iID = Convert.ToInt64(Request.QueryString["retid"].ToString()); } else { iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["retid"].ToString(), Session.SessionID)); } lblReferrer.ToolTip = iID.ToString(); } catch { iID = long.Parse(lblReferrer.ToolTip); } ReportDataset rptds = new ReportDataset(); CreditMemos clsCreditMemos = new CreditMemos(); MySqlDataReader myreader = clsCreditMemos.List(iID, "CreditMemoID", SortOption.Ascending); while (myreader.Read()) { DataRow drNew = rptds.CreditMemo.NewRow(); foreach (DataColumn dc in rptds.CreditMemo.Columns) { drNew[dc] = "" + myreader[dc.ColumnName]; } rptds.CreditMemo.Rows.Add(drNew); } myreader.Close(); CreditMemoItems clsCreditMemoItems = new CreditMemoItems(clsCreditMemos.Connection, clsCreditMemos.Transaction); System.Data.DataTable dt = clsCreditMemoItems.ListAsDataTable(iID); foreach (System.Data.DataRow dr in dt.Rows) { DataRow drNew = rptds.CreditMemoItem.NewRow(); foreach (DataColumn dc in rptds.CreditMemoItem.Columns) { drNew[dc] = "" + dr[dc.ColumnName]; } rptds.CreditMemoItem.Rows.Add(drNew); } clsCreditMemos.CommitAndDispose(); Report.SetDataSource(rptds); SetParameters(Report); }