Add aspnet_users UserName value into my own table

Question

I would like to insert UserName from aspnet_users into my own table called Members. My sqldatasource looks like as follows. At the end in the InsertParameters I have added ProfileParameter but its not working. Just to get the values going, I have hardcoded 'testhere' value in the insertcommand. My SQLDatasource looks as follows.

Please help !!!

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    OnInserted= "on_inserted"
    OnUpdated = "on_updated"

        ConnectionString="<%$ ConnectionStrings:test1ConnectionString %>" 
        DeleteCommand="DELETE FROM [member] WHERE [id] = @id" 
        InsertCommand="INSERT INTO [member] ([firstname], [lastname],[username]) VALUES (@firstname, @lastname,'testhere');
                            set @id = @@identity"  
        SelectCommand="SELECT * FROM [member] WHERE ([id] = @id)" 

        UpdateCommand="UPDATE [member] SET [firstname] = @firstname, [lastname] = @lastname WHERE [id] = @id" 
        onselecting="SqlDataSource1_Selecting">
        <SelectParameters>
            <asp:QueryStringParameter Name="id" QueryStringField="id" Type="Int32" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="id" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="firstname" Type="String" />
            <asp:Parameter Name="lastname" Type="String" />
            <asp:Parameter Name="id" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
         <asp:Parameter Name="id" Type=Int32 Direction=Output />
            <asp:Parameter Name="firstname" Type="String" />
            <asp:Parameter Name="lastname" Type="String" />
            <asp:ProfileParameter Name="username" Type=String /> 
        </InsertParameters>
    </asp:SqlDataSource>

Answer 1

Okay.. as a simple one:

• Try changing the InsertParameter (username) to be an asp:Parameter.
• Add a asp:HiddenField control with ID of username
• onpageload, set the value of the username hiddenfield to be Page.User.Identity.Name

Magic!