Comparing received data with data in databse

ville valo

Hello..

I'm a beginner in C#.Net programming.
I'm working on RFID related project.

The RFID reader connected to PC serial port and I have done the terminal interface using C#.Net.
I would like to know how to compare the received ID in the serial port buffer with the ID I've saved in MS Access database?

What i'm trying to do is when the ID received, then it will be compared with a bunch of ID saved in the database, then the Richtextbox will display the details (saved in the database) of the matched ID.

Thanks ^^

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
That we trying to say in all above post. Call the DB table on TextBox TextChanged event.
Good to hear you got the solution.
ville valo15y ago
hello guys..

sorry for being inactive for awhile..
after working for hours on my program I slowly figured it out myself lolx
it was simple actually..
just take the received data and use search operation on the database..

anyway Thanks for your help
i really appreciate it ^^
Suthish Nair15y ago
ville,
So you meant to say how to pass the value to DB and compare, please correct me?
Sam Hobbs15y ago
I have tried to help you. Now you must do something; you need to learn about SQL and what we mean by "SQL query".
ville valo15y ago
what i'm trying to say is when i touch the tag nearby the scanner, the ID successfully displayed on the richtextbox of the interface.
My aim is when the tag scanned, the ID then compared to my MS Access database 1st ( the database contains ID holder name and their ID). Then if the ID matches, the name of the ID holder will be displayed on the richtextbox. If the ID didn't matches, it will display the ID instead of name on the richtextbox. My problem is to compare the ID received with the ID in the database.

Hope you're clear with my explaination and willing to help me =p
Sam Hobbs15y ago
Most databases use SQL. If you are unfamiliar with SQL then you need to learn about it. A select query is a type of SQL request.

If you are familiar with Access, then a select query in Access can also exist as SQL. You can create a select query in Access and then switch to SQL view to see the SQL. It will really help people to help you if you are familiar with SQL.
knights15y ago
Can you tell when you say you can read ID in buffer ? Do you meant to say that you can read it a variable that your C#.net Interface application has ? Or you are referring to something else.

Suppose your varible name is
string scannedRFID = "Some RFID which you scanned";

After that you can use ADO.Net to execute the query , get the details and process it further as per your requirements.

For an Ado.Net review, take a look at the following.I hope that will help, otherwise post it back and we will discuss further.Thanks
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson02.aspx
ville valo15y ago
Yes, i'm able to read the ID received in the buffer.
Can you explain a little bit on "run a select query returning the rest of the details against the id" ?
I really have no idea how to compare the received ID with the IDs in the database.

By now, i have accomplished reading the ID in the buffer and also open the database oledb connection on the C# application.

Thanks for your help ^^
knights15y ago
Based on what information you provided.I am assuming that you are able to read the ID in a variale in your C#.net interface application.
After that you can utilize ADO.Net(if familiar) to connect to Access and run a select query returning the rest of the details against the id which you have received in the buffer and you can display the result in the rich text box.Let us know if thats sounds workable for you or else we are here to suggest you if you can provide more information.Thanks