📄 第六章 用户权限管理(七） -- c#读写数据库image字段_宪华_新浪博客.htm
字号:
BindGrid()<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
{<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>string
strSql="select EmployeeID,GroupID,EmployeeName,Sex,Business,</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
CellPhone,HomePhone,Address,Notes,orgname=(select Group_Name from</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
organization where Group_ID=GroupID),shiredate=CONVERT(varchar(10),</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
HireDate, 120),CONVERT(varchar(10), BirthDate, 120) <WBR> as sbirthdate
from</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
Employees order by GroupID
asc";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
DataSet ds=new
Base().SQLExeDataSet(strSql);<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
if(ds
!=null)<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>
DataGrid1.DataSource=ds;<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
DataGrid1.DataBind();<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
ViewState["datagridsource"]=ds;<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
}<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>}</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
void
BindOrganizationList()<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
{<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
if(ViewState["listsource"].ToString() !="")</P>
<P
align=left> <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> <WBR> <WBR>DropDownList1.DataSource=(DataSet)ViewState["listsource"];<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
DropDownList1.DataBind();</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
}<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
}</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
//添加按钮<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
private void Button1_Click(object sender, System.EventArgs
e)<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
{<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<WBR>if(TextBox1.Text.Trim()=="")<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>
Label1.Text="姓名不能为空";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
return;<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
}</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
string strSql="INSERT INTO Employees(EmployeeName, Business, GroupID,
BirthDate,</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
HireDate, Address, HomePhone,CellPhone, Photo, PhotoImageType, Notes,Sex)
"<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
+" values(@EmployeeName,@Business,@GroupID,@BirthDate,@HireDate,@Address,</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
@HomePhone,@CellPhone,@Photo,@PhotoImageType,@Notes,@Sex)";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
SqlCommand mycommand=new
SqlCommand(strSql); <WBR> <WBR> <WBR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>//设置SQL参数<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
setprocargument(mycommand);</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
Base basecode=new
Base();<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
if(basecode.SQLExeNonQuery_proc(mycommand))<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>
BindGrid();</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <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> <WBR>TextBox1.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextBox2.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextBox3.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextBox4.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextBox5.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextBox6.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextBox7.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
TextBox8.Text="";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<WBR>}<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
else<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> <WBR>
EditMessage.InnerHtml="Insert Failed. Error Details are: "</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>
+
basecode.BaseSqlErrDes;<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
EditMessage.Style["color"]="red";<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>} <WBR> <WBR> <WBR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
}</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
//为删除按钮设置客户端提示<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>private
void Datagrid_ItemDataBound(object sender,</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
System.Web.UI.WebControls.DataGridItemEventArgs
e)<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
{<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>if(e.Item.ItemType
== ListItemType.Item ||e.Item.ItemType</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>==
ListItemType.AlternatingItem)<BR> <WBR> <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> <WBR> <WBR>
LinkButton btn =
(LinkButton)(e.Item.Cells[7].Controls[1]);<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
btn.Attributes.Add("onClick","JavaScript:return confirm('确定删除吗？')");</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
//也可以在页面代码中直接设置Image或ImageButton的ImageUrl属性,详见页面代码.</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
//System.Web.UI.WebControls.ImageButton myimage=(System.Web.UI.WebControls</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>//.ImageButton)e.Item.Cells[5].FindControl("ImageButton1");<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
//myimage.ImageUrl="DisplayImage.aspx?id="+DataGrid1.DataKeys</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
//[e.Item.ItemIndex]; <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR><BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
}<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
<WBR>}</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
//删除按钮<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
private void DataGrid_DeleteCommand(object source,</P>
<P
align=left> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
System.Web.UI.WebControls.DataGridCommandEventArgs<WBR>
e)<BR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR> <WBR>
{</P>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -