EDN Admin
Well-known member
Is there a better way to create and edit a database programatically in C#.
Im trying to convert a csv file to a database file then add records and fields progromatically in C#.
Then we will have a seperate program to edit/maintain the data base.
The data starts as as a Quatropro spread sheet converted to csv then sucked into my app as a dataset then Im trying to dump it into a new data base.
Im not good with databases...yet.
I think it may be in the database we created to start with.
We created a empty Paradox database with just the 1st row of column headers and one row of dummy data just to get it into the C# form app with a dataset, So Im trying to open this so I can dump data into it from C#.
What are the limits? do I have to have at least one row of valid data strings to start? Is that causing my error?
Heres the connection string:
Driver={Microsoft Paradox Driver (*.db )};collatingsequence=ASCII;dbq=C
EV_TESTACESSIOCSVIMPORTCSV_IMPORT_EXPORTDATAPRODUCTINFONEW;defaultdir=CEV_TESTACESSIOCSVIMPORTCSV_IMPORT_EXPORTDATAPRODUCTINFONEW;driverid=538;fil=Paradox 5.X;filedsn=C
rogram
FilesCommon FilesODBCData SourcesACCESProductInfo.dsn;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;paradoxnetpath=C:WINDOWSsystem32;paradoxnetstyle=4.x;paradoxusername=admin;safetransactions=0;threads=3;uid=admin;usercommitsync=Yes
Heres a clip of the test data in second row from delphi database desktop.
First row is string headers ie part numbers, costs, names, dates etc.
<img alt="
opps didnt paste its a 23 column by 2 rows right now one row is headers.
Thanks all still learning here.
...hmm maybe its the connection string this one works I think the db file name is missing in broken one?
Have to look into this.
Driver={Microsoft Paradox Driver (*.db )};collatingsequence=ASCII;dbq=C:RMADATABASE;defaultdir=C:RMADATABASE;driverid=538;fil=Paradox 5.X;<br/>
filedsn=C:RMAdatabaseRma.DB.dsn;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;paradoxnetpath=C:WINDOWSsystem32;paradoxnetstyle=4.x;paradoxusername=admin;safetransactions=0;threads=3;uid=admin;usercommitsync=Yes<br/>
<br/>
<
Thanks, Richard<br/>
<br/>
View the full article
Im trying to convert a csv file to a database file then add records and fields progromatically in C#.
Then we will have a seperate program to edit/maintain the data base.
The data starts as as a Quatropro spread sheet converted to csv then sucked into my app as a dataset then Im trying to dump it into a new data base.
Im not good with databases...yet.
I think it may be in the database we created to start with.
We created a empty Paradox database with just the 1st row of column headers and one row of dummy data just to get it into the C# form app with a dataset, So Im trying to open this so I can dump data into it from C#.
What are the limits? do I have to have at least one row of valid data strings to start? Is that causing my error?
Heres the connection string:
Driver={Microsoft Paradox Driver (*.db )};collatingsequence=ASCII;dbq=C
EV_TESTACESSIOCSVIMPORTCSV_IMPORT_EXPORTDATAPRODUCTINFONEW;defaultdir=CEV_TESTACESSIOCSVIMPORTCSV_IMPORT_EXPORTDATAPRODUCTINFONEW;driverid=538;fil=Paradox 5.X;filedsn=CrogramFilesCommon FilesODBCData SourcesACCESProductInfo.dsn;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;paradoxnetpath=C:WINDOWSsystem32;paradoxnetstyle=4.x;paradoxusername=admin;safetransactions=0;threads=3;uid=admin;usercommitsync=Yes
Heres a clip of the test data in second row from delphi database desktop.
First row is string headers ie part numbers, costs, names, dates etc.
<img alt="
opps didnt paste its a 23 column by 2 rows right now one row is headers.
Thanks all still learning here.
...hmm maybe its the connection string this one works I think the db file name is missing in broken one?
Have to look into this.
Driver={Microsoft Paradox Driver (*.db )};collatingsequence=ASCII;dbq=C:RMADATABASE;defaultdir=C:RMADATABASE;driverid=538;fil=Paradox 5.X;<br/>
filedsn=C:RMAdatabaseRma.DB.dsn;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;paradoxnetpath=C:WINDOWSsystem32;paradoxnetstyle=4.x;paradoxusername=admin;safetransactions=0;threads=3;uid=admin;usercommitsync=Yes<br/>
<br/>
<
Thanks, Richard<br/>
<br/>
View the full article
