数据库增改删

1.增改删

//不带参数
var sqladd1 = db1.Execute("insert into ComProject values('1001','ABB','this is cc')");  //返回影响的记录数，多个语句请用";"分隔

//带参数
var ProjectName1="ABB";
var txt1="this is my cc";
db1.Execute("insert into ComProject values('1001',@0,@1)",ProjectName1,txt1);

2.返回seq

var seqv = db1.GetLastInsertId();  //新增后，返回seq