我要在表里加入一条记录
thisCommand.CommandText = @"Insert Into History (Date, Time, Info) " +
@"Values (date, time, r.DecisionResult.Text)";
说命令有语法错误 不知道是为什么
谢谢大家了
Date, Time, Info 和 date, time都是string 格式
...全文
12314打赏收藏
insert命令的问题
我要在表里加入一条记录 thisCommand.CommandText = @"Insert Into History (Date, Time, Info) " + @"Values (date, time, r.DecisionResult.Text)"; 说命令有语法错误 不知道是为什么 谢谢大家了 Date, Time, Info 和 date, time都是string 格式
如果date和time直接是要插入的数据话,而不是参数,可以如下:
thisCommand.CommandText = @"Insert Into History (Date, Time, Info) " +
@"Values ('date', 'time', '"+r.DecisionResult.Text+"')";
如果date和time是自己的字符变量,可以如下:
thisCommand.CommandText = @"Insert Into History (Date, Time, Info) " +
@"Values ('"+date
+"', '"+time+"', '"+r.DecisionResult.Text+"')";
To thisCommand.CommandText = @"Insert Into History (Date, Time, Info) " +
@"Values (date, time, r.DecisionResult.Text)";
如果date和time直接是要插入的数据话,而不是参数,可以如下:
thisCommand.CommandText = @"Insert Into History (Date, Time, Info) " +
@"Values ('date', 'time', '"+r.DecisionResult.Text+"')";
如果date和time是自己的字符变量,可以如下:
thisCommand.CommandText = @"Insert Into History (Date, Time, Info) " +
@"Values ('"+date
+"', '"+time+"', '"+r.DecisionResult.Text+"')";