上传照片(WinForm)

B/S的系统上传图片直接保存到文件夹中。C/S的系统上传图片要把图片存到数据库中，SQL Server把数据库字段设为Image，Oracle把数据库字段设为BLOB。

图片上传到数据库中的代码。

C#code

   //浏览图片

       private void btnUp_Click(object sender, EventArgs e)

       {

           OpenFileDialog ofd =new OpenFileDialog();

           ofd.Title = "选择要上传的图片";

           ofd.Filter = "AllFiles(*.*)|*.*|位图(*.bmp)|*.bmp|JPEG(*.jpg)|*.jpg";

           ofd.ShowDialog();

           textBox1.Text = ofd.FileName;

           if (!File.Exists(ofd.FileName))

           {

               MessageBox.Show("照片为空");

               return;

           }

       }

 

 

       //上传保存到数据库

       private void btnUpLoad_Click(object sender, EventArgs e)

       {

           string strPath =txtbImage.Text.Trim();

           FileStream fs =new FileStream(strPath, FileMode.Open, FileAccess.Read);

           byte[] byteFile = new byte[fs.Length];

           fs.Read(byteFile, 0, (int)fs.Length);

           fs.Close();

           SqlConnection conn =new SqlConnection("Data Source=.;InitialCatalog=Test;Integrated Security=True");

               try

               {

                   SqlCommand cmd =new SqlCommand();

                   cmd.Connection = conn;

 

                   string strSql = "insert into test(FileName,Img)Values(@FileName,@Img)";

                   cmd.CommandText =strSql ;

                   //cmd.Parameters.AddWithValue("@FileName",strPath);

                   //cmd.Parameters.AddWithValue("@Img",byteFile);

                   //或者

                   SqlParameter[]parameters = new SqlParameter[2];

                   parameters[0] = new SqlParameter("@FileName", SqlDbType.NVarChar,200);

                   parameters[0].Value = strPath;

                   parameters[1] = new SqlParameter("@Img", SqlDbType.Image,int.MaxValue);

                   parameters[1].Value = byteFile;

                   cmd.Parameters.AddRange(parameters);

                   conn.Open();

                   cmd.ExecuteNonQuery();

                   conn.Close();

                   MessageBox.Show("上传成功");

               }

               catch

               {

                   conn.Close();

                   MessageBox.Show("上传失败！");

               }

       }

       //读到图片显示到PictureBox

       private void btnDownLoad_Click(object sender, EventArgs e)

       {

           byte[] bytFile;

           SqlConnection conn =new SqlConnection("Data Source=.;InitialCatalog=Test;Integrated Security=True");

               try

               {

                   SqlCommand cmd =new SqlCommand();

                   string strSql = "select img from test whereID=3";

                   cmd.Connection = conn;

                   cmd.CommandText = strSql;

                   conn.Open();

                   SqlDataReader sdr =cmd.ExecuteReader();

                   if (sdr.Read())

                   {

                       bytFile = (Byte[])sdr["Img"];

                   }

                   else

                   {

                       bytFile = new byte[0];

                   }

                   sdr.Close();

                   conn.Close();

                   //通过内存流MemoryStream，

                   //把byte[]数组fileContent加载到Image中并赋值给图片框的Image属性，

                   //让数据库中的图片直接显示在窗体上。

                   MemoryStream ms =new MemoryStream(bytFile, 0,bytFile.Length);

                   this.picImage.Image = Image.FromStream(ms);

                   //关闭内存流

                   ms.Close();

               }

               catch

               {

                   conn.Close();

                   MessageBox.Show("失败");

               }

       }