请教一条关于插入语句的问题

Question

表里主键自动生成，其他字段都允许为空，我在程序里写的语句是string sql = "INSERT INTO customer (name,sex,age,nation,address,idcard,cardno,roomid,birthday,indate) VALUES ('";sql += userName +"','" + userSex +"'," + userAge +",'" + userNation + "','" + userAddress +"',";sql += userIDCard + "," + userCard + ","+ userRoom + ",'" + userBirthday + "','" + userDate +"')";程序生成的语句是INSERT INTO customer (name,sex,age,nation,address,idcard,cardno,roomid,birthday,indate) VALUES ('as','',,'','',,1003,,'','')但是程序报错，请问在字段允许为空的条件下，这个语句该怎么写？

Answer 1

try:string sql = "INSERT INTO customer (name,sex,age,nation,address,idcard,cardno,roomid,birthday,indate) VALUES ('";
userAge=userAge.Length!=0?userAge:"0";
userIDCard=userIDCard.Length!=0?userIDCard:"0";
userRoom=userRoom.Length!=0?userRoom:"0";
sql += userName +"','" + userSex +"'," + userAge +",'" + userNation + "','" + userAddress +"',"; sql += userIDCard + "," + userCard + ","+ userRoom + ",'" + userBirthday + "','" + userDate +"')";