对DataTable进行列选择

/// <summary>
  /// 重载的构造函数
  /// </summary>
  /// <param name="dt">要进行选择的表</param>
  /// <param name="s"></param>
  /// <param name="sc">要打印的标题</param>
  public ChoosePrint(DataTable dt,string s,string sc):this()
  {
   this.dt=dt;
   scaption=sc;
   
   if(dt.Columns.Count<1)
    return;
   
   checkedListBox1.Items.AddRange(getCol(dt));
   checkedListBox1.CheckOnClick=true;
   this.dg1.DataSource=null;
   
   sort=s;
   //MessageBox.Show(sort);
   
  }
  /// <summary>
  /// 得到列名
  /// </summary>
  /// <param name="dt"></param>
  /// <returns></returns>
  public string[] getCol(DataTable dt)
  {
   string[] al=new string[dt.Columns.Count];
   
   for(int i=0;i<dt.Columns.Count;i++)
   {
    
    al[i]=dt.Columns[i].ColumnName;
   }
   return al;
  }

/// <summary>
  /// 根据选择的列重新构造表
  /// </summary>
  /// <returns></returns>
  DataTable ReCreate()
  {
   if (checkedListBox1.CheckedItems.Count<1)
   return null;
//   else if (checkedListBox1.CheckedItems.Count==checkedListBox1.Items.Count)
//   return dt;

   DataTable dtt2 = new DataTable();
   for (int i=0;i<checkedListBox1.CheckedItems.Count;i++)
   {
    dtt2.Columns.Add(new DataColumn(checkedListBox1.CheckedItems[i].ToString(),
     dt.Columns[checkedListBox1.CheckedItems[i].ToString()].DataType));
   }
   foreach(DataRow myRow in dt.Rows)
   {
    DataRow dr = dtt2.NewRow();
    for (int i=0;i<checkedListBox1.CheckedItems.Count;i++)
    {
     dr[checkedListBox1.CheckedItems[i].ToString()] = myRow[checkedListBox1.CheckedItems[i].ToString()];
    }
    dtt2.Rows.Add(dr);
   }
   
   return dtt2;
  }