title: asp.net: upload images to SQL using imageupload
body: <p>i have a database column 'images' which can hold binary data, for some reason the images doesnt want to upload. it doest pull any exceptions or aything wrong with the code:</p>
  
  <p>here is extracts of the code</p>
  
  <pre><code>protected void BtnAdd_Click(object sender, EventArgs e)
      {
       string imgpath = FileUploadImage.FileName.ToString();
       DBConnectivity.Add(imgpath);
      }
  here is the DBCoectivity Class:
  public static void Add(string imgpath)
      {
          byte[] imgbt = null;
          FileStream fstream = new FileStream(imgpath, FileMode.Open, FileAccess.Read);
           BinaryReader BR = new BinaryReader(fstream);
           imgbt = BR.ReadBytes((int)fstream.Length);
  
          SqlConnection myConnection = GetConnection();
          string myQuery = "INSERT INTO images( imagePath) VALUES ( @IMG )";
          SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
          try
          {
              myConnection.Open();
              myCommand.Parameters.Add(new SqlParameter("@IMG",imgbt)); 
              myCommand.ExecuteNonQuery();
          }
          catch (Exception ex)
          {
              Console.WriteLine("Exception in DBHandler", ex);
          }
          finally
          {
              myConnection.Close();
          }
      }
  </code></pre>