string str = "insert into member (username,password,email ) values('" + me.Username + "','" + me.Password + "','" + me.Email + "')";我写的插入语句在输入数据调试的时候,在cmdText里已经可以看见了:"insert into member (username,password,email ) values('t152','0806001','[email protected]')",但是还是说我insert语句语法有错误。我用access数据库
这是方法:
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, bool identity, params OleDbParameter[] cmdParms)
{
OleDbCommand cmd = new OleDbCommand(); using (OleDbConnection conn = new OleDbConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear(); if (identity)
{
cmd.CommandText = "SELECT @@IDENTITY";
object obj = cmd.ExecuteScalar();
if (obj is DBNull) return 0;
else return Convert.ToInt32(obj);
} conn.Dispose();
return val;
}
}有大神解释下谢谢了
这是方法:
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, bool identity, params OleDbParameter[] cmdParms)
{
OleDbCommand cmd = new OleDbCommand(); using (OleDbConnection conn = new OleDbConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear(); if (identity)
{
cmd.CommandText = "SELECT @@IDENTITY";
object obj = cmd.ExecuteScalar();
if (obj is DBNull) return 0;
else return Convert.ToInt32(obj);
} conn.Dispose();
return val;
}
}有大神解释下谢谢了
cmdType.text