Quote:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
try { string strQry = "select distinct invoice_date,(select sum(amount) from sold_items B where B.invoice_date = A.invoice_date and B.pay_mode=A.pay_mode and tax_percent = '00.00') as taxFree,(select sum(amount) from sold_items C where C.invoice_date = A.invoice_date and C.pay_mode=A.pay_mode and tax_percent = '5.00') as amountSub5,(select sum(amount) from sold_items D where D.invoice_date = A.invoice_date and D.pay_mode=A.pay_mode and tax_percent = '14.00') as amountSub14,pay_mode from sold_items A where invoice_date between '" + dtfrom + "' and '" + dtto + "'"; MySqlDataAdapter da = new MySqlDataAdapter(strQry, con); DataSet2 ds1 = new DataSet2(); da.Fill(ds1, "saletaxreport"); CRsaletaxreport pr = new CRsaletaxreport(); pr.SetDataSource(ds1); pr.VerifyDatabase(); crystalReportViewer1.ReportSource = pr; } catch (Exception ex) { throw ex; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)