1. Create (learn) how to do database insert and update. This does NOT have anything to do with the reader data. It is just basic knowledge.
2. Use 1 to create an API that creates/updates RFID data. This has NOTHING to do with getting the data.
3. Write code to read from a SINGLE reader and then call the API in 2.
4. Create (learn) two threads. Each thread calls 3. Maybe with a delay or maybe not. Depends on how you tell if the reader has data or not.
first of all, thank u for ur reply.
1- somebody told me that there is library codes already created to do this purpose, is that true? and where can i find them?
2- i'm not a programmer, unfortunately, so that i really need more explanation.
3- if u don't mind we could communicate on skype or teamviwer,..etc, to discuss these steps.
4- if u mind, can u provide me the best and easiedt references on tutorials?
5- if u know someone is ready to solve my problem and programs it i'll be really thankful.
and i have written the code in c# and it works and reads the tags. each tag
represents a device.
This statement would seem to be at odds with your other post that says you are not a programmer.
I really need help ASAP.
Per your other comment that you want to hire someone.
You might want to look to a employment agency and an employment lawyer. Both should have experience with software.
The first provides candidates. The second insures that what you get is what you paid for.
1. You should improve your requirements.
2. Make sure that the lawyer knows that you want to retain ownership of the code.
3. Make sure that the lawyer knows that you want to insure the product works. To that end your requirements will need to state HOW you would determine that.
4. Make sure that hte lawyer knows that will want to provide bug fixes to the code. Or not if you want to try to do it yourself.
Then you just need to find a candidate you like, get them to sign a contract (the lawyer approved one) and then get out your check book.
You probably should pick a local candidate because then you can sue them if they fail to deliver (breach of contract.) Doing that is generally easier if it is local although there are some localities where it is better for you (contractor) than for the (contractee) which is something else you should ask the lawyer.
First and foremost, you do NOT use string concatentation to built a query like that. Why? Just Google for "SQL Injection attack" and you'll find out. A big problem with what you've done is what happens if the user types a ' character in their password?? I guarantee that it'll break your code and give you the error that you're talking about.
Then you can Google for "C# SQL Parameterized queries" to find out how to do it correcly. This also has the benefit of making your code easier to debug and maintain.
Next, why are you calling .ToString() on a string?? The Text property always returns a string, so there's no need to call .ToString() on it!
And finally, with an UPDATE statement as yours, you would normally use ExecuteScalar, no ExecuteReader, to launch it.
Try reading the documentation on the Win32_Process class, Create method.Create method[^] for the return values.
If you're trying to run a process remotely that puts up a user interface, like Notepad for example, for the logged in user to see, you can't. It's a HUGE security risk, so WMI won't let you do it.
You CAN however run an executable that does NOT show any user interface, like a Console application.
You can launch the .EXE with the file being on your machine but ONLY if the .EXE file resides in a network share ono your machine. If you don't understand Windows Networking, just copy the .EXE file to the target machine and launch it from there. It's much simpler to do.