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");
}
