I'm sure this is a basic question:
I have created a stored procedure to input a new row into a database table. The user only inputs 4 fields, and I have 3 more fields that are automatically updated.
2 of these fields are the UserID and ClientID.
UserID is a foreign key (from the aspnetdb) and ClientID is this tables primary key.
My question is:
How do I input the current UserID and the ClientID into the database automatically with the stored procedure and/or c#
I'm using C# in Visual Studio 2008 and SQL.
If I am going about this the wrong way all together, feel free to let me know.