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.
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.
None
0 Points
1 Post
updating MS access database using c#.net
Mar 11, 2013 03:45 PM|Eng.almasrouhi|LINK
hi all
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.
All-Star
21620 Points
2496 Posts
Re: updating MS access database using c#.net
Mar 18, 2013 10:05 PM|Chen Yu - MSFT|LINK
Hi,
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
Thanks.
Feedback to us