Database access Pictures

   Private voidButton1_Click (Objectsender, EventArgs e)//form open file picture{Openfiledialog1.filter="@.jpg|*.jpg|all files|*.*"; DialogResult Dr=Openfiledialog1.showdialog (); if(dr = =DialogResult.OK) {FileStream fs=NewFileStream (Openfiledialog1.filename,filemode.open,fileaccess.read); Image img=System.Drawing.Bitmap.FromStream (FS); pictureBox1.Image=img; }        }               Private voidButton2_Click (Objectsender, EventArgs e)//Picture in database{Openfiledialog1.filter="@.jpg|*.jpg|@.gif|*.gif| All Files|*.*"; DialogResult Dr=Openfiledialog1.showdialog (); if(dr = =DialogResult.OK) {FileStream fs=NewFileStream (Openfiledialog1.filename,filemode.open,fileaccess.read); BinaryReader BR=NewBinaryReader (FS); byte[] buffer = br. Readbytes (int. Parse (fs.                Length.tostring ())); SqlConnection Conn=NewSqlConnection ("server=.; Database=hq0325;user=sa;pwd=123"); SqlCommand cmd=Conn.                CreateCommand (); Cmd.commandtext="INSERT into imgtable values (@buffer)"; Cmd. Parameters.Add ("@buffer", buffer); Conn.                Open (); Cmd.                ExecuteNonQuery (); Cmd.                Dispose (); Conn.                Close (); MessageBox.Show ("saved successfully"); }        }        Private voidButton3_Click (Objectsender, EventArgs e)//get the picture from the database and show the first one in the form{SqlConnection conn=NewSqlConnection ("server=.; Database=hq0325;user=sa;pwd=123"); SqlCommand cmd=Conn.            CreateCommand (); Cmd.commandtext="SELECT * from imgtable where code=1"; Conn.            Open (); SqlDataReader Dr=cmd.            ExecuteReader (); Dr.                            Read (); byte[] buffer = (byte[]) dr["IMGs"]; Cmd.            Dispose (); Conn.            Close (); MemoryStream Ms=NewMemoryStream (buffer); Ms. Write (Buffer,0, buffer.            Length); Image img=Image.fromstream (MS); pictureBox1.Image=img; }    }

Database access Pictures