I am sure this is a very easy question, but I just can't work it out.

The logged in user is going to create a job using the insert mode of a formview control. I need the user_id (foriegn key) field in the job table to automatically populate with the user_id of the logged in user. I can't get this to work, any ideas?

In my searching for how to do this, I have found that ms doesn't want you to use the user_id, they want you to use the loginName. In any case, I just need to add the loginName of the current user to a table when an insert is performed, here is what I have currently.

In the codebehind

   protected void FormView1_ItemInserting(Object sender, System.Web.UI.WebControls.FormViewInsertEventArgs e)
   {
        e.Values["CustLogin"] = User.Identity.Name;
   }

but this isn't working.
I don't know if there is a better way to do this, perhaps without using the codebehind, but any help would be appreciated.

During either The formview's ItemInserting or ItemInserted event, do the following:
1. Create a class in the App_Code folder that would do your database operation. The class can receive the User.Identity.Name or whatever you want to store as a parameter.
2. Use this parameter in your Sql statement. e.g "INSERT INTO User (loginName) VALUES('" + nameParameter + "');";
That's just about it, or at least that's how I do my simultaneous data operations on databases.


Live in fragments no longer. Only connect.

That worked, thanks.