Modifying program

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!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski20y ago
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.