为DataGrid添加CheckBox控件

转载 2006年06月15日 14:43:00

VB.NET 版本

CheckBoxDataGrid.aspx

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="CheckBoxDataGrid.aspx.vb"
 Inherits="aspxWeb.CheckBoxDataGrid" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
  <HEAD>
    <title>为DataGrid添加CheckBox控件的例子</title>
    <meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
    <meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
    <meta name="vs_defaultClientScript" content="JavaScript">
    <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
  </HEAD>
  <body MS_POSITIONING="GridLayout">
    <form id="frmMain" method="post" runat="server">
      <asp:DataGrid id="dgMain" runat="server" Width="98%" AutoGenerateColumns="False">
        <SelectedItemStyle Font-Size="9pt" Font-Names="宋体"></SelectedItemStyle>
        <EditItemStyle Font-Size="9pt" Font-Names="宋体" Font-Bold="True" ForeColor="Red" BackColor="Info"/>
        <AlternatingItemStyle Font-Size="9pt" Font-Names="宋体" ForeColor="ControlText" BackColor="White"/>
        <ItemStyle Font-Size="9pt" Font-Names="宋体" ForeColor="ControlText" BackColor="WhiteSmoke"/>
        <HeaderStyle Font-Bold="True" HorizontalAlign="Center" ForeColor="Black"
         VerticalAlign="Middle" BackColor="Control">
        </HeaderStyle>
        <Columns>
          <asp:TemplateColumn HeaderText="操作">
            <HeaderStyle HorizontalAlign="Center" Width="50px"></HeaderStyle>
            <ItemTemplate>
              <asp:CheckBox ID="chkExport" Runat="server" />
            </ItemTemplate>
            <EditItemTemplate>
              <asp:CheckBox ID="chkExportON" Runat="server" Enabled="true" />
            </EditItemTemplate>
          </asp:TemplateColumn>
          <asp:BoundColumn DataField="id" ReadOnly="True" HeaderText="序号">
            <HeaderStyle Width="50px"></HeaderStyle>
          </asp:BoundColumn>
          <asp:TemplateColumn SortExpression="demo" HeaderText="标题">
            <ItemTemplate>
              <asp:Label Text='<%# Server.HTMLEncode(DataBinder.Eval(Container.DataItem, "Title"))%>'
                runat="server" Width="80%" ID="lblColumn"/>
            </ItemTemplate>
          </asp:TemplateColumn>
        </Columns>
      </asp:DataGrid>
      <asp:Button id="cmdSelectAll" runat="server" Text="全部选中"></asp:Button>
      <asp:Button id="cmdFindSelected" runat="server" Text="查看选中的项目"></asp:Button>
      <br>
      <asp:Label id="Label1" runat="server"></asp:Label>
    </form>
  </body>
</HTML>

后代码 CheckBoxDataGrid.aspx.vb

Imports System.Data
Imports System.Data.OleDb

Public Class CheckBoxDataGrid
  Inherits System.Web.UI.Page
  Protected WithEvents cmdSelectAll As System.Web.UI.WebControls.Button
  Protected WithEvents dgMain As System.Web.UI.WebControls.DataGrid
  Protected WithEvents cmdFindSelected As System.Web.UI.WebControls.Button

  Dim oDataView As DataView
  Protected WithEvents Label1 As System.Web.UI.WebControls.Label
  Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="_
   + Server.MapPath("Test.mdb")


#Region " Web Form Designer Generated Code "

  'This call is required by the Web Form Designer.
  <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

  End Sub

  Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs)_
   Handles MyBase.Init
    'CODEGEN: This method call is required by the Web Form Designer
    'Do not modify it using the code editor.
    InitializeComponent()
  End Sub

#End Region

  Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)_
   Handles MyBase.Load
    'Put user code to initialize the page here
    dgMain.Columns(0).HeaderText = "选项"
    dgMain.Columns(1).HeaderText = "序号"
    dgMain.Columns(2).HeaderText = "标题"
    cmdFindSelected.Text = "查看选中的项目"
    RefreshGrid()
    If Not Page.IsPostBack Then
      cmdSelectAll.Text = "全部选中"
      dgMain.DataBind()
    End If

  End Sub


