Quening the Data

[SALIH]

Dear All
I am getting the data from the RS232 Port to my pc where my program sits
and I am storing this data to another SQL Server PC.
If the connection loss from my PC to SQL Server PC I want to store this data
in my PC and try to send it again every often.
when i send this stored data to SQL Server I want to delete it.
Please could you tell me how could i do this
any examples or ideas will be very appreciated.I am new learning of .NET
Many Thanks in advance
salih

[Zealot]

Well, in my last project in VB 6 I had to download via-FTP an Access DB into my local PC. Since Internet connections are sensible to failures I made a backup of the DB in my PC and only if the download went without failure I deleted the old file and renamed the file I just downloaded as the old file.
It might not be the best process but it worked.

I used the Inet component and the FileSystem object to do this. Don't know if VB.Net still has Inet.