解决Datatable按字段顺序绑定DataGridView问题

#region 不按日期查询 
            if (this.ckb_日期段.Checked == false && this.ckb_交货日期.Checked == false)
            {
                if (c.blkz == "排单总表")
                {
                    //
                    con.Open();
                    SqlDataAdapter sqlda = new SqlDataAdapter(@"select scd_lsh,scd_djbh 生产单号,scd_ywybh 业务员编号,scd_ywyxm 业务员,scd_dwbh 单位编号,scd_dwmc 单位名称,scd_cpbh 产品编号,scd_cpmc 产品名称,scd_cpgg 产品规格,scd_zdrq 制单日期,
                                                                scd_ylbh 用布编号,scd_jhrq 要求交货日期,scd_dfrq 答复日期,scd_sjwcrq 实际完成日期,scd_ddzt 订单状态,scd_ddbz 订单备注,scd_tsjh 特殊计划,scd_tssm+scd_c1 下单数量,b_wllbzd.wllbzd_lbmc 用途,scd_ylmc 用布,
                                                                scd_fm_dcsc 彩复要求,case when scd_zl_nmzl>0 then cast(scd_zl_nmzl as varchar(10))+'克'+scd_zl_zlyq+substring(scd_bz,charindex('*', scd_bz) - 2, 6) else null end  内膜,
                                                                case when scd_cy_cmkd>0 then scd_cy_cmmc else null end 彩膜,case when scd_cy_cmkd>0 then scd_cy_cmkd else null end 膜宽, case when scd_cy_cmkd>0 then scd_cy_ban else null end 彩版,
                                                                case when scd_zl_sfzz='是' then '中折' else '' end+case when scd_zl_sfywz='是' then '移位折' else '' end+case when scd_zl_dk='是' then '打孔' else '' end+case when scd_zl_dts='是' then '打提手' else '' end+case 
                                                                when scd_zl_rfd='是' then '热缝底' else '' end+case when scd_sffw ='是' then '防伪' else '' end 特殊工艺,case when len(scd_py_ys)>0 then scd_py_ys+' '+scd_py_ban else null end 普印 
                                                                from b_scd LEFT OUTER JOIN   dbo.B_WLZD ON dbo.B_SCD.SCD_CPBH = dbo.B_WLZD.WLZD_WLBH LEFT OUTER JOIN dbo.B_WLLBZD ON dbo.B_WLZD.WLZD_LBBH = dbo.B_WLLBZD.WLLBZD_LBBH where (scd_djbh like '%" 
                                                                                        + this.txt_生产单号.Text.Trim() + "%') and (scd_ywyxm  like '%" + this.cbx_业务员.Text.Trim() + "%') and (scd_dwmc like '%" + this.txt_客户名.Text.Trim() + "%') and (scd_cpmc like '%" 
                                                                                        + this.txt_品名.Text.Trim() + "%') and (isnull(scd_gdry,'') like '%" + this.cbx_gdry.Text.Trim() + "%') and (isnull(scd_fm_dcsc,'') like '%" + this.cbx_fm_dcsc.Text.Trim() 
                                                                                        + "%') and (isnull(scd_bffkf,'') like '%" + this.cbx_bffkf.Text.Trim() + "%') order by scd_lsh desc", con);
                    DataSet ds = new DataSet();
                    sqlda.Fill(ds);
                    con.Close();
                    c.dataGridView1.DataSource = ds.Tables[0].DefaultView;
                    #region 设置列格式
                    //c.dataGridView1.Columns[5].Width = 250;
                    //c.dataGridView1.Columns[7].Width = 250;
                    //设置字体大小
                    c.dataGridView1.RowsDefaultCellStyle.Font = new Font("宋体", 9, FontStyle.Regular);
                    c.dataGridView1.Columns[0].Visible = false;
                    c.dataGridView1.Columns[2].Visible = false;
                    c.dataGridView1.Columns[4].Visible = false;
                    c.dataGridView1.Columns[6].Visible = false;