这是读写图片的例子. ==================================== Introduction Some times we need to store binary data in database. SQL Server provides a special data type called image that can hold such binary data. The examples of binary data include images, documents etc. In this article we will see how we can store and retrieve images in SQL server database Creating Tables In order to work with the examples of this article you will need a table in some database. (You may chose to create it in existing database or create a enw database all together) Following table explains structure of the table : Column Name Datatype Purpose ID Integer identity column Primary key IMGTITLE Varchar(50) Stores some user friendly title to identity the image IMGTYPE Varchar(50) Stores image content type. This will be same as recognized content types of ASP.NET IMGDATA Image Stores actual image or binary data. Storing images in SQL Server database In order to store images to the table you will first upload them to your web server from the client browser. You can develop a web form that accepts image title via a TextBox web control and image file via HTML File Server Control. Make sure you set encType attribute of the Form to multipart/form-data. Stream imgdatastream = File1.PostedFile.InputStream; int imgdatalen = File1.PostedFile.ContentLength; string imgtype = File1.PostedFile.ContentType; string imgtitle = TextBox1.Text; byte[] imgdata = new byte[imgdatalen]; int n = imgdatastream.Read(imgdata,0,imgdatalen); string connstr= ((NameValueCollection)Context.GetConfig ("appSettings"))["connstr"]; SqlConnection connection = new SqlConnection(connstr); SqlCommand command = new SqlCommand ("INSERT INTO ImageStore(imgtitle,imgtype,imgdata) VALUES ( @imgtitle, @imgtype,@imgdata )", connection );SqlParameter paramTitle = new SqlParameter ("@imgtitle", SqlDbType.VarChar,50 ); paramTitle.Value = imgtitle; command.Parameters.Add( paramTitle);SqlParameter paramData = new SqlParameter ( "@imgdata", SqlDbType.Image ); paramData.Value = imgdata; command.Parameters.Add( paramData );SqlParameter paramType = new SqlParameter ( "@imgtype", SqlDbType.VarChar,50 ); paramType.Value = imgtype; command.Parameters.Add( paramType );connection.Open(); int numRowsAffected = command.ExecuteNonQuery(); connection.Close();Retrieving images from database Now, let us read the images from the database we stored previously. Here, we will output the image directly to the browser. You can instead save it as a file or do whatever you want. private void Page_Load(object sender, System.EventArgs e) { string imgid =Request.QueryString["imgid"]; string connstr=((NameValueCollection) Context.GetConfig("appSettings"))["connstr"]; string sql="SELECT imgdata, imgtype FROM ImageStore WHERE id = " + imgid; SqlConnection connection = new SqlConnection(connstr); SqlCommand command = new SqlCommand(sql, connection); connection.Open(); SqlDataReader dr = command.ExecuteReader(); if(dr.Read()) { Response.ContentType = dr["imgtype"].ToString(); Response.BinaryWrite( (byte[]) dr["imgdata"] ); } connection.Close(); }In the above code we have opened a connection with our database. We then SELECT images via datareader. Since the image data is binary data we used Response.BinaryWrite instead of normal Response.Write.
====================================
Introduction
Some times we need to store binary data in database. SQL Server provides a special data type called image that can hold such binary data. The examples of binary data include images, documents etc. In this article we will see how we can store and retrieve images in SQL server database
Creating Tables
In order to work with the examples of this article you will need a table in some database. (You may chose to create it in existing database or create a enw database all together) Following table explains structure of the table : Column Name Datatype Purpose
ID Integer identity column Primary key
IMGTITLE Varchar(50) Stores some user friendly title to identity the image
IMGTYPE Varchar(50) Stores image content type. This will be same as recognized content types of ASP.NET
IMGDATA Image Stores actual image or binary data. Storing images in SQL Server database
In order to store images to the table you will first upload them to your web server from the client browser. You can develop a web form that accepts image title via a TextBox web control and image file via HTML File Server Control. Make sure you set encType attribute of the Form to multipart/form-data.
Stream imgdatastream = File1.PostedFile.InputStream;
int imgdatalen = File1.PostedFile.ContentLength;
string imgtype = File1.PostedFile.ContentType;
string imgtitle = TextBox1.Text;
byte[] imgdata = new byte[imgdatalen];
int n = imgdatastream.Read(imgdata,0,imgdatalen);
string connstr=
((NameValueCollection)Context.GetConfig
("appSettings"))["connstr"];
SqlConnection connection = new SqlConnection(connstr);
SqlCommand command = new SqlCommand
("INSERT INTO ImageStore(imgtitle,imgtype,imgdata)
VALUES ( @imgtitle, @imgtype,@imgdata )", connection );SqlParameter paramTitle = new SqlParameter
("@imgtitle", SqlDbType.VarChar,50 );
paramTitle.Value = imgtitle;
command.Parameters.Add( paramTitle);SqlParameter paramData = new SqlParameter
( "@imgdata", SqlDbType.Image );
paramData.Value = imgdata;
command.Parameters.Add( paramData );SqlParameter paramType = new SqlParameter
( "@imgtype", SqlDbType.VarChar,50 );
paramType.Value = imgtype;
command.Parameters.Add( paramType );connection.Open();
int numRowsAffected = command.ExecuteNonQuery();
connection.Close();Retrieving images from database
Now, let us read the images from the database we stored previously. Here, we will output the image directly to the browser. You can instead save it as a file or do whatever you want.
private void Page_Load(object sender, System.EventArgs e)
{
string imgid =Request.QueryString["imgid"];
string connstr=((NameValueCollection)
Context.GetConfig("appSettings"))["connstr"];
string sql="SELECT imgdata, imgtype FROM ImageStore WHERE id = "
+ imgid;
SqlConnection connection = new SqlConnection(connstr);
SqlCommand command = new SqlCommand(sql, connection);
connection.Open();
SqlDataReader dr = command.ExecuteReader();
if(dr.Read())
{
Response.ContentType = dr["imgtype"].ToString();
Response.BinaryWrite( (byte[]) dr["imgdata"] );
}
connection.Close();
}In the above code we have opened a connection with our database. We then SELECT images via datareader. Since the image data is binary data we used Response.BinaryWrite instead of normal Response.Write.
{
string strDName = DllName();
if (strDName.Length==0)
{
Pub.ShowErr("请先选择要更新的项目");
return;
}
FileInfo fi = new FileInfo(strDName);
DsFileUpdate.ProgramFileRow myRow=this.dsQuery.ProgramFile.FindByFileName(strDName);
if (myRow.CompileTime<fi.LastWriteTime)
myRow.CompileTime = DateTime.Now;
myRow.UpdateMan = this.currUser.UserCName;
myRow.UpDateTime = fi.LastWriteTime;
myRow.FileData = new byte[fi.Length];
FileStream fs = fi.OpenRead();
fs.Read(myRow.FileData,0,(int)fi.Length);
fs.Close();
Console.WriteLine("数据长度{0}",myRow.FileData.Length);
Console.WriteLine(myRow.RowState.ToString());
Console.WriteLine();
this.sqlDataAdapter1.Update(this.dsQuery.ProgramFile);
}private void button2_Click(object sender, System.EventArgs e)
{
OpenFileDialog myOpen = new OpenFileDialog();
myOpen.RestoreDirectory = true;
if (myOpen.ShowDialog() == DialogResult.OK)
{
FileInfo fi = new FileInfo(myOpen.FileName);
DsFileUpdate.ProgramFileRow myRow = this.dsQuery.ProgramFile.FindByFileName(fi.Name);
if (myRow == null)
{
myRow = this.dsQuery.ProgramFile.NewProgramFileRow();
myRow.FileName = fi.Name;
myRow.CompileTime = DateTime.Now;
myRow.UpdateMan = this.currUser.UserCName;
myRow.UpDateTime = fi.LastWriteTime;
myRow.FileData = new Byte[fi.Length];
FileStream fs = fi.OpenRead();
fs.Read(myRow.FileData,0,(int)fi.Length);
fs.Close();
this.dsQuery.ProgramFile.AddProgramFileRow(myRow);
this.sqlDataAdapter1.Update(this.dsQuery.ProgramFile);
}
}
}