C# jque DataGrid后台SQL查询数据重新赋值并返回 DataTable dt1 = new DataTable();

　　　　string Sql = string.Format(@"select  * from dual where 1=1 and id='{0}'", h.Attr1.Trim());//查询语句

　　　　DataSet ds = new DataSet();
                ds = ConnInstance.AspPager(pageSize, pageIndex, Sql, "dt", ref count);

 

#region 重新賦值新錶
                    DataTable dt1 = new DataTable(); //新增表列名称
                    dt1.Columns.Add("Subsidy1");
                    dt1.Columns.Add("Subsidy2");
                    dt1.Columns.Add("Subsidy3");
                    dt1.Columns.Add("Subsidy4");
                    dt1.Columns.Add("Subsidy5");
                    dt1.Columns.Add("Subsidy6");
                    dt1.Columns.Add("Subsidy7");
                    dt1.Columns.Add("Subsidy8");
                    dt1.Columns.Add("Subsidy9");
                    dt1.Columns.Add("Subsidy10");
                    dt1.Columns.Add("Subsidy11");
                    dt1.Columns.Add("Subsidy12");

                    DataRow dr; //定义赋值函数格式
                    dr = dt1.NewRow();
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //游历SQL查询到的数据
                    {
                        string Wdate1 = ds.Tables[0].Rows[i]["Wdate"].ToString();//獲取月份
                        for (int j = 0; j < 13; j++)
                        {
                            string Wdate2 = Convert.ToString(j + 1);
                            if (j < 10)
                            {
                                Wdate2 = "0" + Wdate2;
                                //string aa = Wdate1.Substring(5, 2);
                            }
                            if (Wdate1.Substring(5, 2) == Wdate2)
                            {
                                dr["Subsidy" + (j + 1)] = ds.Tables[0].Rows[i]["subsidy"].ToString();  //赋值ds表的列值
                            }
                        }


                    }

                    dt1.Rows.Add(dr);  //绑定新datatable表dt1