C#

private void pictureBox3_DoubleClick(object sender, EventArgs e)
           {
               intASUserListSelectedIndex = lbxAssistSuiteUserList.SelectedIndex;
               bool FoundUser = false;
               FileDialog fldlg = new OpenFileDialog();
               //specify your own initial directory

               if (lbxAssistSuiteUserList.SelectedIndex > -1)
               {
                   try
                   {
                       fldlg.InitialDirectory = @":C\";
                       //this will allow only those\ file extensions to be added
                       fldlg.Filter = "Image File (*.jpg;*.bmp;*.gif)|*.jpg;*.bmp;*.gif|(*.gif)|*.gif|(*.jpg)|*.jpg|(*.jpeg)|*.jpeg|(*.bmp)|*.bmp|(*.wmf)|*.wmf|(*.png)|*.png";
                       //fldlg.ShowDialog();
                       if (fldlg.ShowDialog() == DialogResult.OK)
                       {
                           imagename  = fldlg.FileName;
                           Bitmap newimg = new Bitmap(imagename);
                           pictureBox3.SizeMode = PictureBoxSizeMode.Zoom;
                           pictureBox3.Image =(Image)newimg;
                           //pictureBox3.Image = System.Drawing.Image.FromFile(openFileDialog1.FileName);
                           pictureBox3.Refresh();

                           //Update the SQL Tables.
                           lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
                           btnUpdateAssistUsers_Click(sender, e);
                           lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
                           updatedata();
                       }


                       fldlg = null;
                       lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
                   }
                   catch (System.ArgumentException ae)
                   {
                       imagename = " ";
                       MessageBox.Show(ae.Message.ToString());
                   }
                   catch (Exception ex)
                   {
                       MessageBox.Show(ex.Message.ToString());
                   }
               }
           }

       private void updatedata()
       {

           bool FoundMe = false;
           int UserIndex = -1;
       //use filestream object to read the image.
       //read to the full length of image to a byte array.
       //add this byte as an oracle parameter and insert it into database.

           try
           {
               //proceed only when the image has a valid path
               if (imagename != "")
               {
               FileStream fs;
               fs = new FileStream(@imagename, FileMode.Open, FileAccess.Read);

               //a byte array to read the image
               byte[] picbyte = new byte[fs.Length];
               fs.Read(picbyte, 0, System.Convert.ToInt32(fs.Length));
               fs.Close();

               //open the database using odp.net and insert the data
               string connstr = WhatIsMyConnectionString;
               SqlConnection conn = new SqlConnection(connstr);
               conn.Open();

               string query;
               //Find the index
               for (i = 0; i < ApplicationUsersArray.Count; i++)
               {
                   if (((DomainUsersClass)ApplicationUsersArray[i]).WindowsLogonName == lbxAssistSuiteUserList.Items[lbxAssistSuiteUserList.SelectedIndex].ToString())
                   {
                       FoundMe = true;
                       break;
                   }
               }
               if (FoundMe = true)
               {
                   if (((DomainUsersClass)ApplicationUsersArray[i]).PicIndex == "")
                   {
                       UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);
                       //query = "insert into tblApplicationUsersPic(id_image,pic) values(" +
                       //UserIndex.ToString() + "," + " @pic)";
                       query = "insert into tblApplicationUsersPic(id_image,pic) values(@i, @p)";

                   }
                   else
                   {
                       UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);
                       //query = "update tblApplicationUsersPic set pic = @pic where id_image = '" + UserIndex.ToString() + "' ";
                       query = "update tblApplicationUsersPic set pic = @p where id_image = @i";
                   }
               }
               else
               {
                   MessageBox.Show("We have a serious problem. This should Never Happen. \n The Array did not find the correct users to grab their index for the Picture. \n The Application will now quit.");
                   return;
               }

               //sqlCon.Open();

               SqlCommand sc = new SqlCommand(query, conn);



               sc.Parameters.AddWithValue("@i", UserIndex.ToString());
                   sc.Parameters.ty
               sc.Parameters.AddWithValue("@p", picbyte);

               sc.ExecuteNonQuery();

               sc.Dispose();
               conn.Close();
               conn.Dispose();

               if (FoundMe = true)
               {
                   SQLUpdate(WhatIsMyConnectionString, "tblApplicationUsers", "tblApplicationUsersPic_idx = (Select idx_tblApplicationUserPic from tblApplicationUsersPic where id_image = '" + UserIndex.ToString() + "') ","delflag = 0 and idx_tblApplicationUsers = '" + UserIndex.ToString() + "' ");
                   //UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);

               }

               /*
               SqlParameter picparameter = new SqlParameter();
               picparameter.SqlDbType = SqlDbType.Image;
               picparameter.ParameterName = "pic";
               picparameter.Value = picbyte;
               SqlCommand cmd = new SqlCommand(query, conn);
               cmd.Parameters.Add(picparameter);
               cmd.ExecuteNonQuery();

               if (FoundMe = true)
               {
                   SQLUpdate(WhatIsMyConnectionString, "tblApplicationUsers", "tblApplicationUsersPic_idx = (Select idx_tblApplicationUserPic from tblApplicationUsersPic where id_image = '" + UserIndex.ToString() + "') ","delflag = 0 and idx_tblApplicationUsers = '" + UserIndex.ToString() + "' ");
                   //UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);

               }
               MessageBox.Show("Image Added");
               cmd.Dispose();
               conn.Close();
               conn.Dispose();
               //Connection();
               */
               }


           }
           catch (System.ArgumentException ae)
           {
               imagename = " ";
               MessageBox.Show(ae.Message.ToString());
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);
           }



       }