你可以这样插入:(大写的字符串是数据库表中的row项)
queryDataSet1.open();
DataRow dr = new DataRow(queryDataSet1, new String[] { "BUSIID","TRADNO","NAME","TIMEOUT","STARTCUST","CONDITION","REVFLAG"}); //初始化DATAROW
dr.setInt("BUSIID",busiid);
dr.setInt("TRADNO",tradno);
dr.setString("NAME",name);
dr.setInt("TIMEOUT",timeout);
dr.setInt("STARTCUST",startcust);
dr.setString("CONDITION",condition);
dr.setInt("REVFLAG",revflag);
queryDataSet1.updateRow(dr);
database1.saveChanges(queryDataSet1);
queryDataSet1.close();
queryDataSet1.open();
DataRow dr = new DataRow(queryDataSet1, new String[] { "BUSIID","TRADNO","NAME","TIMEOUT","STARTCUST","CONDITION","REVFLAG"}); //初始化DATAROW
dr.setInt("BUSIID",busiid);
dr.setInt("TRADNO",tradno);
dr.setString("NAME",name);
dr.setInt("TIMEOUT",timeout);
dr.setInt("STARTCUST",startcust);
dr.setString("CONDITION",condition);
dr.setInt("REVFLAG",revflag);
queryDataSet1.updateRow(dr);
database1.saveChanges(queryDataSet1);
queryDataSet1.close();
问题2.就像错误提示中说的那样,在你所添加的queryDataSet的metaDataUpdata属性栏中去掉Rowid选项,并且在每个column的rowid属性栏中选择True就OK了。