jodyjin800730

 

我在DataGrid中加入了一列checkbox用来控制删除多行

我在DataGrid中加入了一列checkbox用来控制删除多行
可是发现了一个问题,就是假如我的分页为每页3行
当我把一页的所有记录行全部删除时,会出现当前索引错误
我想如果全部删除1.后面没有记录跳到前一个页面
                2.后面有记录自动显示后面的记录
本文介绍如何在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;
else
SelectMultiPage.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"" onclick=""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 

}
}

 


# 版本

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

posted on 2005-12-30 09:26  在学习.net的道路上  阅读(570)  评论(0)  编辑  收藏  举报

导航