string str="Provider=Microsoft.Jet.OleDb.4.0;";
str += @"Data Source=D:\Kent\Pro\Website\App_Data\user.mdb";
OleDbConnection obj=new OleDbConnection(str);
obj.Open();
string sql;
sql = "insert into t_user values(select max(id)+1 from t_user,'" + txtname.Text + "','" + txtpwd1.Text + "','" + txtnick.Text + "','" + radiosex.SelectedValue + "','" + txtmail.Text + "')";
OleDbCommand cmd = new OleDbCommand(sql, obj);
cmd.ExecuteNonQuery();
obj.Close();
执行 提示sql语句有语法错误 但是需要怎么改呢
另外,ACCESS是否支付insert into select这种写法?
如果支付,
语句应该是
insert into t_user id,userid,pw select xxx from ...
如:insert into t_user(col_name1,col_name2,col_name3,...)
然后,有用到SQL取值的用小括号括起来,
如:values((select value from table_name),col_value2,col_value3,...)
最后检查一下值的类型有没有匹配
你写全一点试试