Hi all,

I'm sure this is fairly simple so please be gentle.
I'm trying to Bind the logged on user id to a new record within a database.

I have got various different controls (text, listbox etc) successfully passing through the Insert Parameters, but I can't seem to Bind the username.
I have called the username through the script below and can see it displayed in the form but how do I set the insert parameter to equal that?

<script runat="server">

MembershipUser currentUser;

public void Page_Load()
{
currentUser = Membership.GetUser();

}

</script>

Thanks for any help

I guess im a little confused at what your trying to do, as the 'connecting' happens on your insert.

basically, I do everything with parameters.
So for me:
dim myUser as string = embership.getuser()
dim SQLparams as new specialized.namevaluecollection
SQLparams.add("@userId",myUser)
SQLparams.add("@age, 30)

To execute the code, I cycle through the params and add them as sql parameters.
        For x As Integer = 0 To SQLparams.Keys.Count - 1
            Dim userParameter As New SqlClient.SqlParameter
            userParameter.ParameterName = SQLparams.Keys(x).ToString
            userParameter.Value = SQLparams.Item(x).ToString
            command.Parameters.Add(userParameter)
        Next
        command.ExecuteNonQuery()

ALWAYS use parameters if any of the data is coming from the page to prevent SQL injection attacks.

Thanks for the reply - I haven't tried it yet as I think I found the answer in topic: http://p2p.wrox.cpm/topic.asp?TOPIC_ID=40908

using

protected void ActivityEntry_Inserting(object sender, ActivityEntryInsertingEventArgs e)

{e.InputParameters["@UserName"].value = Membership.GetUser().UserName;}

and having

<asp:parameter Type="String" Name="userName" />

in the InsertParameters

My problem now is that I get a compilation error: "The type or namespace name 'ActivityEntryInsertingEventArgs' could not be found (are you missing a using directive or an assembly reference?)"

Where and how do I put the directive / assembly reference?

Sorry I'm new to a lot of this...

Lee

instead of using all that try using

user.identity.name when inserting parameters.