Comparing received data with data in databse

Question

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 ^^

Suthish Nair · Answer

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 valo · Answer

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 Nair · Answer

ville So you meant to say how to pass the value to DB and compare please correct me?

Sam Hobbs · Answer

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 valo · Answer

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 Hobbs · Answer

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.

knights · Answer

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 valo · Answer

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 ^^

knights · Answer

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