问题描述
大家好吧
我有2个问题,没有人可以帮助我,请帮助我
第一个问题:我想从Access数据库中删除一条记录,该记录的记录为"ID_Per"字段,该字段类型为Number,我编写此代码:
代码:
Hi everybuddy
i have 2 problem , and nobody can help me , please help me
First Problem : I want Delete a Record From Access Data base with its Record "ID_Per" Field , That Field Type is Number , i Write this Code :
Code:
com.commandtext = "Delete * From Personels Where ID_PER = '"& txt_ID_per.text &"' "
com.ExecuteNonQuery()
错误msg:CIRITIA中的数据类型不匹配
-当我将该字段类型更改为文本时,此问题可以,但是我需要数字类型,请帮帮我!
'''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''
第二个问题:
我有:
ERROR msg : DATA TYPE MISMATCH IN CIRITIA
- When i change that field type to text this problem is OK , but i need Number Type , Please help me!
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Second Problem :
i have :
Dim tt as byte()
tt在自己中保存了图片位,我想将其发送到Access数据库,我可以使用以下代码进行操作:
代码:
tt saved a picture bits in yourself , i want send it to data base Access , i can do it with this code :
code:
com.commandtext = "Insert into KK VALUES(@pic_bit)"
com.parameters.AddWithValue("pic_bit" , tt)
com.ExecuteNonQuery()
但我想用这种方式发送:
代码:
But i want Send with this Way :
Code:
com.commandtext = "Insert into KK (pic_bit) VALUES ('"& tt &"')"
com.ExecuteNonQuery()
我做不到,我看到了SOme错误,请说出这段代码是什么错误或说我如何使用DATA COMMAND参数更新和删除方式
非常感谢
Pleeeeeease回复
i cant Do it , i see SOme Errors , Please Say me whats this code Error OR say me How can i UPDATE and Delete with DATA COMMAND PARAMETERS Way
Thank you Very much
Pleeeeeease Reply
推荐答案
com.commandtext = "Delete * From Personels Where ID_PER = "& Convert.ToInt32(txt_ID_per.text) ;
com.ExecuteNonQuery()
这篇关于插入删除和更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!