📄 2005414428.htm
字号:
<TR>
<td width="624" bgcolor="#CCCCCC">当前位置:<a href=../../index.htm>首页</a>--><a href=../../artical/69/1.htm>程序设计</a>--><a href=../../artical/80/1.htm>ASP专区</a>-->显示文章内容</td><td width="176" bgcolor="#CCCCCC"><span id="liveclock"></span></td>
</TR></TBODY></TABLE>
<table width="800" height="406" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="166" height="200" valign="top" scope="col"><table width="100%" height="163" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="119" valign="top" scope="col"><table width="180" border="0" cellspacing="0" cellpadding="0" align="center">
<form action="../../search.asp" method="post" name="searchLeftForm">
<tr bgcolor="CAF6F4" align="center">
<td height="25" bgcolor="#CC9900"><font color="#cc0000"><b>□
站 内 搜 索 □</b></font></td>
</tr>
<tr align="center">
<td style="line-height:150%" height=60> 请输入查询的字符串:<br>
<input name="search" type="text" class="button1" id="search" style="width:150">
<select name="seaguan" size="1" class="button1" id="seaguan" style="width:150">
<option value="">==> 综合查询 <==</option>
<option value="title">标题</option>
<option value="断剑">作者</option>
<option value="artical">内容</option>
<%call getNewsBoardTree()%>
</select>
</td>
</tr>
<tr align="center">
<td>
<input type="SUBMIT" name="Action" value=" 查 询 " class="button2">
<input type="RESET" name="Clear" value=" 重 写 " class="button2">
</td>
</tr>
<tr align="center">
<td height="10"></td>
</tr>
</form>
</table></td>
</tr>
<tr>
<td height="20"><table width="181" height="20" cellpadding="0" cellspacing="0">
<tr><td width="181" height="20" align="center" bgcolor="#CC9900">分类最新文章</td>
</tr>
<tr><td><a href=2005414529.htm target=_blank>使用正则表达式实现模式图片新</a></td></tr><tr><td><a href=200541450.htm target=_blank>asp常用数据库连接方法和技</a></td></tr><tr><td><a href=2005414428.htm target=_blank>使用简单的方法进行批量删除数</a></td></tr><tr><td><a href=2005414315.htm target=_blank>asp提高首页性能的一个技巧</a></td></tr><tr><td><a href=2005414230.htm target=_blank>ASP防注入之解决方案--加</a></td></tr><tr><td><a href=2005414158.htm target=_blank>使用ASP加密算法加密你的数</a></td></tr><tr><td><a href=2005414120.htm target=_blank>常用ASP自定义函数集</a></td></tr><tr><td><a href=2005414035.htm target=_blank>使用ASP生成HTML文件</a></td></tr><tr><td><a href=20054135956.htm target=_blank>在Flash中使用ASP技术</a></td></tr><tr><td><a href=200533011127.htm target=_blank>在asp中多个虚拟目录 se</a></td></tr>
</table></td>
</tr>
<tr>
<td height="20"><table width="181" height="20" cellpadding="0" cellspacing="0">
<tr><td width="181" height="20" align="center" bgcolor="#CC9900">分类热门文章</td>
</tr>
<tr><td><a href=200532713295.htm target=_blank>断剑新闻系统商业版!</a></td></tr><tr><td><a href=200532115451.htm target=_blank>有关sql注入</a></td></tr><tr><td><a href=200532115410.htm target=_blank>ASP、JSP、PHP 三种</a></td></tr><tr><td><a href=200532014532.htm target=_blank>[原创]关于断剑新闻系统1.</a></td></tr><tr><td><a href=2005320135030.htm target=_blank>[本站原创]用VS.NET封</a></td></tr><tr><td><a href=200532115337.htm target=_blank>改进性能和样式的 24个 A</a></td></tr><tr><td><a href=200532818925.htm target=_blank>初学asp的朋友 asp20</a></td></tr><tr><td><a href=2005414529.htm target=_blank>使用正则表达式实现模式图片新</a></td></tr><tr><td><a href=200532115122.htm target=_blank>用asp自动解析网页中的图片</a></td></tr><tr><td><a href=20053281846.htm target=_blank>DataGrid动态添加模板</a></td></tr>
</table></td>
</tr>
</table></td>
<td width="628" valign="top" scope="col"><table width="100%" border="0" align="center" cellspacing="0" cellpadding="5" bordercolordark="#FFFFFF" bordercolorlight="#000000" style="word-break:break-all;">
<tr>
<td width="100%">
</td>
</tr>
<tr>
<td width="100%">
<div align="center">
<p class="style7"><SPAN class=style1>使用简单的方法进行批量删除数据</SPAN></p>
<hr size="1" color="#0a778b" width="100%">
发布时间：2005-4-1 被阅览数：<SCRIPT src="../../counter.asp?id=494"></SCRIPT> 次 作者：断剑
</div>
</td>
</tr>
<tr>
<td width="100%"><p class="style6"><SPAN>在网上看到一些批量删除数据的例子.但是大部分是用的数组来保存所选的id.这样比较麻烦,也不容易被理解.我就拿个比较简单的方法来实现这个功能.（只看红色的部分即可，而且还加个删除提示窗口） <BR><BR>using System; <BR>using System.Collections; <BR>using System.ComponentModel; <BR>using System.Data; <BR>using System.Drawing; <BR>using System.Web; <BR>using System.Web.SessionState; <BR>using System.Web.UI; <BR>using System.Web.UI.WebControls; <BR>using System.Web.UI.HtmlControls; <BR>using System.Data.OleDb; <BR>namespace overred.test <BR>{ <BR>/// <summary> <BR>/// t1 的摘要说明。 <BR>/// </summary> <BR>public class t1 : System.Web.UI.Page <BR>{ <BR>protected System.Web.UI.WebControls.Label message; <BR>protected System.Web.UI.WebControls.LinkButton showck; <BR>protected System.Web.UI.WebControls.CheckBox CheckBox1; <BR>protected System.Web.UI.WebControls.LinkButton delall; <BR>protected System.Web.UI.WebControls.DataGrid dg; <BR>private OleDbCommand cmd; <BR>private OleDbConnection conn; <BR>protected System.Web.UI.WebControls.LinkButton lb; <BR>private string datas; <BR><BR><BR>private void Page_Load(object sender, System.EventArgs e) <BR>{ <BR><BR><BR>Session["s"]="dd"; <BR>// 在此处放置用户代码以初始化页面 <BR>if(!this.Page.IsPostBack) <BR>Sql(); <BR><BR><BR><BR><BR><BR>} <BR><BR><BR><BR>private DataSet Getds() <BR>{ <BR>datas="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../overred.mdb"); <BR>conn = new OleDbConnection(datas); <BR>conn.Open(); <BR>OleDbDataAdapter adp = new OleDbDataAdapter("select * from subnews order by news_order desc", conn); <BR>DataSet ds = new DataSet(); <BR>adp.Fill(ds,"link"); <BR><BR>return ds; <BR><BR><BR><BR><BR><BR>} <BR>private void Sql() <BR>{ <BR>alter(); <BR>using (DataSet dss=Getds()) <BR><BR>this.dg.DataSource=dss; <BR>this.dg.DataBind(); <BR><BR>} <BR>private void alter()//添加确认窗口 <BR>{ <BR>this.delall.Attributes.Add("onclick","return confirm('确定删除')"); <BR><BR>} <BR><BR><BR><BR><BR><BR>#region Web 窗体设计器生成的代码 <BR>override protected void OnInit(EventArgs e) <BR>{ <BR>// <BR>// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 <BR>// <BR>InitializeComponent(); <BR>base.OnInit(e); <BR>} <BR><BR>/// <summary> <BR>/// 设计器支持所需的方法 - 不要使用代码编辑器修改 <BR>/// 此方法的内容。 <BR>/// </summary> <BR>private void InitializeComponent() <BR>{ <BR>this.showck.Click += new System.EventHandler(this.showck_Click); <BR>this.delall.Click += new System.EventHandler(this.delall_Click); <BR>this.lb.Click += new System.EventHandler(this.lb_Click); <BR>this.Load += new System.EventHandler(this.Page_Load); <BR><BR>} <BR>#endregion <BR><BR>private void showck_Click(object sender, System.EventArgs e)//显示选择的项 <BR>{ <BR><BR>//ArrayList saveIdChecked=new ArrayList(); <BR>CheckBox isChecked; <BR>//遍历每一行 <BR>foreach(DataGridItem dataItem in dg.Items) <BR>{ <BR>//获取checkbox <BR>isChecked=(CheckBox)dataItem.FindControl("ck"); <BR><BR>if(isChecked.Checked==true) <BR>{ <BR>string idChecked=dataItem.Cells[1].Text; <BR>Response.Write(idChecked); <BR>Response.Write(isChecked.Checked); <BR>} <BR>} <BR><BR><BR>} <BR><BR>private void delall_Click(object sender, System.EventArgs e) <BR>{ <BR>alter(); <BR>datas= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../overred.mdb"); <BR>conn = new OleDbConnection(datas); <BR>cmd=new OleDbCommand(); <BR>cmd.Connection=conn; <BR>conn.Open(); <BR>CheckBox isChecked; <BR>//遍历每一行 <BR>foreach(DataGridItem dataItem in dg.Items) <BR>{ <BR>//获取checkbox <BR>isChecked=(CheckBox)dataItem.FindControl("ck"); <BR><BR>if(isChecked.Checked==true)//如果选中则执行删除命令 <BR>{ <BR>cmd.CommandText="Delete from subnews where news_id="+dataItem.Cells[1].Text.ToString(); <BR>cmd.ExecuteNonQuery(); <BR>} <BR>} <BR>Sql();//重新绑定 <BR>//Response.Redirect("t1.aspx"); <BR>} <BR><BR>} <BR>} <BR><BR><BR><BR>aspx： <BR><BR><BR><BR><BR><%@ Page language="c#" Codebehind="t1.aspx.cs" trace="true" AutoEventWireup="false" Inherits="overred.test.t1" %> <BR><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <BR><HTML> <BR><HEAD> <BR><title>t1</title> <BR><meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> <BR><meta name="CODE_LANGUAGE" Content="C#"> <BR><meta name="vs_defaultClientScript" content="JavaScript"> <BR><meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <BR></HEAD> <BR><body> <BR><form id="Form1" method="post" runat="server"> <BR><FONT face="宋体"> <BR><asp:datagrid id="dg" runat="server" DataKeyField="news_id"> <BR><Columns> <BR><ASP:TemplateColumn HeaderText="选择" ItemStyle-Width="30"> <BR><ItemTemplate> <BR><asp:CheckBox id="ck" runat="server" /> <BR></ItemTemplate> <BR></ASP:TemplateColumn> <BR><asp:BoundColumn HeaderText="id" DataField="news_id" /> <BR><asp:BoundColumn HeaderText="id" DataField="news_name" /> <BR></Columns> <BR></asp:datagrid> <BR><P> <BR><asp:Label id="message" runat="server" /> <BR><asp:LinkButton id="showck" runat="server" Text="删除" ForeColor="navy" Font-Name="verdana" Font-size="12pt" />&nbsp; <BR></P> <BR><P> <BR><asp:LinkButton id="delall" runat="server">delall</asp:LinkButton></P> <BR><P> <BR><asp:LinkButton id="lb" runat="server">LinkButton</asp:LinkButton></P> <BR></FONT> <BR></form> <BR></body> <BR></HTML> <BR><BR><BR><BR><BR><BR><BR><BR><%@ Page language="c#" Codebehind="t1.aspx.cs" trace="true" AutoEventWireup="false" Inherits="overred.test.t1" %> <BR><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <BR><HTML> <BR><HEAD> <BR><title>t1</title> <BR><meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> <BR><meta name="CODE_LANGUAGE" Content="C#"> <BR><meta name="vs_defaultClientScript" content="JavaScript"> <BR><meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <BR></HEAD> <BR><body> <BR><form id="Form1" method="post" runat="server"> <BR><FONT face="宋体"> <BR><asp:datagrid id="dg" runat="server" DataKeyField="news_id"> <BR><Columns> <BR><ASP:TemplateColumn HeaderText="选择" ItemStyle-Width="30"> <BR><ItemTemplate> <BR><asp:CheckBox id="ck" runat="server" /> <BR></ItemTemplate> <BR></ASP:TemplateColumn> <BR><asp:BoundColumn HeaderText="id" DataField="news_id" /> <BR><asp:BoundColumn HeaderText="id" DataField="news_name" /> <BR></Columns> <BR></asp:datagrid> <BR><P> <BR><asp:Label id="message" runat="server" /> <BR><asp:LinkButton id="showck" runat="server" Text="删除" ForeColor="navy" Font-Name="verdana" Font-size="12pt" />&nbsp; <BR></P> <BR><P> <BR><asp:LinkButton id="delall" runat="server">delall</asp:LinkButton></P> <BR><P> <BR><asp:LinkButton id="lb" runat="server">LinkButton</asp:LinkButton></P> <BR></FONT> <BR></form> <BR></body> <BR></HTML> <BR><BR><BR><BR><BR><BR><BR><BR><%@ Page language="c#" Codebehind="t1.aspx.cs" trace="true" AutoEventWireup="false" Inherits="overred.test.t1" %> <BR><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <BR><HTML> <BR><HEAD> <BR><title>t1</title> <BR><meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> <BR><meta name="CODE_LANGUAGE" Content="C#"> <BR><meta name="vs_defaultClientScript" content="JavaScript"> <BR><meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <BR></HEAD> <BR><body> <BR><form id="Form1" method="post" runat="server"> <BR><FONT face="宋体"> <BR><asp:datagrid id="dg" runat="server" DataKeyField="news_id"> <BR><Columns> <BR><ASP:TemplateColumn HeaderText="选择" ItemStyle-Width="30"> <BR><ItemTemplate> <BR><asp:CheckBox id="ck" runat="server" /> <BR></ItemTemplate> <BR></ASP:TemplateColumn> <BR><asp:BoundColumn HeaderText="id" DataField="news_id" /> <BR><asp:BoundColumn HeaderText="id" DataField="news_name" /> <BR></Columns> <BR></asp:datagrid> <BR><P> <BR><asp:Label id="message" runat="server" /> <BR><asp:LinkButton id="showck" runat="server" Text="删除" ForeColor="navy" Font-Name="verdana" Font-size="12pt" />&nbsp; <BR></P> <BR><P> <BR><asp:LinkButton id="delall" runat="server">delall</asp:LinkButton></P> <BR><P> <BR><asp:LinkButton id="lb" runat="server">LinkButton</asp:LinkButton></P> <BR></FONT> <BR></form> <BR></body> <BR></HTML> <BR><BR><BR><BR><BR>说明： <BR><BR>dataItem.Cells[1].Text.ToString()为news_id <BR><BR></SPAN></p>
<p><img src="http://www.koyee.com/images/dgg.gif" height="70" width="587"> </p></td>
</tr>
<tr>
<td width="628" bordercolor="0" class="font1"><p>
<hr size="1" color="#0a778b" width="100%">
<table><tr><td width="269" align="center">上一篇: <a href=../80/2005414315.htm title=asp提高首页性能的一个技巧>asp提高首页性能的一个技巧</a> </td>
<td width="285" align="center">下一篇: <a href=../90/200542823048.htm title=gew>gew</a></td>
</tr></table>
<hr size="1" color="#0a778b" width="100%">
<div align="right"> <a href="javascript:window.print()"><img src="../../images/printer.gif" width="16" height="14" border="0" align="absmiddle">打印本页</a> | <a href="javascript:window.close()"><img src="../../images/close.gif" width="14" height="14" border="0" align="absmiddle">关闭窗口</a> </div>
<p></p></td>
</tr>
</table></td>
</tr>
</table>
<TABLE height=62 cellSpacing=0 cellPadding=0 width="800"
align=center background=../../images/webtop_bg.gif
border=0>
<TBODY>
<TR>
<TD><div align="center" class="style4">Copyright @ 2004-2008 http://www.koyee.com 可以网络在线版权所有<br>
公司地址:江西南昌 电话:13879173467 邮编:330029<br>
email:chenxueyan9999@163.com</div></TD>
</TR></TBODY></TABLE>
</BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -