OleDbCommand cmd1 = new OleDbCommand("INSERT INTO 入住客户(姓名,身份证,性别,入住时间,房间号,是否VIP)VALUES('" + name + "','" + num + "','" + sex + "','" + days + "','" + no + "','" + vip + "')", con);
OleDbCommand cmd2 = new OleDbCommand("UPDATE 客房 SET 入住='Y' WHERE 房间号='" + key + "'", con);
OleDbCommand cmd3 = new OleDbCommand("UPDATE 客房 SET 预定='N' WHERE 房间号='" + key + "'", con);
OleDbCommand cmd4 = new OleDbCommand("UPDATE 客房 SET 姓名='" + name + "'WHERE 房间号='" + key + "'", con);
OleDbCommand cmd5 = new OleDbCommand("UPDATE 客房 SET 身份证='" + num + "'WHERE 房间号='" + key + "'", con);
OleDbCommand cmd6 = new OleDbCommand("UPDATE 客房 SET 入住时间='" + days + " " + times + "' WHERE 房间号='" + key + "'", con);
cmd1.ExecuteNonQuery();这行提示标准表达式中数据类型不匹配
OleDbCommand cmd2 = new OleDbCommand("UPDATE 客房 SET 入住='Y' WHERE 房间号='" + key + "'", con);
OleDbCommand cmd3 = new OleDbCommand("UPDATE 客房 SET 预定='N' WHERE 房间号='" + key + "'", con);
OleDbCommand cmd4 = new OleDbCommand("UPDATE 客房 SET 姓名='" + name + "'WHERE 房间号='" + key + "'", con);
OleDbCommand cmd5 = new OleDbCommand("UPDATE 客房 SET 身份证='" + num + "'WHERE 房间号='" + key + "'", con);
OleDbCommand cmd6 = new OleDbCommand("UPDATE 客房 SET 入住时间='" + days + " " + times + "' WHERE 房间号='" + key + "'", con);
cmd1.ExecuteNonQuery();这行提示标准表达式中数据类型不匹配
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货