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

[upc_xiaowei]

谢谢大家了。

[koumingjie]

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

[koumingjie]

        /// <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);

[koumingjie]

               ///   <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); 

[Leon_He2014]

楼主问的是C#？

[AcHerat]

没搞懂你的意思唉！中秋快乐！

[--小F--]

select col1,col2,col3 into #tb from tb

[xuam]

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

[pigengler]

楼上 fredrickhu 正解

[dawugui]

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

[gw6328]

投影运算

[upc_xiaowei]

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