UserName not inserting

Question

User-1938163999 posted

I have a formview that is working fine for with the exception of the username is not inserting on a new record.  The username is visible on login so I know that is working.  I'm attaching my sql code as well as the code behind as I don't know what I'm missing.

Thanks,

Leesha

 <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:Personal %>"
                                            DeleteCommand="DELETE FROM [tblPhotoOrderComments] WHERE [CommentID] = @CommentID"
                                            InsertCommand="INSERT INTO [tblPhotoOrderComments] ([Comment], [username], [CommentTimeStamp], [WeddingName]) VALUES (@Comment, @username, GetDate(), 'KaraRick')"
                                            SelectCommand="SELECT [Comment], [username], [CommentTimeStamp], [CommentID], [WeddingName] FROM [tblPhotoOrderComments]  WHERE ([Username] = @Username)" OnInserting="SqlDataSource1_Inserting"
                                            UpdateCommand="UPDATE [tblPhotoOrderComments] SET [Comment] = @Comment, [username] = @username, [CommentTimeStamp] = GetDate(), [WeddingName] = 'JoeyLee' WHERE [CommentID] = @CommentID">
                                             <SelectParameters>
                                                <asp:Parameter Name="UserName" Type="String" />
                                            </SelectParameters>
                                            <DeleteParameters>
                                                <asp:Parameter Name="CommentID" Type="Int32" />
                                            </DeleteParameters>
                                            <UpdateParameters>
                                                <asp:Parameter Name="Comment" Type="String" />
                                                <asp:Parameter Name="username" Type="String" />
                                                <asp:Parameter Name="CommentTimeStamp" Type="DateTime" />
                                                <asp:Parameter Name="WeddingName" Type="String" />
                                                <asp:Parameter Name="CommentID" Type="Int32" />
                                            </UpdateParameters>
                                            <InsertParameters>
                                                <asp:Parameter Name="Comment" Type="String" />
                                                <asp:Parameter Name="username" Type="String" />
                                                <asp:Parameter Name="CommentTimeStamp" Type="DateTime" />
                                                <asp:Parameter Name="WeddingName" Type="String" />
                                            </InsertParameters>
                                        </asp:SqlDataSource>  

CODE BEHIND - 

 Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

              SqlDataSource4.SelectParameters("UserName").DefaultValue = HttpContext.Current.User.Identity.Name
    End Sub
   
    Protected Sub SqlDataSource4_Inserting(ByVal sender As Object, ByVal e As SqlDataSourceCommandEventArgs)

        e.Command.Parameters("@UserName").Value = HttpContext.Current.User.Identity.Name

    End Sub

 

Answer 1

User187056398 posted

Case sensitive issue?

<asp:Parameter Name="username"

Should it be UserName? 

Answer 2

User-1938163999 posted

That makes perfect sense, but alas it didn't work. I'm attaching my edited code in case there was something else.

Leesha

<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:Personal %>"
                                            DeleteCommand="DELETE FROM [tblPhotoOrderComments] WHERE [CommentID] = @CommentID"
                                            InsertCommand="INSERT INTO [tblPhotoOrderComments] ([Comment], [username], [CommentTimeStamp], [WeddingName]) VALUES (@Comment, @UserName, GetDate(), 'KaraRick')"
                                            SelectCommand="SELECT [Comment], [username], [CommentTimeStamp], [CommentID], [WeddingName] FROM [tblPhotoOrderComments]  WHERE ([Username] = @Username)" OnInserting="SqlDataSource1_Inserting"
                                            UpdateCommand="UPDATE [tblPhotoOrderComments] SET [Comment] = @Comment, [username] = @username, [CommentTimeStamp] = GetDate(), [WeddingName] = 'JoeyLee' WHERE [CommentID] = @CommentID">
                                             <SelectParameters>
                                                <asp:Parameter Name="UserName" Type="String" />
                                            </SelectParameters>
                                            <DeleteParameters>
                                                <asp:Parameter Name="CommentID" Type="Int32" />
                                            </DeleteParameters>
                                            <UpdateParameters>
                                                <asp:Parameter Name="Comment" Type="String" />
                                                <asp:Parameter Name="username" Type="String" />
                                                <asp:Parameter Name="CommentTimeStamp" Type="DateTime" />
                                                <asp:Parameter Name="WeddingName" Type="String" />
                                                <asp:Parameter Name="CommentID" Type="Int32" />
                                            </UpdateParameters>
                                            <InsertParameters>
                                                <asp:Parameter Name="Comment" Type="String" />
                                                <asp:Parameter Name="UserName" Type="String" />
                                                <asp:Parameter Name="CommentTimeStamp" Type="DateTime" />
                                                <asp:Parameter Name="WeddingName" Type="String" />
                                            </InsertParameters>
                                        </asp:SqlDataSource>  

 

Answer 3

User187056398 posted

Instead of this:
  e.Command.Parameters("@UserName").Value = HttpContext.Current.User.Identity.Name  

You could try:
   SqlDataSource4.InsertParameters("@UserName").DefaultValue = HttpContext.Current.User.Identity.Name  

(I don't have VS available right now to test these suggestions)

You should also check the value of HttpContext.Current.User.Identity.Name

Answer 4

User-1938163999 posted

Hi,

That didn't do it either. Re checking the value ot HttpContext.Current.User.Identity.Name - I'm not sure how to do t hat except to verify that the user name is present in the LoginView Control and saves on other pages in the insert command.

So confused,

Leesha 

Answer 5

User187056398 posted

checking the value ot HttpContext.Current.User.Identity.Name - I'm not sure how to do t hat

 

Put a breakpoint on the line.  When the debugger hits it, use the watch window to examine the variable.

Answer 6

User626880745 posted