📄 第六章 用户权限管理(六） -- c#读写数据库image字段_宪华_新浪博客.htm
字号:
BackColor="#EEEEEE"></HeaderStyle><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<Columns><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:HyperLinkColumn Target="_blank" DataNavigateUrlField="EmployeeID"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
DataNavigateUrlFormatStr<WBR>ing="EmployeeInfo.aspx?id={0}"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>DataTextField="EmployeeName"
HeaderText="员工姓名"></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:HyperLinkColumn><!-- 如图6.21所示
--><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:BoundColumn DataField="orgname"
ReadOnly="True" <WBR>HeaderText="部门名称"></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:BoundColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:BoundColumn DataField="Business"
HeaderText="职务"></asp:BoundColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:BoundColumn DataField="shiredate"
HeaderText="入职时间"></asp:BoundColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:BoundColumn DataField="CellPhone"
HeaderText="电话号码"></asp:BoundColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:TemplateColumn HeaderText="照片"><!-- 如图6.22所示
--> <WBR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<ItemTemplate><!-- 借用了UpdateCommand事件处理函数
--><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR><asp:ImageButton
id=ImageButton1 runat="server" Width="30px"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
CommandName="Update" Height="40px" ImageUrl='<%# FormatURL((DataBinder</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
.Eval(Container.DataItem, "EmployeeID")).ToString()) %>'></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR><!--
利用后台代码的FormatURL函数处理容器列
--><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:ImageButton><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</ItemTemplate><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:TemplateColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText=""
CancelText=""</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
EditText="编辑"><!-- 对应EditCommand事件处理函数 --></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:EditCommandColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:TemplateColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<ItemTemplate><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:LinkButton id="LinkButton1" runat="server"
CommandName="Delete">删除</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:LinkButton><!-- 借用了DeleteCommand事件处理函数
--><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</ItemTemplate><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:TemplateColumn><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</Columns><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<PagerStyle Font-Size="9pt" HorizontalAlign="Right" ForeColor="#3366FF"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
Mode="NumericPages"></PagerStyle><!-- 对应PageIndexChanged事件处理函数
--><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:datagrid></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR></td></tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR></table><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR><table
cellSpacing="0" cellPadding="0" width="100%"
border="0"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr
height="25"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR><TD <WBR>
vAlign="bottom">添加(编辑)员工信息</TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
......</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</TR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR></TABLE><BR> <WBR> <WBR> <WBR> <WBR> <WBR>
......<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR><table
cellSpacing="2" cellPadding="2" width="100%" align="right"
border="0"><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td align="right"
width="10%">员工姓名：</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td width="30%"><asp:textbox id="TextBox1"
runat="server"></asp:textbox></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:label id="Label1" runat="server"
ForeColor="Red"></asp:label></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:textbox id="TextBox9" runat="server"
Visible="False"></asp:textbox></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</td><!-- 隐藏文本框TextBox9用于保存员工编号（编号不可修改，保存修改信息时使用）
--><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td align="right"
width="10%">所属部门：</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR><td
width="50%"></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:dropdownlist id="DropDownList1"
runat="server" <WBR>DataValueField="Group_ID"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
DataTextField="Group_Name"></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</asp:dropdownlist>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;性别：<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:radiobutton id="RadioButton1" runat="server" GroupName="Sex"
Checked="True"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
Text="男"></asp:radiobutton></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:radiobutton id="RadioButton2" runat="server" GroupName="Sex"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
Text="女"></asp:radiobutton></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR></tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td
align="right">职务(职责)：</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td><asp:textbox id="TextBox2"
runat="server"></asp:textbox></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td align="right"><FONT
face="宋体">出生日期：</FONT></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td><asp:textbox id="TextBox3"
runat="server"></asp:textbox><asp:label id="Label2"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<WBR>runat="server"
ForeColor="Red"></asp:label></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td align="right"><FONT
face="宋体">入职日期：</FONT></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td><asp:textbox id="TextBox4"
runat="server"></asp:textbox><asp:label id="Label3"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
runat="server"
ForeColor="Red"></asp:label></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td align="right">&nbsp;<FONT
face="宋体">家庭住址：</FONT></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td><asp:textbox id="TextBox5" runat="server"
Columns="60"></asp:textbox></td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD align="right"><FONT
face="宋体">家庭电话：</FONT></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD><asp:textbox id="TextBox6"
runat="server"></asp:textbox></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD align="right"><FONT
face="宋体">手机号码：</FONT></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD><asp:textbox id="TextBox7"
runat="server"></asp:textbox></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</TR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD align="right"><FONT
face="宋体">上传照片：</FONT></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD><INPUT id="PersonImage" type="file" name="PersonImage"
runat="server"></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD align="right"><FONT
face="宋体">员工简历：</FONT></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<TD><asp:textbox id="TextBox8" runat="server" Columns="100"
Rows="6"</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextMode="MultiLine"></asp:textbox></TD><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
</TR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<tr><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td
align="right">&nbsp;</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td>&nbsp;</td><td>&nbsp;</td><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<td>&nbsp;<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:button id="Button1" runat="server"
Text="添加员工"></asp:button></P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<asp:button id="Button2" runat="server"
Text="修改员工信息"></asp:button><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -