Devam Ediyor

SQL Transaction Import/Export Appliaction

SQL Transaction Import/Export Application

=========================================

Need program in [url removed, login to view] to do TWO jobs

Two different CSV file layouts (slightly different)

(1) Read a CSV file and Display the data in a scrollable datagrid

Having viewed the file the user will press a Button to IMPORT the data into a MSSQL an existing database table. Using INSERT INTO

Read a Text file – [url removed, login to view] which contains the last transaction number this count (SQL ID) is used and incremented as each item is incremented.

If the IMPORT is run by the user the [url removed, login to view] is updated with the latest value.

If the user cancels the program simply exists.

(2) Read a SQL table (different from above) and Display the data in a scrollable datagrid

Having viewed the file the user will loop through and press a Button to EXPORT the data into a CSV file. A file [url removed, login to view] is read to determine the starting transaction number (SQL ID)

On each pass of the loop the routine will also (in addition to wring CSV) run a command line i.e. SGI xx yy zz etc passing values from the grid.

If the EXPORT is run by the user the [url removed, login to view] is updated with the latest value.

If the user cancels the program simply exists.

=====================================================================

Database MS-SQL 2000

Visual Studio 2003

Need application with Full Source Code documented in English.

Beceriler: .NET, Visual Basic, Windows Masaüstü

Daha fazlasını görün: import transaction, sql transaction, visual studio jobs, starting visual basic, starting net, loop net, jobs import export, jobs id, e value, sql transaction import, import transaction net, sql transaction txt file, sql job write csv, csv sql import export, sql transaction number, read latest sql transaction, import export list, export transaction sql script, sql export routines, sql insert transaction number, transaction import sql, sql transaction export import, export sql csv file, importexport sql, sql transaction program

İşveren Hakkında:
( 16 değerlendirme ) Bradford, United Kingdom

Proje NO: #117491