title: ASP.NET fileupload images only, saving path and filename in sql table
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2780191/how-to-restrict-file-type-in-fileupload-control">How to restrict file type in FileUpload control</a>  </p>
  </blockquote>
  
  
  
  <p>I have a problem, using my image uploader. It will upload all type of files.
  I need code behind, to sort out if it's an image (jpg, png and so on).
  Then it needs to save the path and filename in my sql.
  Saving name and path is up and running, so is the regular expression. I now need to incorporate som code that i have found here. The question is, how it's done?</p>
  
  <p>My code behind is:</p>
  
  <pre><code>protected void btnUpload_Click(object sender, EventArgs e)
  {
      if (FileUpload1.PostedFile != null)
      {
          string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
  
          //Save files to disk
          FileUpload1.SaveAs(Server.MapPath("~/_PublicData/Images/" + FileName));
  
          //Add Entry to DataBase
          String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["Computer_Klubben_CommunitySiteConnectionString"].ConnectionString;
          SqlConnection con = new SqlConnection(strConnString);
          string strQuery = "insert into dbo.Billeder (FileName, FilePath)" + " values(@FileName, @FilePath)";
          SqlCommand cmd = new SqlCommand(strQuery);
          cmd.Parameters.AddWithValue("@FileName", FileName);
          cmd.Parameters.AddWithValue("@FilePath", "~/_PublicData/Images/" + FileName);
          cmd.CommandType = CommandType.Text;
          cmd.Connection = con;
  
          try
          {
              con.Open();
              cmd.ExecuteNonQuery();
          }
  
          catch (Exception ex)
          {
              Response.Write(ex.Message);
          }
  
          finally
          {
              con.Close();
              con.Dispose();
          }
      }
  }
  </code></pre>
  
  <p>I need to put that code inside the following code, that I have found here.
  <a href="https://stackoverflow.com/questions/4702811/how-can-i-upload-only-jpeg-files">How can i upload only jpeg files?</a></p>
  
  <p>Do I place my code after the code from here, or were do I place it?
  Please help.</p>