HttpPostedFile upPhoto = FileUpload1.PostedFile;
int upPhotoLength = upPhoto.ContentLength;
byte[] content = new Byte[upPhotoLength];
Stream PhotoStream = upPhoto.InputStream;
PhotoStream.Read(content, 0, upPhotoLength); //连接数据库
string constr = MySql数据库连接字符串
MySqlConnection mycn = new MySqlConnection(constr);//创建一个connection连接
mycn.Open();//打开数据库连接 string SQL = string.Format("Insert into image(countent2) values(@content)"); MySqlCommand mycm = new MySqlCommand(SQL, mycn);//执行sql命令
MySqlParameter para =mycm.Parameters.Add("@content",MySqlDbType.LongBlob); para.Value = content; mycm.ExecuteNonQuery();
mycn.Close();//关闭connection连接怎么写才对请帮忙了
int upPhotoLength = upPhoto.ContentLength;
byte[] content = new Byte[upPhotoLength];
Stream PhotoStream = upPhoto.InputStream;
PhotoStream.Read(content, 0, upPhotoLength); //连接数据库
string constr = MySql数据库连接字符串
MySqlConnection mycn = new MySqlConnection(constr);//创建一个connection连接
mycn.Open();//打开数据库连接 string SQL = string.Format("Insert into image(countent2) values(@content)"); MySqlCommand mycm = new MySqlCommand(SQL, mycn);//执行sql命令
MySqlParameter para =mycm.Parameters.Add("@content",MySqlDbType.LongBlob); para.Value = content; mycm.ExecuteNonQuery();
mycn.Close();//关闭connection连接怎么写才对请帮忙了
只是图片的话··用个二进制数组保存就可以了···
//将图像保存到SQL server2000的Image字段中 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 = buffByte; this.sqlCommand1.Parameters.Add("@name",System.Data.SqlDbType.VarChar); this.sqlCommand1.Parameters[1].Value =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(); }读取:从数据库读图片到pictureboxSqlConnection 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;