Windowformフォーム関連データベース記憶、画像読み出し、参照コード

namespace flowlayoutpanel_ 

{

    public partial class picturebox : Form

    {

        public picturebox()

        {

            InitializeComponent();

        }



        private void button1_Click(object sender, EventArgs e)

        {

            // 

            openFileDialog1.Filter = "@.Jpg|*.jpg|@.Png|*.png|@.Jif|*.jif|All files|*.*";

            DialogResult dr = openFileDialog1.ShowDialog();

            if (dr == DialogResult.OK)

            {

                // 

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

                Image img = System.Drawing.Bitmap.FromStream(fs); // 

                pictureBox1.Image = img;   // 

                fs.Close();



            }

        }

        // 

        private void button2_Click(object sender, EventArgs e)

        {

            openFileDialog1.Filter = "@.Jpg|*.jpg|@.Png|*.png|@.Jif|*.jif|All files|*.*";  // 

            DialogResult dr = openFileDialog1.ShowDialog();

            if (dr==DialogResult.OK)

            {

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

               BinaryReader br = new BinaryReader(fs);  // 

              byte[] fuffer= br.ReadBytes(int.Parse (fs.Length.ToString ()));



                // 

              SqlConnection coon = new SqlConnection("server=.;database=master;user=sa;pwd=123");

              SqlCommand cmd = coon.CreateCommand();

              coon.Open();

              cmd.CommandText = "insert into imagetable values (@fuffer)";

              cmd.Parameters.Clear();

              cmd.Parameters.Add("@fuffer",fuffer );

              cmd.ExecuteNonQuery();

              cmd.Dispose();

              coon.Close();

            }

        }

        // 

        private void button3_Click(object sender, EventArgs e)

        {

            SqlConnection coon = new SqlConnection("server=.;database=master;user=sa;pwd=123");

            SqlCommand cmd = coon.CreateCommand();

            coon.Open();

            cmd.CommandText = "select *from imagetable where code=7";

            SqlDataReader dr = cmd.ExecuteReader();

            byte[] buffer=null;

            if (dr.Read())

            {

                  buffer=(byte[])dr["imags"];

            }

            

            coon.Close();



            // buffer 

            MemoryStream ms = new MemoryStream(buffer);

            Image img = System.Drawing.Bitmap.FromStream(ms);

            pictureBox1.Image = img;



            

        }

    }

}