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>&nbsp;&nbsp;&nbsp;&nbsp;编辑部门</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" />
						&nbsp;&nbsp;
						<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 + -
显示快捷键?