作者: 孟宪会 出自: 【孟宪会之精彩世界】 发布日期: 2003-5-23 8:26:11
--------------------------------------------------------------------------------
为DataGrid添加CheckBox控件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.vbImports System.Data
Imports System.Data.OleDbPublic 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 SubEnd Class
--------------------------------------------------------------------------------
为DataGrid添加CheckBox控件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.vbImports System.Data
Imports System.Data.OleDbPublic 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 SubEnd Class
解决方案 »
- 上传的文件都无法删除,提示是否磁盘已满,安全模式也无法删除
- .NET 与J2EE 应用能部署在同一服务器上吗?
- 如何sql实现 小时的加减法?
- 公交车搜索的sql语句问题!急!!!
- 菜鸟问题:在网站工程文件中选择一个.aspx文件,不能浏览(browse in)
- 请问:vb控件中的smtp控件的smtp1.MailServerDomain的属性是什么意思啊??
- C#学完很郁闷。不知道怎么样来做aspx网页?各位赐教了!
- 一个简单的问题
- 大家有没有碰到过这样的问题?很奇怪的?
- IIS7.5 自带的 URL重写问题、域名重定向问题
- vs.net 问题,急等...................................................
- 怎样循环更新datagrid里一个列的值(checkbox)?
.aspx文件源码:
<%@ Page language="c#" Codebehind="DataGridCheckBox.aspx.cs" AutoEventWireup="false" Inherits="test.DataGridCheck" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>DataGridCheck</title>
<meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body>
<form id="DataGridCheck" 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"></EditItemStyle>
<AlternatingItemStyle Font-Size="9pt" Font-Names="宋体" ForeColor="ControlText" BackColor="White"></AlternatingItemStyle>
<ItemStyle Font-Size="9pt" Font-Names="宋体" ForeColor="ControlText" BackColor="WhiteSmoke"></ItemStyle>
<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:TemplateColumn Visible="False">
<ItemTemplate>
<asp:Label Text='<%# DataBinder.Eval(Container.DataItem, "medicine_id")%>' runat="server" Width="80%" ID="lblID" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="medicine_id" ReadOnly="True" HeaderText="药品编号">
<HeaderStyle Width="80px"></HeaderStyle>
</asp:BoundColumn>
<asp:TemplateColumn SortExpression="demo" HeaderText="药品名称">
<ItemTemplate>
<asp:Label Text='<%# Server.HtmlEncode((string)DataBinder.Eval(Container.DataItem, "medicine_name"))%>' 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>
.aspx.cs文件源码:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;namespace test
{
/// <summary>
/// DataGridCheck 的摘要说明。
/// </summary>
public class DataGridCheck : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid dgMain;
protected System.Web.UI.WebControls.Button cmdSelectAll;
protected System.Web.UI.WebControls.Button cmdFindSelected;
protected System.Web.UI.WebControls.Label Label1;
protected System.Data.SqlClient.SqlConnection cn;
protected System.Data.SqlClient.SqlCommand cm;
protected System.Data.SqlClient.SqlDataAdapter da;
DataView oDataView;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
// dgMain.Columns[0].HeaderText = "选项";
// dgMain.Columns[1].HeaderText = "药品编号";
// dgMain.Columns[2].HeaderText = "药品名称";
// cmdFindSelected.Text = "删除选中的项目";
if( !this.IsPostBack)
{
cmdSelectAll.Text = "全部选中";
RefreshGrid();
cmdFindSelected.Attributes.Add("onclick","return confirm('yes/no');");
}
} #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 * from medicine order by medicine_id";
cn = new SqlConnection(ConfigurationSettings.AppSettings["sa"]);
da = new SqlDataAdapter(sSQL,cn);
cn.Open();
// oCommand = new OleDbDataAdapter(sSQL.ToString(), oConnection);
da.Fill(oDataSet,"medicine");
// oCommand.Fill(oDataSet, "Document");
oDataView = new DataView(oDataSet.Tables["medicine"]);
dgMain.DataSource = oDataView;
dgMain.DataKeyField="medicine_id";
dgMain.DataBind();
cn.Close();
}
catch(Exception ex)
{
Label1.Text = ex.ToString();
}
} private void cmdFindSelected_Click(object sender, System.EventArgs e)
{
// Response.Write("<script>window.confirm('对了!');</script>");
// cmdFindSelected.Attributes.Add("onclick","return confirm('yes/no');");
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("lblID")).Text;//.Text;
// Response.Write(sID);
oExArgs.Add(sID);
int i = 0;
cn = new SqlConnection(ConfigurationSettings.AppSettings["sa"]);
cn.Open();
string DeleteSQL="";
for( i = 0;i<oExArgs.Count;i++)
{
// Label1.Text += oExArgs[i] + "<br>";
// DeleteSQL="delete from medicine where medicine_id='"+oExArgs[i]+"'";
DeleteSQL="Update medicine set medicine_stocks=medicine_stocks+1 where medicine_id='"+oExArgs[i]+"'";
oExArgs.Clear(); Label1.Text+=DeleteSQL+"<br>";
cm = new SqlCommand(DeleteSQL,cn);
cm.ExecuteNonQuery();
DeleteSQL="";
}
cn.Close();
}
}
RefreshGrid();
cmdSelectAll.Text = "全部选中";
// dgMain.DataBind();
}
}
}