Quoting Post Topic Database in Visual Basic Membername   Not a member? Sign Up Free (takes 20 seconds) Password   Forgotten your password? Post Font: Verdana Arial Black Georgia Comic Sans Impact   Size: Tiny Normal Big Huge   Color: Default Dark Red Red Orange Brown Green Olive Cyan Blue Dark Blue Indigo Black [ Check Spelling ] [ Post Preview ] [ LiveTags ] Quote: from [m]The Dark Prince[/m] at 5:56 pm on June 17, 2009[quote]I am required to write a program for my end of year project and right now I am at somewhat of a writers block. I have this idea but I just can't seem to be able to put together the code for it or I am too lazy to attempt it. It is the final part of my project and once I have finished it, then my program will be considered finished. [img]img.cgi?i=35511[/img] The General idea is that when I select a supplier from the list using the combo box located in the top left hand corner, a search is performed and the boxes underneath are filled with the information from the database. But they should only be filled in this case with items and only 8 items at a time will need to be filled. So i need to program it in a way where it will stop after the first 8 and when the NEXT BATCH button is pressed the next 8 items from that supplier are filled in, clearing the previous set. [/quote] FAQ Keyword Search: Post Options Favorites Manager Notify me of new replies to this topic by email Notify me of new replies to this topic by private message Original Post The Dark Prince Posted at 5:56 pm on June 17, 2009 I am required to write a program for my end of year project and right now I am at somewhat of a writers block. I have this idea but I just can't seem to be able to put together the code for it or I am too lazy to attempt it. It is the final part of my project and once I have finished it, then my program will be considered finished. The General idea is that when I select a supplier from the list using the combo box located in the top left hand corner, a search is performed and the boxes underneath are filled with the information from the database. But they should only be filled in this case with items and only 8 items at a time will need to be filled. So i need to program it in a way where it will stop after the first 8 and when the NEXT BATCH button is pressed the next 8 items from that supplier are filled in, clearing the previous set.

Replies The Dark Prince Posted at 3:23 am on June 18, 2009 For anyone interested, I took the lazy way out. I just used the Data Control and the Data grid along with a combo box and a SQL statement and achieved the goal. JamesBrauman Posted at 6:05 pm on June 17, 2009 Okay. Think about it this way - each 'batch' is a different page. So have a variable to hold the page number, you'll want to initally set it to zero. Each time the 'next batch' button is pressed you'll want to increase this number. I'm not sure how you are accessing the database, but by having this variable it is easy to get each 'batch'. What you need is to be able to select which item numbers you want to get out of your database. Normally (with SQL for example), you tell the database the record to start at, and the record to end at, and it selects all the records between those two (including the start and end.) Now you know you only want 8 items per page. So the difference between each start and end number needs to be 8. So if you're 'starting number' was 0, and your 'end number' was 8, it would select records 0-8. So you'll need two more variables, lowerLimit and upperLimit. Whenever the next batch button is pressed, you need to: - Increase the 'batchNumber' by one. - Make 'lowerLimit' equal to batchNumber * 8. - Make 'upperLimit' equal to (batchNumber + 1) * 8. Then you can just do something like this (this is SQL): SELECT * FROM your_table LIMIT lowerLimit, upperLimit. Edit: Similarly, for previous batch, all you need to do is recude 'batchNumber' by one, and then evaluate lowerLimit and upperLimit again. I hope this has helped. The Dark Prince Posted at 5:59 pm on June 17, 2009 Quote: from Mods1Blow2Me3Daily at 8:57 pm on June 17, 2009 are you using j-creator? Lemme see, Topic Title: Database in Visual Basic, so taking a wild guess based on the topic title, I'll just assume that I am using Visual Basic. And I did not mention anything about it being a java program either. Mods1Blow2Me3Daily Posted at 5:57 pm on June 17, 2009 are you using j-creator? All 4 previous replies displayed.