Modifying program

Question

Hi,

I have a found a program that meets my needs, and would like to make only slight modifications to its source code. I am new at C#, so would appreciate your advice.

The program I wish to modify is QueryBuilder100NKI and can be found at this URL:
http://www.c-sharpcorner.com//Database/QueryBuilder100NKI.asp 

Here's what I want to change:
-Instead of connecting an oracle DB....I want it to connect to an access database (the access databse is just a simple database with 1 or more tables, and is stored locally on the same machine as this program)

-Instead of displaying five records per page....I'd like it to display 50 records on the same page.

Could someone please explain how to make these changes? Thanks in advance!

Answer 1

Here is my idea on your project

Answer 2

There is a problem in your code - but it will take some time to work it out.
Soon as I get somewhere, I'll post result

Answer 3

Thank you for that code to compare if the ID is already in the array list.  They should not both go straight to the last name the lastStudent button should go straight to the last name but as for the nextStudent button it should display a different student every time until the end of the array list.  But what I am having trouble with is that when I click the nextStudentButton I can continue to click until the end of the array not the last student.  

Answer 4

When I use either button- it moves to last name ?
As to check id try this

 public void checkId()
{
foreach (Student stu in students)
{
if (stu.IdNumber.ToString() == idAddTextBox.Text)
{
MessageBox.Show("Sorry.Student id already in use");
return;
}
}
}