Выгрузка данных из базы в dataGridView

void Forma5503BUX()
        {
            
            List<string> errorMessage = new List<string>();
            DataSet ds = new DataSet();
            //ds.Reset();
            string sql = "with general as (select ac.*,ISNULL(isnull(ac.seria,case when typecard>0 then [OmskMarsh].[dbo].getseria(ac.idcard, ac.paymentdate) else null end),[OmskMarsh].[dbo].um_cards.series) as actual_series FROM [OmskMarsh].[dbo].[accounttable_] ac join [OmskMarsh].[dbo].r_title_ rt on ac.idRoute=rt.idRoute left join [OmskMarsh].[dbo].um_cards on ac.idcard=[OmskMarsh].[dbo].um_cards.idcard join [OmskMarsh].[dbo].[TermReport_] on ac.idterminal=[OmskMarsh].[dbo].[TermReport_].idTerminal where [OmskMarsh].[dbo].[TermReport_].ReadDate between cast('" + toolStripTextBox1.Text + "' as datetime) and cast('" + toolStripTextBox2.Text + "' as datetime) and ac.idSubdivision in (90,94,93,91,103,92,104,98,72,45,73,38,87,55,61,64,39,86,53,60,46,57,68,75,42,82,62,65,30,48,34,136,66,143) and ac.indx between [OmskMarsh].[dbo].[TermReport_].beginIndx and [OmskMarsh].[dbo].[TermReport_].endIndx), beznal as (SELECT cast([OmskMarsh].[dbo].Enterprises.CodeUM as numeric) as code,count(case when actual_series = 87 then 1 else null end) as cc_87,cast(sum(case when actual_series = 87 then 16 else 0 end)as float) as ss_87,count(case when actual_series = 88 then 1 else null end) as cc_88,cast(sum(case when actual_series = 88 then 19 else 0 end) as float) as ss_88,count(case when actual_series = 89 then 1 else null end) as cc_89,cast(sum(case when actual_series = 89  then 19 else 0 end) as float)as ss_89,count(case when actual_series = 99  then 1 else null end) as cc_99,cast(sum(case when actual_series = 99   then 21 else 0 end) as float) as ss_99,count(case when actual_series in (87,88,89,99) then 1 else null end) as CC_ALL_EP,count(case when actual_series = 85  then 1 else null end) as cc_85,count(case when actual_series = 86  then 1 else null end) as cc_86,count(case when actual_series = 91  then 1 else null end) as cc_91,count(case when actual_series = 92  then 1 else null end) as cc_92,count(case when actual_series in (85,86,91,92) then 1 else null end) as ALL_su,count(case when actual_series = 97  then 1 else null end) as cc_97,cast(sum(case when actual_series = 97  then 19 else 0 end)as float) as ss_97,count(case when actual_series = 98  then 1 else null end) as cc_98,cast(sum(case when actual_series = 98  then 20 else 0 end)as float) as ss_98,cast(sum(case when actual_series in (97,98) then finalcost else 0 end)as float) as SS_ALL_SL from general ss join [OmskMarsh].[dbo].Subdivisions_ on ss.idSubdivision=[OmskMarsh].[dbo].Subdivisions_.idSubdivision join [OmskMarsh].[dbo].Enterprises on [OmskMarsh].[dbo].Subdivisions_.EnterprisesINN=[OmskMarsh].[dbo].Enterprises.INN group by [OmskMarsh].[dbo].Enterprises.CodeUM ),nal as (select cast([OmskMarsh].[dbo].Enterprises.CodeUM as numeric) as code, [OmskMarsh].[dbo].Enterprises.EnterpriseName, count(case when ac.TypeCard=0 then 1 else null end) as cc_cash,cast(sum(case when ac.TypeCard=0 then ac.finalcost else 0 end)as float) as ss_cash,count(case when ac.TypeCard=2 then 1 else null end) as cc_OL from [OmskMarsh].[dbo].[accounttable_] ac join [OmskMarsh].[dbo].r_title_ rt on ac.idRoute=rt.idRoute join [OmskMarsh].[dbo].Subdivisions_ on ac.idSubdivision=[OmskMarsh].[dbo].Subdivisions_.idSubdivision join [OmskMarsh].[dbo].Enterprises on [OmskMarsh].[dbo].Subdivisions_.EnterprisesINN=[OmskMarsh].[dbo].Enterprises.INN join [OmskMarsh].[dbo].[TermReport_] on ac.idterminal=[OmskMarsh].[dbo].[TermReport_].idTerminal where [OmskMarsh].[dbo].[TermReport_].ReadDate between cast('" + toolStripTextBox1.Text + "' as datetime) and cast('" + toolStripTextBox2.Text + "' as datetime)and ac.idSubdivision in (90,94,93,92,91,103)and ac.indx between [OmskMarsh].[dbo].[TermReport_].beginIndx and [OmskMarsh].[dbo].[TermReport_].endIndx group by [OmskMarsh].[dbo].Enterprises.CodeUM,[OmskMarsh].[dbo].Enterprises.EnterpriseName union all select cast([OmskMarsh].[dbo].Enterprises.CodeUM as numeric) as code, [OmskMarsh].[dbo].Enterprises.EnterpriseName,count(case when ac.TypeCard=0 then 1 else null end) as cc_cash,cast(sum(case when ac.TypeCard=0 then ac.finalcost else 0 end)as float) as ss_cash,count(case when ac.TypeCard=2 then 1 else null end) as cc_OL from [OmskMarsh].[dbo].[accounttable_] ac join [OmskMarsh].[dbo].r_title_ rt on ac.idRoute=rt.idRoute join [OmskMarsh].[dbo].Subdivisions_ on ac.idSubdivision=[OmskMarsh].[dbo].Subdivisions_.idSubdivision join [OmskMarsh].[dbo].Enterprises on [OmskMarsh].[dbo].Subdivisions_.EnterprisesINN=[OmskMarsh].[dbo].Enterprises.INN join [OmskMarsh].[dbo].[TermReport_] on ac.idterminal=[OmskMarsh].[dbo].[TermReport_].idTerminal where [OmskMarsh].[dbo].[TermReport_].ReadDate between cast('" + toolStripTextBox1.Text + "' as datetime) and cast('" + toolStripTextBox2.Text + "' as datetime)and ac.indx between [OmskMarsh].[dbo].[TermReport_].beginIndx and [OmskMarsh].[dbo].[TermReport_].endIndx and ac.idSubdivision=104 and rt.route_nmb in ('115 ','115П','123','123П','124','124П','127','127П','132','132П','138','138П','163','163П','169','169П','199','199П','214','214П','319','319П','324','324П','336','336П','337','337П','353','353П') group by [OmskMarsh].[dbo].Enterprises.CodeUM,[OmskMarsh].[dbo].Enterprises.EnterpriseName union all select cast([OmskMarsh].[dbo].Enterprises.CodeUM as numeric) as code, [OmskMarsh].[dbo].Enterprises.EnterpriseName,count(case when ac.TypeCard=0 then 1 else null end) as cc_cash,cast(sum(case when ac.TypeCard=0 then ac.finalcost else 0 end)as float) as ss_cash,count(case when ac.TypeCard=2 then 1 else null end) as cc_OL from [OmskMarsh].[dbo].[accounttable_] ac join [OmskMarsh].[dbo].r_title_ rt on ac.idRoute=rt.idRoute left join [OmskMarsh].[dbo].um_cards on ac.idcard=[OmskMarsh].[dbo].um_cards.idcard join [OmskMarsh].[dbo].Subdivisions_ on ac.idSubdivision=[OmskMarsh].[dbo].Subdivisions_.idSubdivision join [OmskMarsh].[dbo].Enterprises on [OmskMarsh].[dbo].Subdivisions_.EnterprisesINN=[OmskMarsh].[dbo].Enterprises.INN join [OmskMarsh].[dbo].[TermReport_] on ac.idterminal=[OmskMarsh].[dbo].[TermReport_].idTerminal where [OmskMarsh].[dbo].[TermReport_].ReadDate between cast('" + toolStripTextBox1.Text + "' as datetime) and cast('" + toolStripTextBox2.Text + "' as datetime) and ac.idSubdivision not in (90,94,93,92,91,103,104,130) and rt.EnbSocCard=1 and ac.indx between [OmskMarsh].[dbo].[TermReport_].beginIndx and [OmskMarsh].[dbo].[TermReport_].endIndx group by [OmskMarsh].[dbo].Enterprises.CodeUM,[OmskMarsh].[dbo].Enterprises.EnterpriseName) select nal.code,nal.EnterpriseName,nal.cc_cash,nal.ss_cash,cc_87,ss_87,cc_88,ss_88,cc_89,ss_89,cc_99,ss_99,beznal.CC_ALL_EP,beznal.cc_85,beznal.cc_86,beznal.cc_91,beznal.cc_92,beznal.ALL_su,beznal.cc_97,beznal.ss_97,beznal.cc_98,beznal.ss_98,beznal.SS_ALL_SL,nal.cc_OL from nal,beznal where nal.code=beznal.code order by 1;";
                //string sql = "Select ROW_NUMBER() OVER(ORDER BY ps.Description DESC) AS '№',ps.Description as Название,cast(sum(rep.saleSum)as int )as Сумма from OmskMarsh.dbo.rep_SoldCards_ rep join [OmskMarsh].[dbo].[pointsOfSales_] ps on ps.idPOS = rep.idPOS join [OmskMarsh].[dbo].[Subdivisions_] sub on sub.idSubdivision = rep.idSubdivision where  sub.sName='" + toolStripComboBox1.Text + "' and rep.saleDate between CONVERT(DATETIME, '" + toolStripTextBox1.Text + "', 102) and CONVERT(DATETIME, '" + toolStripTextBox2.Text + "', 102) GROUP BY ps.Description order by 1 ";
 
            try
            {
                using (SqlConnection com = new SqlConnection(@"Data Source=" + Properties.Settings.Default.IP + "," + Properties.Settings.Default.PORT + ";Initial Catalog=" + Properties.Settings.Default.NAMEBASE + ";User Id=" + Properties.Settings.Default.LOGIN + ";Password=" + Properties.Settings.Default.PASSWORD))
                {
                    com.Open();
                    toolStripStatusLabel4.Text = "Выполняется!...";
                   com.Disposed += new EventHandler(conn_Disposed);
                    using (SqlDataAdapter da = new SqlDataAdapter(sql, com))
                    {
                        da.Fill(ds);
                        dataGridView1.DataSource = ds.Tables[0].DefaultView;
                        toolStripStatusLabel2.Text = Convert.ToString(dataGridView1.Rows.Count);    
                    }
                    com.Close();
                    toolStripStatusLabel4.Visible = true;
                }
            }
            catch (SqlException err)
            {
                MessageBox.Show(err.ToString());
            }
        }