Last post Mar 18, 2013 10:05 PM by Chen Yu - MSFT
Mar 11, 2013 03:45 PM|Eng.almasrouhi|LINK
i have 2 RFID readers that read active RFID tags ID within range, and i have written the code in c# and it works and reads the tags. each tag represents a device.
i have created a database on MS access provides information related to each tag, such as serial number, location, company,...
ISSUE: i need to insert the tag ID to the database and only update Location coloumn, AOTUMATICALLY. as long as the reader reads the tag the program has to update the location where the rest information will be as they are.
i have 2 readers (reader A & reader B) so that i have to compare the data coming from each reader in order to update the location. if reader A reads the tag ID and reader B doesn't >> location updated to Location A. while if reader B reads the tag ID and
reader A doesn't >> location updated to Location B. and if neither of 2 readers read the tag the location will be (OUTBOARD). also if the readers read the tag ID at the same time ( readers range interfere), the location will be (mutual A&B).
readers are real time working, and i need to do the updating aotumatically & continuously.
I really need help ASAP.
Mar 18, 2013 10:05 PM|Chen Yu - MSFT|LINK
Do you means you need to update the special columns in your access table? If so, you could use update Your_Table set column1 = [value1], column2 = [value],... where column = [the value you know and it's better that this value is a unique value]. You could
follow below thread to edit your update query in your C# code.
Please check: http://forums.asp.net/t/1186534.aspx/1