如何插入RFID数据以访问数据库? [英] how to insert RFID datas to access database?

问题描述

我尝试自己做某事..©从RFID接收数据，如

v

Hi i try to something myself .. İ receive data from RFID like

v

0C:00:9F:A0:A3
0C:00:9F:A0:A3
0C:00:9F:A0:A3
0C:00:9F:A0:A3
0C:00:9F:A0:A3

İ尝试用c Sharp写..
但我需要将这些插入到我的数据库麦克风中.官方访问我有一个表，表名是TP，列名是G_P，我想插入到G_P

喜欢

G_P
--------------
0C:00:9F:A0:A3
--------------

我必须走哪条路?

İ try to write with c sharp ..
but i need to insert these to my database mic. offi. access i have a table, table name is TP and colum name is G_P i want to insert to G_P

like

G_P
--------------
0C:00:9F:A0:A3
--------------

which way i have to go ?
any idea please?

推荐答案

假设您已经连接到数据库，请使用以下SQL命令字符串:

Assuming you have a connection to your database, use the following SQL Command string:

"INSERT INTO TB (G_P) VALUES('" + "OC:OO:9F:A0:A3" + "')"

通常，我还建议您使用参数化查询，但首先使它起作用！

Normally, I would also recommend that you use a parametrized query, but get it working first!

这篇关于如何插入RFID数据以访问数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！