String Qstr1;
OleDbDataAdapter dataAD;
string Qstr2;
OleDbDataAdapter dataAD2;
string Qstg_sale_history;
OleDbDataAdapter dataAD_history;
DataSet dss = new DataSet();
DB_Connect.Get_Connection().Open_Con();// open conn
string ID = GV.SelectedRows[0].Cells[0].Value.ToString();
dss.Clear();
Qstr1 = "select * from inv_view where invoices.ID = " + ID;
dataAD = new OleDbDataAdapter(Qstr1, DB_Connect.Get_Connection().Connection);
dataAD.Fill(dss, "inv_view");
dataAD.Dispose();
Qstr2 = "select * from inv_pay where inv_id = " + ID;
dataAD2 = new OleDbDataAdapter(Qstr2, DB_Connect.Get_Connection().Connection);
dataAD2.Fill(dss, "inv_pay");
dataAD2.Dispose();
Qstg_sale_history = "select * from sales_history_view where inv_id = " + ID;
dataAD_history = new OleDbDataAdapter(Qstg_sale_history, DB_Connect.Get_Connection().Connection);
dataAD_history.Fill(dss, "sales_history_view");
dataAD_history.Dispose();
DB_Connect.Get_Connection().Close_Con();// Close conn
Invoice_Rec rep = new Invoice_Rec();
//rep.Subreports[0].DataSourceConnections.Clear();
//rep.Subreports[0].SetDataSource(dss.Tables[2]);
rep.SetDataSource(dss);
Reports_form frm = new Reports_form();
frm.CrystalReportViewer1.ReportSource = rep;
frm.ShowDialog();
frm.Dispose();
dataAD.Dispose();
dataAD2.Dispose();
dss.Dispose();
