Last post Jun 08, 2010 12:46 PM by clausont
Jun 08, 2010 08:02 AM|clausont|LINK
I'm new here and really, new to asp.net except the very basic things.
I am trying to create a very simple (I think simple) web form with five textboxes and three dropdown boxes and one submit button. The user enters information in the textbox fields and selects from the dropdown lists (which are populated from the database),
hits enter and the database runs the query and returns information on a separate page (or can it return to the same page via panels?) The original page returned to a separate page using server transfer.
I have this page already existing in asp but feel that it would be much better served in asp.net.
Can someone point me to a post where I would guess this has been answered many times?
How do I submit the new data to the database, update the records and return the query?
I seem to be stuck on the button event as much as anything.
Thanks in advance
Jun 08, 2010 08:31 AM|karthicks|LINK
Refer : http://msdn.microsoft.com/en-us/library/ms971485.aspx
Jun 08, 2010 12:46 PM|clausont|LINK
Thanks for the links. One of the links has information that helps with what I am trying to do:
Using their example, I can now at least indert into the access database. I have one row that I need to update rather than insert into but am having trouble with my sql statement. I seem to continue to get an error that says "LET and SET" ar no longer used.
I have no problem displaying data from the database in Gridview, but I need to update before I return results.
I can set up an update statement in the query builder in VWD2008 Express, but then I have no idea how to use a submit button.
As you see, I have little bits and peices, but need to figure out how to put it all together.