#Region "处理多选"
  Private Sub cmdSelectAll_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)_
   Handles cmdSelectAll.Click
    selectAll()
  End Sub

  Private Sub selectAll()
    Dim oDataGridItem As DataGridItem
    Dim chkExport As System.Web.UI.WebControls.CheckBox

    If cmdSelectAll.Text = "全部选中" Then
      For Each oDataGridItem In dgMain.Items
        chkExport = oDataGridItem.FindControl("chkExport")
        chkExport.Checked = True
      Next
      cmdSelectAll.Text = "全部不选"
    Else
      For Each oDataGridItem In dgMain.Items
        chkExport = oDataGridItem.FindControl("chkExport")
        chkExport.Checked = False
      Next
      cmdSelectAll.Text = "全部选中"
    End If
  End Sub
#End Region

#Region "更新DataGrid"

  Private Sub RefreshGrid()
    Dim oConnection As OleDbConnection
    Dim oCommand As OleDbDataAdapter
    Dim oDataSet As New DataSet()

    Try
      Dim sSQL As String = "Select top 5 * from TestTable order by id"
      oConnection = New OleDbConnection(sConnectionString)
      oCommand = New OleDbDataAdapter(sSQL.ToString, oConnection)
      oCommand.Fill(oDataSet, "TestTable")
      oDataView = New DataView(oDataSet.Tables("TestTable"))
      dgMain.DataSource = oDataView
      oConnection.Close()

    Catch ex As Exception
      '// Place Error Handling here
    End Try
  End Sub
#End Region

  Private Sub cmdFindSelected_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)_
   Handles cmdFindSelected.Click
    Dim oDataGridItem As DataGridItem
    Dim chkExport As System.Web.UI.WebControls.CheckBox
    Dim oExArgs As New System.Collections.ArrayList()
    Dim sID As String
    Label1.Text = ""
    For Each oDataGridItem In dgMain.Items
      chkExport = oDataGridItem.FindControl("chkExport")
      If chkExport.Checked Then
        Label1.Text = ""
        sID = CType(oDataGridItem.FindControl("lblColumn"), Label).Text
        oExArgs.Add(sID)
        Dim i As Integer = 0
        For i = 0 To oExArgs.Count - 1
          Label1.Text += oExArgs(i) + ","
        Next
      End If
    Next
  End Sub

End Class

C# 版本

CheckBoxDataGrid.aspx

<%@ Page language="c#" enableViewState = "true" Codebehind="DataGridCheckBox.aspx.cs"
AutoEventWireup="false" Inherits="eMeng.Exam.DataGridCheckBox.DataGridCheckBox" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>为DataGrid添加CheckBox控件的例子</title>
</HEAD>
<body>
<form id="frmMain" method="post" runat="server">
<asp:DataGrid id="dgMain" runat="server" Width="98%" AutoGenerateColumns="False" Font-Size="9pt" Font-Names="宋体">
 <AlternatingItemStyle ForeColor="ControlText" BackColor="White" />
 <ItemStyle ForeColor="ControlText" BackColor="WhiteSmoke" />
 <HeaderStyle Font-Bold="True" HorizontalAlign="Center" ForeColor="Black" VerticalAlign="Middle"
  BackColor="Control"></HeaderStyle>
 <Columns>
  <asp:TemplateColumn HeaderText="操作">
   <HeaderStyle HorizontalAlign="Center" Width="50px"></HeaderStyle>
   <ItemTemplate>
    <input type="hidden" id="SelectedID" runat="server"
    value='<%# DataBinder.Eval(Container.DataItem, "id")%>'/>
    <asp:CheckBox ID="chkExport" Runat="server" />
   </ItemTemplate>
  </asp:TemplateColumn>
  <asp:BoundColumn DataField="id" ReadOnly="True" HeaderText="序号">
   <HeaderStyle Width="50px"></HeaderStyle>
  </asp:BoundColumn>
  <asp:TemplateColumn SortExpression="demo" HeaderText="标题">
   <ItemTemplate>
    <asp:Label Text='<%# Server.HtmlEncode((string)DataBinder.Eval(Container.DataItem, "Title"))%>'
     runat="server" Width="80%" ID="lblColumn" />
   </ItemTemplate>
  </asp:TemplateColumn>
 </Columns>
</asp:DataGrid>
<asp:Button id="cmdSelectAll" runat="server" Text="全部选中"></asp:Button>
<asp:Button id="cmdFindSelected" runat="server" Text="查看选中的项目"></asp:Button>
<br>
<asp:Label id="Label1" runat="server"></asp:Label>
<hr>
<asp:Label id="Label2" runat="server"></asp:Label>
</form>
</body>
</HTML>

