DataGrid加入CheckBox

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace eMeng.Exam.DataGridCheckBox
{
 /// <summary>
 /// DataGridCheckBox 的摘要说明。
 /// </summary>
 public class DataGridCheckBox : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.Button cmdSelectAll;
  protected System.Web.UI.WebControls.Button cmdFindSelected;
  protected System.Web.UI.WebControls.DataGrid dgMain;
  protected System.Web.UI.WebControls.Label Label1;
  DataView oDataView;
  string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
   + HttpContext.Current.Server.MapPath("../../aspxWeb.mdb.ascx");

  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   dgMain.Columns[0].HeaderText = "选项";
   dgMain.Columns[1].HeaderText = "序号";
   dgMain.Columns[2].HeaderText = "标题";
   cmdFindSelected.Text = "查看选中的项目";
   RefreshGrid();
   if( !this.IsPostBack)
   {
    cmdSelectAll.Text = "全部选中";
    dgMain.DataBind();
   }
  }
 #region Web Form Designer generated code
 override protected void OnInit(EventArgs e)
 {
  //
  // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
  //
  InitializeComponent();
  base.OnInit(e);
 }

 /// <summary>
 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 /// 此方法的内容。
 /// </summary>
 private void InitializeComponent()
 {
  this.cmdSelectAll.Click += new System.EventHandler(this.cmdSelectAll_Click);
  this.cmdFindSelected.Click += new System.EventHandler(this.cmdFindSelected_Click);
  this.Load += new System.EventHandler(this.Page_Load);

 }
 #endregion

  private void cmdSelectAll_Click(object sender, System.EventArgs e)
  {
   selectAll();
  }

  private void selectAll()
  {
   System.Web.UI.WebControls.CheckBox chkExport ;
   if( cmdSelectAll.Text == "全部选中")
   {
    foreach(DataGridItem oDataGridItem in dgMain.Items)
    {
     chkExport = (CheckBox)oDataGridItem.FindControl("chkExport");
     chkExport.Checked = true;
    }
    cmdSelectAll.Text = "全部不选";
   }
   else
   {
    foreach(DataGridItem oDataGridItem in dgMain.Items)
    {
     chkExport = (CheckBox)oDataGridItem.FindControl("chkExport");
     chkExport.Checked = false;
    }
    cmdSelectAll.Text = "全部选中";
   }
  }

  private void RefreshGrid()
  {
   OleDbConnection oConnection;
   OleDbDataAdapter oCommand ;
   DataSet oDataSet = new DataSet();
   try
   {
    string sSQL = "Select top 10 * from Document order by id";
    oConnection = new OleDbConnection(sConnectionString);
    oCommand = new OleDbDataAdapter(sSQL.ToString(), oConnection);
    oCommand.Fill(oDataSet, "Document");
    oDataView = new DataView(oDataSet.Tables["Document"]);
    dgMain.DataSource = oDataView;
    oConnection.Close();
   }
   catch(Exception ex)
   {
    Label1.Text = ex.Message.ToString();
   }
  }

  private void cmdFindSelected_Click(object sender, System.EventArgs e)
  {
   System.Web.UI.WebControls.CheckBox chkExport;
   System.Collections.ArrayList oExArgs = new System.Collections.ArrayList();
   string sID;
   Label1.Text = "";
   foreach(DataGridItem oDataGridItem in dgMain.Items)
   {
    chkExport = (CheckBox)oDataGridItem.FindControl("chkExport");
    if( chkExport.Checked)
    {
     Label1.Text = "";
     sID = ((Label)oDataGridItem.FindControl("lblColumn")).Text;
     oExArgs.Add(sID);
     int i = 0;
     for( i = 0;i<oExArgs.Count;i++)
     {
      Label1.Text += oExArgs[i] + "<br>";
     }
    }
   }
  }
 }
}