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

1. Modify Your connection string:

string connection = "Provider=MSDAORA;FileDSN="+t1.Text+";UID="+t2.Text+";PWD="+t3.Text+";SID="+ t4.Text+"";

from MSDAORA to proper provider (by ODBC). Connection strings are described at www.connectionstrings.com

2. Find all variables:

int upperlimit=5;
int increment=5;

and modify 5 to 50. It will be working slower. Not tested.