Issue assigning a session variable to a sqldatasource
Posted on 2007-12-03
I have a sqldatasource that is running an update statement. The update statment calls a sproc that updates the table. I have a 'LastModifiedBy' column in the table. I set a session variable (userid) to what I want to go into the this column in the page_load event to make sure it's being set. I setup the sqldatasource's parameters to use that session variable to send to the proc to populate the 'LastModifiedBy' column but it never gets sent. If I hardcode the variable in the proc, everything works fine.