<%@ Page Title="" Language="C#" MasterPageFile="~/site.master" AutoEventWireup="true" CodeFile="GalleryUpload Enhanced.aspx.cs" Inherits="GalleryUpload" %>

<asp:Content ID="Content1" ContentPlaceHolderID="mainContent" Runat="Server">
    <asp:FileUpload ID="FileUpload1" runat="server" />
    <br />
    <asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSourceFixtures" 
        DataTextField="FixtureDate" DataValueField="FixtureID"></asp:ListBox>
    <asp:SqlDataSource ID="SqlDataSourceFixtures" runat="server" 
        ConnectionString="<%$ ConnectionStrings:WroxUnitedMasterString %>" 
        SelectCommand="SELECT [FixtureID], [FixtureDate] FROM [Fixtures] ORDER BY [FixtureDate]">
    </asp:SqlDataSource>
    <br />
    <asp:Label ID="Label2" runat="server" Text="User Name"></asp:Label>
    :&nbsp;&nbsp;&nbsp;
    <asp:TextBox ID="TextBoxMemberName" runat="server"></asp:TextBox>
    <br />
    <asp:Label ID="Label1" runat="server" Text="Comments"></asp:Label>
    :&nbsp;&nbsp;&nbsp;
    <asp:TextBox ID="TextBoxNotes" runat="server"></asp:TextBox>
    <br />
    <asp:SqlDataSource ID="SqlDataSourceCreateGalleryRecord" runat="server" 
        ConnectionString="<%$ ConnectionStrings:WroxUnitedMasterString %>" 
       
        InsertCommand="INSERT INTO [Gallery] ([FixtureID], [UploadedByMemberName], [Notes], [PictureURL]) VALUES (@FixtureID, @UploadedByMemberName, @Notes, @PictureURL)" 
        SelectCommand="SELECT * FROM [Gallery]" 
        >
        <InsertParameters>
            <asp:ControlParameter Name="FixtureID" ControlID= "ListBox1" Type="Int32" />
            <asp:ControlParameter Name="UploadedByMemberName" ControlID="TextBoxMemberName" Type="String" />
            <asp:ControlParameter Name="Notes" ControlID="TextBoxNotes" Type="String" />
            <asp:ControlParameter Name="PictureURL" ControlID="FileUpload1" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Upload" />
    <br />
</asp:Content>

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;


public partial class GalleryUpload : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string ImagesFolder = "MatchImages";
        string savePath;
        string saveFile;

        if (FileUpload1.HasFile)
        {
            try
            {
                //perform the upload
                savePath = Path.Combine(Request.PhysicalApplicationPath, ImagesFolder);
                saveFile = Path.Combine(savePath, FileUpload1.FileName);
                FileUpload1.SaveAs(saveFile);
                //Display status of success
                //FileUploadReport.Text = "Your file was uploaded successfully.";
            }
            catch (Exception exUpload)
            {
                //display status of error
                //FileUploadReport.Text = exUpload.Message;
            }
            SqlDataSourceCreateGalleryRecord.Insert();
        }
        else
        {
           
            //FileUploadReport.Text = "You did not specify a file to upload.";
        }
    }
}

variableToCallTheInsertOperation = Convert.Int32(SqlDataSourceCreateGalleryRecord);