DataGridCheckBox.aspx.cs

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;
  protected System.Web.UI.WebControls.Label Label2;
  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 CreateDate DESC";
    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 = "";
   Label2.Text = "";
   foreach(DataGridItem oDataGridItem in dgMain.Items)
   {
      chkExport = (CheckBox)oDataGridItem.FindControl("chkExport");
      if( chkExport.Checked)
      {
         //如果要进行删除,可以在这里构造sql语句进行删除
         string sql = "DELETE FROM Document WHERE id ="
            + ((HtmlInputHidden)oDataGridItem.FindControl("SelectedID")).Value;
         Label2.Text += "<li>" + sql;
         sID = ((HtmlInputHidden)oDataGridItem.FindControl("SelectedID")).Value;
         oExArgs.Add(sID);
         int i = 0;
         Label1.Text = "";
         for( i = 0;i<oExArgs.Count;i++)
         {
            Label1.Text += oExArgs[i] + "<br>";
         }
      }
   }
   Label2.Text += "<br><font color=red>执行SQL语句即可删除,这里省略。</font>";
  }
 }
}

 

Flex中DataGrid实现列(包括头部)中加入CheckBox全选功能 几种实现方法

 在DataGrid中实现列中加入CheckBox这种用法很常见,项目中也经常会用到,在网上搜了下基本就是实现itemRender.但是 感觉网上提供的实现上好些地方都是多余的 经过自己的改造感...
  • u011589095
  • u011589095
  • 2014年08月14日 14:53
  • 1103

WPF DataGrid表头Checkbox 全选与全反选

WPF 在使用DataGrid展示数据的时候经常会使用到checkbox列,特别是id列     例如下面这种效果:          WPF 要实现DataGrid checkbox全选与全反选,方...
  • aojiancc2
  • aojiancc2
  • 2017年02月09日 16:12
  • 2694

lightswitch datagrid 动态添加复选框的功能。

lightswitch中非自定义datagrid 使用注入的方式添加复选框,以便用户可以进行多项选择,using Microsoft.LightSwitch; using Microsoft.Ligh...
  • greystar
  • greystar
  • 2015年11月09日 15:40
  • 2159

WPF中DataGrid 添加checkbox实现全选、多选

在机房合作项目中,有一个窗体是这样子的               简单介绍一下:就是通过查询出正在上机的学生,可以通过勾选前面的checkbox,选中该行,然后可以进行部分下机和全部下机。如...
  • kwy15732621629
  • kwy15732621629
  • 2016年07月26日 14:41
  • 6876

flex在DataGrid中添加checkbox复选框,并获取选中的值

flex在DataGrid中添加checkbox复选框,并获取选中的值 1、界面:注册事件,并获取子窗体的值 //选择专题区域 private  var ztqy:DBPJZTQY = null; p...
  • ml5271169588
  • ml5271169588
  • 2013年09月15日 15:42
  • 6025

Flex中DataGrid中添加一列复选框(CheckBox)

xmlns:s="library://ns.adobe.com/flex/spark"     xmlns:mx="library://ns.adobe.com/flex/mx"     crea...
  • hanxiaoyu1988
  • hanxiaoyu1988
  • 2013年03月12日 11:38
  • 1253

WPF中DataGrid中的DataGridCheckBoxColumn用法(全选,全否,反选)

check datagrid wpf
  • qq_31971935
  • qq_31971935
  • 2015年11月02日 10:59
  • 3419

WPF中DataGrid实现全选

方法一:使用模板列 前台代码如下 后台实现如下  DataGridTemplateColumn templeColum...
  • asciil
  • asciil
  • 2016年11月22日 21:18
  • 1386

VC DataGrid控件使用总结

MS CDataGrid控件用法详解 本文示例源代码或素材下载 。DataGrid控件是VC方便地用来显示数据的一个极好的网格控件,我不否认网上还有期它不少优秀的网格控件,但我总喜欢使用微...
  • bcbobo21cn
  • bcbobo21cn
  • 2016年04月01日 18:37
  • 1696

easyui datagrid checkbox初始化某几行disabled时,点击全选还是可以选择 解决办法

$("#body_feetotal").datagrid({ method: "get", pagination: true, ...
  • QQ38397892
  • QQ38397892
  • 2015年05月15日 17:22
  • 10146
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:为DataGrid添加CheckBox控件
举报原因:
原因补充:

(最多只允许输入30个字)