private void View_HLS_SOA(int iSOAkey) { SqlConnection cn = new SqlConnection(GlobalClass.SQLConnString()); string query = ""; cn.Open(); query = "SELECT * FROM tbl_HLS_StatementOfAccountReport WHERE (PK = " + iSOAkey + ")"; SqlDataAdapter sqlAdSOA = new SqlDataAdapter(query, cn); query = "SELECT * FROM tbl_HLS_StatementOfAccountReport_Det WHERE (MasterKey = " + iSOAkey + ")"; SqlDataAdapter sqlAdSOADet = new SqlDataAdapter(query, cn); cn.Close(); datasets.DataSetSOA hlsSOA = new datasets.DataSetSOA(); sqlAdSOA.Fill(hlsSOA, "tbl_HLS_StatementOfAccountReport"); sqlAdSOADet.Fill(hlsSOA, "tbl_HLS_StatementOfAccountReport_Det"); //XtraReport myRpt = new XtraReport(); //myRpt.DataSource = hlsSOA; //ASPxWebDocumentViewer1.OpenReport(); //XtraReport1 myRpt = new XtraReport1(); //myRpt.DataSource = hlsSOA; }
private void View_HLS_SOA(int iSOAkey) { SqlConnection cn = new SqlConnection(GlobalClass.SQLConnString()); string query = ""; cn.Open(); query = "SELECT * FROM tbl_HLS_StatementOfAccountReport WHERE (PK = " + iSOAkey + ")"; SqlDataAdapter sqlAdSOA = new SqlDataAdapter(query, cn); query = "SELECT * FROM tbl_HLS_StatementOfAccountReport_Det WHERE (MasterKey = " + iSOAkey + ")"; SqlDataAdapter sqlAdSOADet = new SqlDataAdapter(query, cn); query = "SELECT * FROM tbl_HLS_StatementOfAccountReport_Sub WHERE (MasterKey = " + iSOAkey + ")"; SqlDataAdapter sqlAdSOASub = new SqlDataAdapter(query, cn); cn.Close(); datasets.DataSetSOA hlsSOA = new datasets.DataSetSOA(); sqlAdSOA.Fill(hlsSOA, "tbl_HLS_StatementOfAccountReport"); sqlAdSOADet.Fill(hlsSOA, "tbl_HLS_StatementOfAccountReport_Det"); datasets.DataSetSOASub hlsSOASub = new datasets.DataSetSOASub(); sqlAdSOASub.Fill(hlsSOASub, "tbl_HLS_StatementOfAccountReport_Sub"); }