C# Discussion Boards - CodeProject

14-Jan-21 6:40

How to change data by using a removable disk in C Sharp language

OriginalGriff14-Jan-21 7:47

14-Jan-21 7:47

You're going to have to be a lot clearer about what your problem is: we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Member 1504609314-Jan-21 9:11

14-Jan-21 9:11

I have a database designed in C Sharp, and I have to modify this data via the Internet remotely. I want a way to modify the data by means of a removable disk so that the user takes the disk and inserted it into his device and then the modification is done

OriginalGriff14-Jan-21 9:21

14-Jan-21 9:21

You can't do that automatically anymore - at least not without getting the user to change his settings, and that dangerous: Using AutoPlay and AutoRun in Windows 10 (Article from SamLogic)[^]
It's dangerous because it means any executable disk that's inserted will autorun, and it was disabled because of virus / trojan activity using it. Certainly, I wouldn't enable it on my systems!

So you would have to run an app on the client computer that either processes the data, or which detects a removable disk being inserted - this may help: Detecting USB Drive Removal in a C# Program[^]

Member 1504609314-Jan-21 9:36

14-Jan-21 9:36

You don't understand what I mean yet

I have a database of 500 employees
And I have another device with the same employee database that I have. I want in the event that I change the employee's data, then transfer the update to the disk and give it to the user to get the update on the data of his employees

OriginalGriff14-Jan-21 9:41

14-Jan-21 9:41

So what part of that do you need help with?

Member 1504609314-Jan-21 9:48

14-Jan-21 9:48

I want to update the data via the removable disk

OriginalGriff14-Jan-21 11:10

14-Jan-21 11:10

And what part of that is proving difficult?

Seriously, I can't read your mind - so repeating the lack of information you didn't give us in the first place doesn't help anybody!

Member 1504609315-Jan-21 1:26

15-Jan-21 1:26

La base de données est dans mon appareil et je souhaite apporter des modifications au niveau de la base de données client à partir de mon appareil car je suis le seul autorisé à apporter des modifications aux données car je suis l'administrateur

Google Tranlate:
The database is in my device and I want to make changes at the customer database level from my device because I am the only one allowed to make changes to the data because I am the administrator

modified 15-Jan-21 7:32am.

CHill6015-Jan-21 1:32

CHill60

15-Jan-21 1:32

Veuillez utiliser l'anglais ici. J'ai traduit votre message pour vous cette fois

OriginalGriff15-Jan-21 1:38

15-Jan-21 1:38

For the third time:

Quote:
And what part of that is proving difficult?

What have you tried?
Where are you stuck?
What help do you need?

I'm not trying to be difficult, but you aren't telling us anything!

Quote:
Et quelle partie de cela s'avère difficile?

Qu'avez-vous essayé?
Où es-tu coincé?
Quelle aide avez-vous besoin?

Je n'essaye pas d'être difficile, mais tu ne nous dis rien!

Mycroft Holmes14-Jan-21 11:04

Mycroft Holmes

14-Jan-21 11:04

As OG said this cannot be done automatically. There should be an application that uses the database, you need to write an update process in that application to read the data from the removable drive and update the database.

In other words YOUR USER has to initiate the process somehow and you need to write the process.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Member 1504609315-Jan-21 5:45

15-Jan-21 5:45

I want an example in C Sharp

Dave Kreskowiak15-Jan-21 6:28

Dave Kreskowiak

15-Jan-21 6:28

You keep saying "I want to update the data via the removable disk" but that doesn't make any sense because the disk itself cannot modify the data as it's not code that runs.

You can store an app on the disk and the user can launch that app, modifying a database that is also stored on that disk, but that's a severe security risk to your database and the people you describe in that database.

What you're doing seems like a really bad idea.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Ralf Meier15-Jan-21 9:05

Ralf Meier

15-Jan-21 9:05

As the OP allready wrote : he wants to have a sample code.
This answers the unanswered question from Griff too.
The OP has no idea and now he wants to have a (more or less) complete solution.

A long long time ago (long before Networks are usual) I made a similar solution for a friend of mine. Perhapas this is an idea for the OP :
I store each data with a Timestamp, which represents the last modification, on the disk. The storing of the complete data was an action which was selected by the user.
The receiving PC could import the data and replaces each datablock in it's own "collection" with the data from the disk, if it's timestamp is newer.
If the data isn't existing on the PC it was added.
Finally the complete data (with the new timestamp) is written back to the disk so that the 2nd PC could import it. This action was also necessary.
This is the only way (for me) to do something like this if there normally is no connection between both (or more) PC's.

Richard Andrew x6418-Jan-21 11:55

Richard Andrew x64

18-Jan-21 11:55

I'll give you the exact example in C# that you want. My rates are very reasonable.

The difficult we do right away...
...the impossible takes slightly longer.