上传图片到数据库:using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;namespace myUpLoad
{
/// <summary>
/// img2sql 的摘要说明。
/// </summary>
public class img2sql : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox imgTitleTextBox;
protected System.Web.UI.HtmlControls.HtmlInputFile upLoadImg;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.Button Button1;
protected SqlConnection myConnection;private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
myConnection=new SqlConnection(conn);
}#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);}
#endregionprivate void Button1_Click(object sender, System.EventArgs e)
{
Stream myStream=upLoadImg.PostedFile.InputStream;
int imgDataLen=upLoadImg.PostedFile.ContentLength;
string imgType=upLoadImg.PostedFile.ContentType;
string imgTitle=imgTitleTextBox.Text;
byte[] imgData=new byte[imgDataLen];
int n=myStream.Read(imgData,0,imgDataLen);//string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
//SqlConnection myConnection=new SqlConnection(conn);SqlCommand myCommand = new SqlCommand("INSERT INTO image (imgtitle,imgtype,imgdata) VALUES ( @imgtitle, @imgtype, @imgdata )", myConnection);myCommand.Parameters.Add(new SqlParameter("@imgtitle",SqlDbType.VarChar,50));
myCommand.Parameters["@imgtitle"].Value=imgTitle;myCommand.Parameters.Add(new SqlParameter("@imgtype",SqlDbType.VarChar,50));
myCommand.Parameters["@imgtype"].Value=imgType;myCommand.Parameters.Add(new SqlParameter("@imgdata",SqlDbType.Image));
myCommand.Parameters["@imgdata"].Value=imgData;myConnection.Open();
int numRowsAffected=myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
}显示:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;namespace myUpLoad
{
/// <summary>
/// showimg 的摘要说明。
/// </summary>
public class showimg : System.Web.UI.Page
{
protected SqlConnection myConnection;private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string imgID=Request.QueryString["imgid"];
string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
//string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
myConnection=new SqlConnection(conn);string selectCmd="select imgdata,imgtype from image where id="+imgID;
SqlCommand myCommand=new SqlCommand(selectCmd,myConnection);
myConnection.Open();
SqlDataReader myDataReader=myCommand.ExecuteReader();if (myDataReader.Read())
{
Response.ContentType=myDataReader["imgtype"].ToString();
Response.BinaryWrite((byte[])myDataReader["imgdata"]);
}
}#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;namespace myUpLoad
{
/// <summary>
/// img2sql 的摘要说明。
/// </summary>
public class img2sql : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox imgTitleTextBox;
protected System.Web.UI.HtmlControls.HtmlInputFile upLoadImg;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.Button Button1;
protected SqlConnection myConnection;private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
myConnection=new SqlConnection(conn);
}#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);}
#endregionprivate void Button1_Click(object sender, System.EventArgs e)
{
Stream myStream=upLoadImg.PostedFile.InputStream;
int imgDataLen=upLoadImg.PostedFile.ContentLength;
string imgType=upLoadImg.PostedFile.ContentType;
string imgTitle=imgTitleTextBox.Text;
byte[] imgData=new byte[imgDataLen];
int n=myStream.Read(imgData,0,imgDataLen);//string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
//SqlConnection myConnection=new SqlConnection(conn);SqlCommand myCommand = new SqlCommand("INSERT INTO image (imgtitle,imgtype,imgdata) VALUES ( @imgtitle, @imgtype, @imgdata )", myConnection);myCommand.Parameters.Add(new SqlParameter("@imgtitle",SqlDbType.VarChar,50));
myCommand.Parameters["@imgtitle"].Value=imgTitle;myCommand.Parameters.Add(new SqlParameter("@imgtype",SqlDbType.VarChar,50));
myCommand.Parameters["@imgtype"].Value=imgType;myCommand.Parameters.Add(new SqlParameter("@imgdata",SqlDbType.Image));
myCommand.Parameters["@imgdata"].Value=imgData;myConnection.Open();
int numRowsAffected=myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
}显示:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;namespace myUpLoad
{
/// <summary>
/// showimg 的摘要说明。
/// </summary>
public class showimg : System.Web.UI.Page
{
protected SqlConnection myConnection;private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string imgID=Request.QueryString["imgid"];
string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
//string conn="server=(local);database=test;uid=sa;pwd=ilovenm";
myConnection=new SqlConnection(conn);string selectCmd="select imgdata,imgtype from image where id="+imgID;
SqlCommand myCommand=new SqlCommand(selectCmd,myConnection);
myConnection.Open();
SqlDataReader myDataReader=myCommand.ExecuteReader();if (myDataReader.Read())
{
Response.ContentType=myDataReader["imgtype"].ToString();
Response.BinaryWrite((byte[])myDataReader["imgdata"]);
}
}#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
{
string fileEXT=upload_file.PostedFile.FileName.Substring(upload_file.PostedFile.FileName.Length-3).ToLower();
int errorno=0;
if(upload_file.PostedFile==null || upload_file.PostedFile.FileName.Length<3)
{
Info.InnerHtml="请先选择一个图片再点粘贴。";
errorno=1;
}
else
{
if(fileEXT!="gif" && fileEXT!="jpg" && fileEXT!="zip" && fileEXT!="rar" )
{
Info.InnerHtml="只接受 jpg,gif,zip,rar 四种格式。";
errorno=1;
}
else if(upload_file.PostedFile.ContentLength==0)
{
Info.InnerHtml="请先选择一个图片再点粘贴。";
errorno=1;
}
else if(upload_file.PostedFile.ContentLength>600000)
{
Info.InnerHtml="图片大小限定在600K以内。";
errorno=1;
}
}
if(errorno==0)
{
string path=Server.MapPath("UpImage");
string y=DateTime.Now.Year.ToString();
string m=DateTime.Now.Month.ToString();
string d=DateTime.Now.Day.ToString();
string filename=y+m+d;
Random r=new Random();
filename=filename+r.Next(1000);
filename=filename+"."+upload_file.PostedFile.FileName.Substring(upload_file.PostedFile.FileName.Length-3);
string FN="UpImage/"+filename;
filename=path+"/"+filename;
upload_file.PostedFile.SaveAs(filename);
if (fileEXT=="gif")
{
Response.Write("<"+"script>parent.Post.sBody.value+='此主题相关图片如下:'</"+"script>");
}
else if(fileEXT=="jpg")
{
Response.Write("<"+"script>parent.Post.sBody.value+='此主题相关图片如下:'</"+"script>"); }
else if(fileEXT=="zip")
{
Response.Write("<"+"script>parent.Post.sBody.value+='请点击此处下载
'</"+"script>");
}
else if(fileEXT=="rar")
{
Response.Write("<"+"script>parent.Post.sBody.value+='请点击此处下载
'</"+"script>");
}
upload_file.Visible=false;
Button1.Visible=false;
Info.InnerHtml="成功上传一个文件点击 <a href=Upimages.aspx>这儿</a> 继续上传";
Info.Visible=true;
}
else
{
Info.Visible=true;
}