天刀画卷芳华谷:还是asp.net的SQL语言问题阿
来源:百度文库 编辑:神马品牌网 时间:2024/04/28 05:05:27
还是不行啊……我都要崩溃了
OleDbCommand cmd2;
cmd2 = new OleDbCommand("Insert into userinform (userid, password, usertype, useremail, useradd, usertel)" + " values ('" + UserName.Text + "','" + Password.Text + "',0,'" + Email.Text + "','" + Address.Text + "','" + phonenum.Text + "')", dbconn);
cmd2.ExecuteNonQuery();
到底哪里错了阿
一直提示语法错误
指点的大侠们请说的清楚一点点阿
声明:除了usertype,其他全部是字符类型
还是不行啊 ...
OleDbCommand cmd2;
cmd2 = new OleDbCommand("Insert into userinform (userid, password, usertype, useremail, useradd, usertel)" + " values ('" + UserName.Text + "','" + Password.Text + "',0,'" + Email.Text + "','" + Address.Text + "','" + phonenum.Text + "')", dbconn);
cmd2.ExecuteNonQuery();
到底哪里错了阿
一直提示语法错误
指点的大侠们请说的清楚一点点阿
声明:除了usertype,其他全部是字符类型
还是不行啊 ...
("Insert into userinform (userid, password, usertype, useremail, useradd, usertel) values ('" + UserName.Text + "','" + Password.Text + "',0,'" + Email.Text + "','" + Address.Text + "','" + phonenum.Text + "')"
" + " values
这是啥意思啊?把values前面的"+"都去掉