Scooter Posted March 2, 2004 Posted March 2, 2004 I have created a simple order form on our intranet for our salespeople consisting of textboxes, checkboxes, and some dropdown boxes. Is there a way to take the information they enter and select and save it so that they may come back to it at a later date and make revisions without having to redo a whole new form. I'm fairly new at Visual Basic programming and ASP.net. Thanks. Quote Whenever, wherever, whatever
kahlua001 Posted March 2, 2004 Posted March 2, 2004 Save the info into a database and retrieve it later Quote
Moderators Robby Posted March 2, 2004 Moderators Posted March 2, 2004 or an XML file Quote Visit...Bassic Software
Scooter Posted March 2, 2004 Author Posted March 2, 2004 How would i do that? Quote Whenever, wherever, whatever
Moderators Robby Posted March 3, 2004 Moderators Posted March 3, 2004 http://www.w3schools.com/xml is a good place to start for the fundementals of XML Quote Visit...Bassic Software
Scooter Posted March 16, 2004 Author Posted March 16, 2004 how would i save this to a database? Would I need to create a db with the same info or what? Quote Whenever, wherever, whatever
BradleyT Posted March 16, 2004 Posted March 16, 2004 Yes your database table would have to have the same fields that you want to be saved and retrieved. Quote
Scooter Posted March 16, 2004 Author Posted March 16, 2004 I've tried this before and for some reason whenever I try to link any info from a db to my web page I get an error. I have the oledbadapter and connections setup and everything. Do I need to save the db to the server folder in order to make it work? Quote Whenever, wherever, whatever
Moderators Robby Posted March 16, 2004 Moderators Posted March 16, 2004 Scooter, we need more details on what you want do and the steps you took to acheive this. Quote Visit...Bassic Software
Scooter Posted March 17, 2004 Author Posted March 17, 2004 For one of my forms, I have a dropdown box with some tax codes in it. Next to it I have an empty textbox. What I want to do is to take whatever taxcode is chosen and put the corresponding tax rate in the textbox. I have the tax code and rates in a seperate database(Access).(Easier to change rates in a database since they change often.) I may be doing it wrong but here's what I'm doing: First I connect to the database in Server Explorer, then I select a provider(Jet 4.0 OLE DB Provider), then I create a data adapter, finally I create a dataset. After that I try to use bound controls to make it all work. (I'm fairly new at this so I'm using a book to guide and help me.) I can get it to work on just a regular form but when I try to do it to a web page I run into problems. I'm not sure if I have the DB in the wrong place(does it need to be on the server?) or if I need to use a different avenue since this is asp.net. Any help or references would be appreciated. Quote Whenever, wherever, whatever
Scooter Posted March 17, 2004 Author Posted March 17, 2004 I'm sorry, I don't know where my head was at, my above reply was in answer to another question on a different post. To answer your question, basically, what I've created is an order form for our salespeople on our intranet. What it allows them to do is fill out the sheet according to what the customer requests. It works fine as is right now, but if a customer a week down the road wants to make a change on his order our salespeople have to refill out the whole sheet as opposed to changing whatever the customer wants, since the form cannot be saved. I'm not sure how to go about making this happen. (Saving information typed into textboxes, checkboxes, radiobuttonlists, and dropdownlists) Quote Whenever, wherever, whatever
Moderators Robby Posted March 17, 2004 Moderators Posted March 17, 2004 Does the entry from the sales people get save in a database? Quote Visit...Bassic Software
Scooter Posted March 17, 2004 Author Posted March 17, 2004 No, that's what I want to know how to do. Essentially that's what I would like to happen. Right now any entries they make are not saved, they just print them out before they clear the screen. I'm not sure how to go about saving the info in a database. Quote Whenever, wherever, whatever
Scooter Posted March 24, 2004 Author Posted March 24, 2004 any more thoughts out there? Quote Whenever, wherever, whatever
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.