创建DataTable并向里面插入数据
DataTable RecordList = new DataTable();//新建一个表
            RecordList.Columns.Add("T_SN", typeof(int));//表中的字段
            RecordList.Columns.Add("T_Title", typeof(string));
            RecordList.Columns.Add("T_A", typeof(string));
            RecordList.Columns.Add("T_B", typeof(string));
            RecordList.Columns.Add("T_C", typeof(string));
            RecordList.Columns.Add("T_D", typeof(string));
            RecordList.Columns.Add("T_DaAn", typeof(string));
            RecordList.Columns.Add("T_IsDanXuan", typeof(int));
            RecordList.Columns.Add("T_Fraction", typeof(int));
            RecordList.Columns.Add("T_WenDaDaAn", typeof(string));
            DataRow[] drs = RecordList_Data.Select("T_IsDanXuan =1", "");//取出单选列表
            DataTable dt = MethodLibrary.GetTable(drs);//将datarow[] 填充到datatable中
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                RecordList.Rows.Add(Convert.ToInt32(dt.Rows[i]["T_SN"]), dt.Rows[i]["T_Title"].ToString(), dt.Rows[i]["T_A"].ToString(), dt.Rows[i]["T_B"].ToString(), dt.Rows[i]["T_C"].ToString(), dt.Rows[i]["T_D"].ToString(), dt.Rows[i]["T_DaAn"].ToString(), dt.Rows[i]["T_IsDanXuan"].ToString(), dt.Rows[i]["T_Fraction"].ToString(), dt.Rows[i]["T_WenDaDaAn"].ToString());//插入数据
            }
            drs = RecordList_Data.Select("T_IsDanXuan =2", "");//取出多选列表
            dt = MethodLibrary.GetTable(drs);//将datarow[] 填充到datatable中
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                RecordList.Rows.Add(Convert.ToInt32(dt.Rows[i]["T_SN"]), dt.Rows[i]["T_Title"].ToString(), dt.Rows[i]["T_A"].ToString(), dt.Rows[i]["T_B"].ToString(), dt.Rows[i]["T_C"].ToString(), dt.Rows[i]["T_D"].ToString(), dt.Rows[i]["T_DaAn"].ToString(), dt.Rows[i]["T_IsDanXuan"].ToString(), dt.Rows[i]["T_Fraction"].ToString(), dt.Rows[i]["T_WenDaDaAn"].ToString());
            }
 
                    
                     
                    
                 
                    
                
 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号