创建与旧的DataTable同样架构的DataTable 并把符合条件的数据填充的新DataTable中 并把旧表的重复数据去掉

//查询数据库并创建表  GetDataTableBySql为查询方法

 

            DataTable dt1= GetDataTableBySql("select * from table where a="" );

            //创建相同架构的表

            DataTable dt2= dt1.Clone();

 

             / /循环旧表 取出某条件下的表行

 

             for(int i=0;i<dt1.rows.count;i++)

 

                {

 

                        //查询旧表某条件下的行

 

                          DataRow[] dt1dr = dt1.Select("name=" i );

 

                        //循环dt1表行

 

                          foreach (DataRow dr  in dt1dr)

                                  {

                                       //如果新表中没有重复的就插入到dt2中

 

                                       if (dt2.Select("BH = '" + dt1dr["BH"].ToString() + "'").Length == 0)//查询是否有重复BH

 

                                         {

                                              DataRow dr2 = dt2.NewRow();//创建新表行  如何不创建新表行直接赋值用dr添加到新表中会出错

                                              dr2.ItemArray = dr.ItemArray;//给新表行赋值

 

                                             dt2.Rows.Add(dr);//添加到新表中

                                          }

                                   }

 

            }