String sql = “select doorNum from doorManage where inTime is NULL”;//is可以,=不行!
表名最好不要用数字开头
“insert into “+ door,into后边不要忘记空格
(int) command.ExecuteScalar();返回第一行第一列的值
String sql = “select doorNum from doorManage where inTime is NULL”;//is可以,=不行!
表名最好不要用数字开头
“insert into “+ door,into后边不要忘记空格
(int) command.ExecuteScalar();返回第一行第一列的值