Last post Feb 22, 2011 10:18 AM by rodeobum
Feb 21, 2011 10:54 PM|rodeobum|LINK
I need some help here. I have a ddl that pulls from one table and populates it into a formview. All this is working, however, there are a couple of extra texboxes that the user inputs and clicks on update link. I cannot figure out how to save from one table
to another. Could someone please help?
Feb 22, 2011 04:13 AM|amitpatel.it|LINK
Can you eloborate more with code, because as per your given explanation we are not able to figure out exact problem
Feb 22, 2011 10:18 AM|rodeobum|LINK
Sorry, I was in a rush when I posted this. As I mentioned, I have a ddl that is bound to a sqldatasource. When an user chooses a last name it populates into a formview. All this is working correctly. There are a couple of more textboxes that needs to be
filled in by the user and then they can update the form.
The form is supposed to save to a different table within the same db. I am getting no errors, however the db is not saving the post. Here is my code:
="UPDATE [table1] SET [LastName] = (SELECT [SIR_NAME] FROM [table2] WHERE KeyID=@KeyID), [FirstName] = (SELECT [FIRST_NAME] FROM [table2] WHERE KeyID=@KeyID), [Spouse] = (SELECT [SPOUSE]
FROM [table2] WHERE KeyID=@KeyID), Event=@Event, EventDate=@EventDate">