📄 第六章 用户权限管理(六） -- c#读写数据库image字段_宪华_新浪博客.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<!-- saved from url=(0052)http://blog.sina.com.cn/s/blog_5f30147a0100dkmv.html -->
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>第六章 用户权限管理(六） -- C#读写数据库Image字段_宪华_新浪博客</TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META http-equiv=X-UA-Compatible content=IE=EmulateIE7>
<META
content=宪华的博客,宪华,6.6角色用户管理设计与实现6.6.4员工信息管理图6.20员工信息管理页面如图6.20所示，员工信息管理页Employees.aspx程序较为复杂，主要使用了DataGrid控件。在控件中点击姓名，将弹出如图所示的员工信息表（EmployeeInfo.aspx）页面；点击员工照片（实际上是一个图片按钮ImageButton）将弹出显示大尺寸照片的页面DisplayImage.aspx；而且员工信息管理页下方的添加编辑控件既要负责添加员工信息，还要负责修改已有信息。当点击DataGri
name=description>
<META content=宪华的博客,宪华,工作流,电子政务系统,it name=keywords>
<SCRIPT>
var scope = {
$uid : "1596986490",
$PRODUCT_NAME : "blog",
$pageid : "article",
$key : "91558befff0bebef176680977f91a20c",
$sort_id : "113",
$loadconf : true,
$flag2008 : "0",
$articleid : "5f30147a0100dkmv" ,
$isCommentAllow : "1"
};
var $encrypt_code = "a7b9ea328ce2f3a880cb3fc36c358da7";
var config = {"common":{"t":"1_2","r":0,"head":{"tiled":"none","align_h":"left","align_v":"top","height":"100"},"bg":{"tiled":"none","align_h":"left","align_v":"top"},"pageset":0,"invitationset":0},"private":{"cms":0,"blogsize":"0","ad":0,"sms":0,"adver":0},"component":{"c1":["901","1001","12","1","2","3","8"],"c2":[],"x":2},"product":{"c":21,"j":15}};
var fav = {"5f30147a0100dkmv":"2bea558d7d1f0da513be329c1f47246e"} ;
</SCRIPT>
<SCRIPT src="第六章%20用户权限管理(六）%20--%20C%23读写数据库Image字段_宪华_新浪博客_files/boot.js"
type=text/javascript></SCRIPT>
<SCRIPT type=text/javascript>loadCss();</SCRIPT>
<SCRIPT
src="第六章%20用户权限管理(六）%20--%20C%23读写数据库Image字段_宪华_新浪博客_files/platform_tray.compressed.js"></SCRIPT>
<LINK href="第六章%20用户权限管理(六）%20--%20C%23读写数据库Image字段_宪华_新浪博客_files/im.css"
type=text/css rel=stylesheet><!--# block name="blk737369" --><!--# endblock --><!--#include file="/hits?act=4&aid=${aid}" stub="blk737369" -->
<META content="MSHTML 6.00.6000.16825" name=GENERATOR></HEAD>
<BODY>
<DIV id=sinatopbar>
<SCRIPT type=text/javascript>
<!--
document.write(SinaSysTray.getHTML());
//-->
</SCRIPT>
</DIV>
<SCRIPT type=text/javascript>
<!--
SinaSysTray.base_init({
"type" : scope.$PRODUCT_NAME || "",
"uid" : $UID || "0"
});
//-->
</SCRIPT>
<DIV class=wrapper>
<DIV class=headpic100 id=headpic100>
<DIV class=headpic950 id=headPic950>
<DIV class=ntoptitle id=ntoptitle>
<DIV class=ntopns id=blogTitle>
<DIV class=ntitname id=blogname><A
href="http://blog.sina.com.cn/xianhuameng">宪华的博客</A> </DIV>
<DIV class=ntitsite>http://blog.sina.com.cn/xianhuameng<A class=CP_a_fuc
id=SubscribeNewRss onclick="return false;"
href="http://blog.sina.com.cn/s/blog_5f30147a0100dkmv.html#">[<CITE>订阅</CITE>]</A></DIV></DIV></DIV></DIV>
<DIV class=termenubg></DIV>
<DIV class=termenu>
<DIV class=termenuc id=clone_template>
<DIV class=termenutag>
<DIV class=user>
<DIV class=userhead><A href="http://blog.sina.com.cn/xianhuameng"><IMG
src="第六章%20用户权限管理(六）%20--%20C%23读写数据库Image字段_宪华_新浪博客_files/50.jpg"></A></DIV>
<DIV class=username><A style="CURSOR: hand"
href="http://blog.sina.com.cn/xianhuameng"><SPAN
id=nav_name></SPAN></A></DIV></DIV>
<DIV class=promenu>
<LI class=on><SPAN id=nav_blog><A
href="http://blog.sina.com.cn/xianhuameng">博客</A></SPAN>
<LI><SPAN id=nav_photo><A
href="http://photo.blog.sina.com.cn/xianhuameng">相册</A></SPAN>
<LI><SPAN id=nav_music><A
href="http://music.sina.com.cn/m/1596986490">音乐</A></SPAN>
<LI><SPAN id=nav_vblog><A
href="http://you.video.sina.com.cn/xianhuameng">播客</A></SPAN>
<LI><SPAN id=nav_tiezi><A
href="http://profile.blog.sina.com.cn/xianhuameng">个人中心</A></SPAN> <!-- <li><span id="nav_quanzi"><a href="http://q.sina.com.cn/m/xianhuameng">圈子</a></span></li>--></LI></DIV></DIV>
<DIV class=termenutxt>
<DIV class=tmtcen>
<DIV class=floatLeft><SPAN><A
href="http://blog.sina.com.cn/xianhuameng">首页</A></SPAN><SPAN
class=linesp></SPAN><SPAN><A
href="http://blog.sina.com.cn/s/articlelist_1596986490_0_1.html">博文</A></SPAN><SPAN
class=linesp></SPAN><SPAN><A
href="http://blog.sina.com.cn/s/favourites_1596986490_1.html">收藏</A></SPAN><SPAN
class=linesp></SPAN><SPAN><A
href="http://profile.blog.sina.com.cn/circle.php?uid=1596986490&page=1&type=3">博客圈</A></SPAN><!--<span > <a href="http://blog.sina.com.cn/lm/rank/index.html" target="_blank">排行榜</a></span>--></DIV>
<DIV class=floatRight></DIV></DIV></DIV></DIV></DIV></DIV>
<DIV class=contentLayout>
<DIV class="column_2 floatLeft">
<DIV class="components730 SinaAd_hide" id=advertise_top></DIV>
<DIV class=components730>
<DIV class=component>
<DIV class=componentBar><SPAN class="floatRight articleFontSize"
id=articleFontManage>字体大小：<A onclick="changeFontSize(2);return false;"
href="http://blog.sina.com.cn/s/">大</A><B>中</B><A
onclick="changeFontSize(0);return false;"
href="http://blog.sina.com.cn/s/">小</A></SPAN> <SPAN class=title>正文</SPAN>
</DIV>
<DIV class="componentContent article">
<DIV class=comconblog>
<DIV class=articleTitle>
<DIV style="DISPLAY: inline"><B
id=t_5f30147a0100dkmv>第六章 用户权限管理(六） -- C#读写数据库Image字段</B><SPAN
class=time>(2009-04-20 15:53:40)</SPAN></DIV></DIV>
<DIV class=articleTag>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD>
<SCRIPT>var $tag='工作流,电子政务系统,it';var $tag_code='4ffbdedb72851a5aa1c6cdb29dd68b67';</SCRIPT>
标签：<A class=tag
href="http://uni.sina.com.cn/c.php?t=blog&k=%B9%A4%D7%F7%C1%F7&ts=bpost&stype=tag"
target=_blank>工作流</A><WBR> <A class=tag
href="http://uni.sina.com.cn/c.php?t=blog&k=%B5%E7%D7%D3%D5%FE%CE%F1%CF%B5%CD%B3&ts=bpost&stype=tag"
target=_blank>电子政务系统</A><WBR> <A class=tag
href="http://uni.sina.com.cn/c.php?t=blog&k=it&ts=bpost&stype=tag"
target=_blank>it</A><WBR> </TD>
<TD vAlign=top align=right width=250>分类：<A
href="http://blog.sina.com.cn/s/articlelist_1596986490_1_1.html">基于工作流的政务系统--实现</A></TD></TR></TBODY></TABLE></DIV>
<DIV class=articleContent id=articleBody>
<P><FONT style="FONT-SIZE: 16px"><STRONG>6.6 角色用户管理设计与实现</STRONG></FONT></P>
<P><STRONG>6.6.4 员工信息管理</STRONG> <WBR> <WBR> <WBR></P><A
href="http://photo.blog.sina.com.cn/showpic.html#blogid=5f30147a0100dkmv&url=http://static1.photo.sina.com.cn/orignal/5f30147at67f805db2ff0"
target=_blank></A>
<P align=center><A
href="http://photo.blog.sina.com.cn/showpic.html#blogid=5f30147a0100dkmv&url=http://static16.photo.sina.com.cn/orignal/5f30147at67f87d87e58f"
target=_blank><IMG style="MAX-WIDTH: 500px"
src="第六章%20用户权限管理(六）%20--%20C%23读写数据库Image字段_宪华_新浪博客_files/5f30147at67f87d87e58f.jpg"></A></P>
<P align=center> <WBR></P><A
href="http://photo.blog.sina.com.cn/showpic.html#blogid=5f30147a0100dkmv&url=http://static5.photo.sina.com.cn/orignal/5f30147at67f824b304a4"
target=_blank></A>
<P align=center>图6.20 员工信息管理页面<BR> <WBR></P>
<P align=left> <WBR> <WBR> <WBR>
如图6.20所示，员工信息管理页Employees.aspx程序较为复杂，主要使用了DataGrid控件。在控件中点击姓名，将弹出如图所示的员工信息表（EmployeeInfo.aspx）页面；点击员工照片（实际上是一个图片按钮ImageButton）将弹出显示大尺寸照片的页面DisplayImage.aspx；而且员工信息管理页下方的添加编辑控件既要负责添加员工信息，还要负责修改已有信息。当点击DataGrid控件的编辑按钮时，既要已原有信息填充页面下方的编辑控件，还要隐藏添加信息按钮，并显示保存修改按钮。</P>
<P align=left> <WBR> <WBR> <WBR> 下面逐一介绍各部分程序的代码：</P>
<P align=left> <WBR> <WBR> <WBR>
<STRONG>1、EmployeeInfo.aspx文件代码</STRONG>：</P>
<P align=left> <WBR> <WBR> <WBR> ......</P>
<P align=left> <WBR> <WBR> <WBR> <WBR><form id="Form1"
method="post"
runat="server"><BR> <WBR> <WBR> <WBR> <WBR> <WBR>
<table height="200" cellSpacing="0" cellPadding="0" width="600"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
align="center" <WBR>border="0"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr
align="center"><td>员工信息表</td></tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR>
</table><BR> <WBR> <WBR> <WBR> <WBR> <WBR>
<%<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
if(dr
!=null)<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
{<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
if(dr.Read())<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
{<BR> <WBR> <WBR> <WBR> <WBR> <WBR>
%><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <table
cellSpacing="0" cellPadding="6" width="500" align="center"
border="1"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr
align="center"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td>员工姓名</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td><%=dr["EmployeeName"]%></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td>性别</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td><%=dr["sex_alias"]%></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td
rowSpan="3"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<%<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
Image1.ImageUrl="DisplayImage.aspx?id="+dr["EmployeeID"];<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<WBR>%><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:Image id="Image1" runat="server" Width="70px"
Height="100px"></asp:Image></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr
align="center"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td>所属部门</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -