SqlDataSource Insert Query Is Not Working Properly

 Hello,

I have a SqlDataSource that is not doing my inserts properly. even if the user is logged in (UserName!=""), it always inserts a null in the UserName field.


SqlDataSource:

         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:imLLConnectionString %>"
            DeleteCommand="DELETE FROM [tblDiaryEntries] WHERE [DiaryEntryID] = @DiaryEntryID"
            InsertCommand="INSERT INTO [tblDiaryEntries] ([DiaryEntry], [Subject], [EntryDate], [UserName]) VALUES (@DiaryEntry, @Subject, @EntryDate, @UserName)"
            SelectCommand="SELECT [DiaryEntry], [Subject], [EntryDate], [DiaryEntryID], [UserName] FROM [tblDiaryEntries] WHERE [UserName]=@UserName"
            UpdateCommand="UPDATE [tblDiaryEntries] SET [DiaryEntry] = @DiaryEntry, [Subject] = @Subject, [EntryDate] = @EntryDate WHERE [DiaryEntryID] = @DiaryEntryID">
            <DeleteParameters>
                <asp:Parameter Name="DiaryEntryID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="DiaryEntry" Type="String" />
                <asp:Parameter Name="Subject" Type="String" />
                <asp:Parameter Name="EntryDate" Type="String" />
                <asp:Parameter Name="UserName" Type="String"/>
                <asp:Parameter Name="DiaryEntryID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="DiaryEntry" Type="String" />
                <asp:Parameter Name="Subject" Type="String" />
                <asp:Parameter Name="EntryDate" Type="String" />
                <asp:Parameter Name="UserName"  Type="String"/>
            </InsertParameters>
        </asp:SqlDataSource>

 

and from code behind, i do:

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            SqlDataSource1.SelectParameters.Add("UserName", this.User.Identity.Name);
            SqlDataSource1.InsertParameters.Add("UserName", this.User.Identity.Name);
               
        }
    }

 

Any ideas/suggestions? Thanks!