昨天弄了一晚上还没搞顶的sql语句,请求帮助
下面是我插入到access数据表的一个类
public string AddNew()
{
string sResult="";
string strSql="";
strSql="select * from UM_C_AdminUser where AdminUserName='"+sAdminUserName+"'";
OleDbCommand sqlCmd=new OleDbCommand(strSql,mConnetion);
OleDbDataReader sqlRs=sqlCmd.ExecuteReader();
if (sqlRs.HasRows)
{
sqlRs.Close();
sResult="此用户名已经存在!";
}
else
{
sqlRs.Close();
strSql="insert into UM_C_AdminUser(AdminUserName,Password,Name,Duty,Department,JoinCompanyTime,Email,Mobile,Telephone,Education,Resume,Status)"+
"Values('"+sAdminUserName+"','"+sPassword+"','"+sName+"','"+sDuty+"','"+sDepartment+"','"+sJoinCompanyTime+"','"+sEmail+"','"+sMobile+"','"+sTelephone+"','"+sEducation+"','"+sResume+"',"+iStatus+")";
sqlCmd=new OleDbCommand(strSql,mConnetion);
}
try
{
sqlCmd.ExecuteNonQuery();
}
catch(Exception e)
{
sResult= e.Message;
}
return sResult;
}
}
插入的时候老提示插入的语句有错误,我打印出strSql到sql server中没问题
为什么同样的sql语句插入到access就不行,我改如何改