SQL菜鸟级的问题
string str_sql = "delete from news where ID = ' "+Convert.ToInt32(txt_ID.Text.Trim())+ " ' ";
提示数据类型不匹配,我觉得匹配着呀
ID是ACCESS中的长整型
[解决办法]
string str_sql = "delete from news where ID = " Convert.ToInt64(txt_ID.Text.Trim())+ " ' ";
[解决办法]
string str_sql = "delete from news where ID = "+ Convert.ToInt64(txt_ID.Text.Trim);
[解决办法]
你ID是整型, ' " " '这个是字符型了呀
[解决办法]
liyanli2007()
正解啊
不用单引号的
[解决办法]
学习...
[解决办法]
string str_sql = "delete from news where ID = "+Convert.ToInt32(txt_ID.Text.Trim());
[解决办法]
string str_sql = "delete from news where ID = "+ Convert.ToInt64(txt_ID.Text.Trim);
[解决办法]
在Access里不加单引号,在SQL里int的可以加单引号
[解决办法]
怎么不给我加分呀