求从一个datatable中选取某几列组成一个新datatable的方法

Question

谢谢大家了。

Answer 1

select col1,col2,col3 into #tb from tb

Answer 2

insert into tb2 (col1,col2,col3) select col1,col2,col3 from tb1

Answer 3

select 列出你需要的列... from tb

Answer 4

怎么执行select这条语句啊？
Datetable dt1;
Datetable dt2;
dt2.select()?

Answer 5

 DataTable dt=new DataTable ();
 string name="张三";
 DataRow[] drs = dt.Select("name='" + name + "'");

Answer 6

        /// <summary>   
        /// 将DataRow数组的数据复制到DataTable中  
        /// </summary>   
        /// <param name="sourceDt">DataTable</param>   
        /// <param name="drs">DataRow数组</param>   
        public void  CotyRowsToDataTable(DataTable sourceDt,DataRow [] drs)
        {
           
             DataRow tempRow;             for (int i = 0; i < drs.Length; i++)
             {
                 tempRow = sourceDt.NewRow();
                 tempRow.ItemArray = drs[i].ItemArray;
                 sourceDt.Rows.Add(tempRow);
             }
           
      
        }
 DataTable dt1=new DataTable ();
 DataTable dt2=new DataTable (); string name="张三";
 DataRow[] drs = dt1.Select("name='" + name + "'");CotyRowsToDataTable(dt2,drs);

Answer 7

               ///   <summary>       
                ///   将DataRow数组的数据复制到DataTable中     
                ///   </summary>       
                ///   <param   name= "sourceDt "> DataTable </param>       
                ///   <param   name= "drs "> DataRow数组 </param>       
                public   void     CotyRowsToDataTable(DataTable   sourceDt,DataRow   []   drs) 
                { 
                      
                          DataRow   tempRow;                           for   (int   i   =   0;   i   <   drs.Length;   i++) 
                          { 
                                  tempRow   =   sourceDt.NewRow(); 
                                  tempRow.ItemArray   =   drs[i].ItemArray; 
                                  sourceDt.Rows.Add(tempRow); 
                          } 
                      
            
                } 
  DataTable   dt1=new   DataTable   (); 
  DataTable   dt2=new   DataTable   ();   string   name= "张三 "; 
  DataRow[]   drs   =   dt1.Select( "name= ' "   +   name   +   " ' "); CotyRowsToDataTable(dt2,drs);