DataGrid多行删除

技术2022-05-11 123

本文介绍如何在ASP.NET中实现多页面选择的问题。其具体思路很简单：用隐藏的INPUT记住每次选择的项目，在进行数据绑定时，检查保存的值，再在DataGrid中进行选中显示。下面时完整的代码和例子：

查看例子

SelectMultiPages.aspx

<%@ Page EnableViewState=""true"" CodeBehind=""SelectMultiPages.aspx.cs"" Language=""c#"" AutoEventWireup=""false"" Inherits=""eMeng.Exam.SelectMultiPages"" %><!DOCTYPE HTML PUBLIC ""-//W3C//DTD HTML 4.0 Transitional//EN""><HTML><HEAD><title>跨页面实现多选</title><META http-equiv=""content-type"" content=""text/html; charset=gb2312""><style>* {FONT-SIZE:12PX}#Status {text-align:left}</style><script language=""JAVASCRIPT"">function AddRemoveValues(oChk) { //在处理这个地方需要注意的是：你保存的值应该具有唯一性，这样才能不会替换错误的项。if(oChk.checked)SelectMultiPage.HdnSelectedValues.value += "","" + oChk.value; elseSelectMultiPage.HdnSelectedValues.value = SelectMultiPage.HdnSelectedValues.value.replace("","" + oChk.value,""""); }</script></HEAD><BODY><form id=""SelectMultiPage"" runat=""server""><asp:datagrid id=""DataGrid1"" HorizontalAlign=""Center"" AutoGenerateColumns=""False"" Width=""600px"" AllowPaging=""True"" runat=""server""> <AlternatingItemStyle BackColor=""#EEEEEE""></AlternatingItemStyle> <HeaderStyle BackColor=""#AAAADD"" Font-Bold=""True"" HorizontalAlign=""Center""></HeaderStyle> <PagerStyle HorizontalAlign=""Right"" Mode=""NumericPages"" Visible=""True""></PagerStyle> <Columns> <asp:TemplateColumn HeaderText=""选择""> <ItemTemplate> <input type=""checkbox"" runat=""server"" id=""chkSelect"" οnclick=""AddRemoveValues(this)"" value='<%#DataBinder.Eval(Container.DataItem,""Title"")%>'/> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText=""文章标题""> <ItemTemplate> <asp:Literal Text='<%# DataBinder.Eval(Container.DataItem, ""Title"") %>' runat=""server"" ID=""TitleShow""/> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText=""发布时间""> <ItemTemplate> <asp:Literal Text='<%# DataBinder.Eval(Container.DataItem, ""CreateDate"").ToString() %>' runat=""server""/> </ItemTemplate> </asp:TemplateColumn> </Columns></asp:datagrid><div align=center><asp:button id=""Button1"" runat=""server"" Text=""得到所选的值""></asp:button><div id=""Status""><asp:label id=""Label1"" runat=""server""></asp:label></div><INPUT id=""HdnSelectedValues"" type=""hidden"" name=""HdnSelectedValues"" runat=""server""></div></form></BODY></HTML>

SelectMultiPages.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{/// <summary>/// SelectMultiPages 的摘要说明。/// </summary>public class SelectMultiPages : System.Web.UI.Page{protected System.Web.UI.WebControls.Button Button1;protected System.Web.UI.WebControls.Label Label1;protected System.Web.UI.HtmlControls.HtmlInputHidden HdnSelectedValues;protected System.Web.UI.WebControls.DataGrid DataGrid1;

private void Page_Load(object sender, System.EventArgs e){ // 在此处放置用户代码以初始化页面 if(!Page.IsPostBack) BindData();}private void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e){ DataGrid1.CurrentPageIndex = e.NewPageIndex; BindData(); }

void BindData(){ OleDbConnection cn = new OleDbConnection(""Provider=Microsoft.Jet.OLEDB.4.0;Data Source="" + HttpContext.Current.Server.MapPath(""aspx.mdb"")); OleDbDataAdapter da = new OleDbDataAdapter(""Select Title, CreateDate from Document"",cn); DataSet ds = new DataSet(); da.Fill(ds); DataGrid1.DataSource= ds; DataGrid1.DataBind();}

private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e){ //重新显示所选择的项目 if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { if(HdnSelectedValues.Value.IndexOf(((Literal)e.Item.Cells[1].FindControl(""TitleShow"")).Text) >= 0 ) { HtmlInputCheckBox ChkSelected = (HtmlInputCheckBox)(e.Item.Cells[0].FindControl(""ChkSelect"")); ChkSelected.Checked = true; } }}private void Button1_Click(object sender, System.EventArgs e){ //为了显示的方便进行替换的 Label1.Text = HdnSelectedValues.Value.Replace("","",""<li>"");}

#region Web 窗体设计器生成的代码override protected void OnInit(EventArgs e){ // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e);}

/// <summary>/// 设计器支持所需的方法 - 不要使用代码编辑器修改/// 此方法的内容。/// </summary>private void InitializeComponent(){ this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound); this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged); this.Button1.Click += new System.EventHandler(this.Button1_Click); this.Load += new System.EventHandler(this.Page_Load);

}#endregion

}}

vb.net

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.DataImports 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

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>""; } }}

专利

最新回复(0)