editbtype.aspx
来自「一个完整的办公自动化源码,免费提供给大家下载」· ASPX 代码 · 共 89 行
ASPX
89 行
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="system.data.oledb" %>
<!--#include file="ckqx.aspx" -->
<html>
<head>
<title>编辑部门</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS.CSS" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#CCCCCC">
<form runat="server">
<table width="549" height="24" border="0" cellpadding="0" cellspacing="0" background="../pic/002.png">
<tr>
<td><font color="#FFFFFF"><strong> 编辑部门</strong></font></td>
</tr>
</table>
<table width="549" height="400" border="1" cellpadding="0" cellspacing="0" bordercolorlight="#008080" bordercolordark="#FFFFFF">
<tr>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="38">
<asp:datagrid runat="server" ID="mygrid"
DataKeyField="id"
AutoGenerateColumns="false"
AllowPaging="true"
PageSize="15"
OnPageIndexChanged="zscpage"
OnEditCommand="zscedit"
OnDeleteCommand="zscdel"
HorizontalAlign="Center"
BorderColor="#cccccc"
Width="98%"
>
<headerstyle Font-Bold="true" HorizontalAlign="center" />
<pagerstyle Mode="numericpages" PageButtonCount="5" HorizontalAlign="right" />
<itemstyle HorizontalAlign="center" />
<columns>
<asp:boundcolumn DataField="btype" HeaderText="部门名称" />
</columns>
<columns>
<asp:templatecolumn headertext="操作">
<itemtemplate>
<asp:linkbutton runat="server" Text="编辑" CommandName="edit" />
<asp:linkbutton runat="server" Text="删除" CommandName="delete" />
</itemtemplate>
</asp:templatecolumn>
</columns>
</asp:datagrid>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
<script language="VB" runat="server">
sub page_load(s as object,e as eventargs)
if not ispostback then
if not (checkqx("a")) then response.redirect("error.aspx")
bindlist()
end if
end sub
sub bindlist()
dim conn as new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & server.MapPath("../office.mdb"))
conn.open()
dim objada as new oledbdataadapter("select * from btype",conn)
dim ds as new dataset()
objada.fill(ds,"btype")
mygrid.datasource=ds
mygrid.databind()
conn.close()
end sub
sub zscedit(s as object,e as DataGridcommandeventargs)
response.Redirect("btypemodify.aspx?id=" & s.datakeys(e.item.itemindex))
end sub
sub zscdel(s as object,e as DataGridCommandEventArgs)
response.Redirect("btypedel.aspx?id=" & s.datakeys(e.item.itemindex))
end sub
sub zscpage(s as object,e as DataGridpagechangedEventArgs)
s.currentpageindex=e.newpageindex
bindlist()
end sub
</script>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?