C#存储图片到数据库中的Image字段剖析

1、字号：大中小private void butt on 1_Click(object sen der, System.Eve ntArgs e图片文件所在的路径string filename= textBox1.Text;Bin aryReader reader =n ull;FileStream myfilestream = new FileStream(file name,FileMode.Ope n;tryreader =new Bin aryReader(myfilestream;存储图片到数组byte image = reader.ReadBytes(i ntmyfilestream.

2、Le ngth;/中。SqlC onn ecti on (server=test05;database=esdb2;uid=datatra n; pwd=qyrlusing (SqlComma nd comma nd = conn. CreateComma nd(comma nd.Comma ndText=INSERTNTO photo(photo VALUES (photo;comma nd.Parameters.Add(photo, image;conn. Ope n(;comma nd.ExecuteN on Query(;conn .Close(;MessageBox.Show(”文件

3、保存成功！,提示”,MessageBoxButto ns.OK,MessageBoxlc on .1 nformatio n;catch(IOExcepti on eeMessageBox.Show(ee.Message.ToStri ng(;fin allyif(reader!=nullreader.Close(;private void butt on 2_Click(object sen der, System.Eve ntArgs e/把数据表中Image字段中保存的图片信息转换图片形式在Piceture控件中显示出来。SqlC onn ecti on (server=test05;d

4、atabase=esdb2;uid=datatra n; pwd=qyrlusing (SqlComma nd comma nd = conn. CreateComma nd(Pid=Pid;comma nd.Comma ndText = select top 1 photo from photo where comma nd.Parameters.Add(id, textBox2.Text;conn. Ope n(;byte imageData = (bytecomma nd.ExecuteScalar(;conn .Close(;MemoryStream mStream = new MemoryStream(;mStream.Write(imageData, 0, imageData.Le ngth;mStream.Flush(;Bitmap img= new Bitmap(mStream; pictureBoxI .Im age=img;private void butt on 3_Click(object sen der, System.Eve ntArgs e ope nFileDialog1.ShowDialog(;private void ope nF ileDialog1_FileOk(object sen der,System.