我要评论private void button2_click_1(object sender, system.eventargs e)
{
string pathname;
if (this.openfiledialog1.showdialog()==system.windows.forms.dialogresult.ok)
{
pathname = this.openfiledialog1.filename;
system.drawing.image img = system.drawing.image.fromfile(pathname);
this.picturebox1.image = img;
//将图像读入到字节数组
system.io.filestream fs = new system.io.filestream(pathname,system.io.filemode.open,system.io.fileaccess.read);
byte[] buffbyte = new byte[fs.length];
fs.read(buffbyte,0,(int)fs.length);
fs.close();
fs = null;
//建立command命令
string comm = @"insert into table1(img,name) values(@img,@name)";
this.sqlcommand1 = new system.data.sqlclient.sqlcommand ();
this.sqlcommand1.commandtype = system.data.commandtype.text ;
this.sqlcommand1.commandtext = comm;
this.sqlcommand1.connection = this.sqlconnection1 ;
//创建parameter
this.sqlcommand1.parameters.add("@img",system.data.sqldbtype.image);
this.sqlcommand1.parameters[0].value = //www.jb51.net/ianakin/archive/2012/02/02/buffbyte;
this.sqlcommand1.parameters.add("@name",system.data.sqldbtype.varchar);
this.sqlcommand1.parameters[1].value =//www.jb51.net/ianakin/archive/2012/02/02/pathname.substring(pathname.lastindexof("\\")+1);
try
{
this.sqlconnection1.open();
this.sqlcommand1.executenonquery();
this.sqlconnection1.close();
}
catch(system.exception ee)
{
messagebox.show(ee.message );
}
buffbyte = null;
this.filllistbox();
}
读取：
从数据库读图片到picturebox
sqlconnection conn=new sqlconnection(@"data source=chenyuming2004vsdotnet;uid=sa;pwd=cym;database=lhf");
conn.open();
sqlcommand cmd=new sqlcommand("select 照片 from fuser where password='1b'",conn);
sqldatareader reader=cmd.executereader();
reader.read();
memorystream buf=new memorystream((byte[])reader[0]);
image image=image.fromstream(buf,true);
picturebox1.image=image;
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！
网友评论