Connection Timeout Problem with MySqlDataAdapter, how to exceed this.

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