Save multiple uploaded files in MySQL database using C# in ASP.Net

Hi georgeacuster...,

Refer below code.

HTML

<asp:FileUpload ID="FileUpload1" runat="server" BackColor="Yellow" accept=".jpg" />
<asp:FileUpload ID="FileUpload2" runat="server" BackColor="Yellow" accept=".jpg" />
<asp:FileUpload ID="FileUpload3" runat="server" BackColor="Yellow" accept=".jpg" />
<asp:ImageButton ID="imgsave" runat="server" OnClick="imgsave_Click" ToolTip="Save img"
    ImageUrl="/Img/save_button.gif" OnClientClick="if (!confirm('Confirm?')) return false;" />

Namespaces

using System.Configuration;
using System.Data.MySqlClient;
using System.IO;

Code

protected void imgsave_Click(object sender, EventArgs e)
{
    HttpPostedFile file1 = FileUpload1.PostedFile;
    HttpPostedFile file2 = FileUpload2.PostedFile;
    HttpPostedFile file3 = FileUpload3.PostedFile;
    if (!Directory.Exists(Server.MapPath("~/Images")))
    {
        file1.SaveAs(Server.MapPath("~/Images/") + Path.GetFileName(file1.FileName));
        file2.SaveAs(Server.MapPath("~/Images/") + Path.GetFileName(file2.FileName));
        file3.SaveAs(Server.MapPath("~/Images/") + Path.GetFileName(file3.FileName));
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (MySqlConnection conn = new MySqlConnection(constr))
        {
            string sql = "INSERT INTO Files (FileUpload1, FileUpload2, FileUpload3) VALUES (@FileUpload1, @FileUpload2, @FileUpload3)";
            using (MySqlCommand cmd = new MySqlCommand(sql, conn))
            {
                cmd.Parameters.AddWithValue("@FileUpload1", Path.GetFileNameWithoutExtension(file1.FileName));
                cmd.Parameters.AddWithValue("@FileUpload2", Path.GetFileNameWithoutExtension(file2.FileName));
                cmd.Parameters.AddWithValue("@FileUpload3", Path.GetFileNameWithoutExtension(file3.FileName));
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
            }
        }
    }
}