Devam Ediyor

SQL Transaction Import/Export Appliaction

SQL Transaction Import/Export Application

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

Need program in VB.NET 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, using transaction sql export text file, visual studio jobs, visual c# jobs, vb .net jobs, starting with visual basic, starting with vb.net, starting with vb net, loop net, jobs vb net, jobs in vb.net, jobs in 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, find previous system transaction importer, file transaction rollback visual basic, read latest sql transaction, import export list

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

Proje NO: #117491