首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

插入有关问题重复有关问题,

2012-09-05 
插入问题重复问题,急??DataSet setInsert WebData1.dataSet(insertsqls)foreach (DataRow drInsert in

插入问题重复问题,急??
DataSet setInsert = WebData1.dataSet(insertsqls);
   
  foreach (DataRow drInsert in setInsert.Tables[0].Rows)
  {
  //插入资料表sql--start
   
  sb.Append("var code = '', name = '', type = '', slkcode = '', createdt = '', createby = '', salesacc = '', sysed = '', sysud = '', sales = '', areacode = '';");
  sb.Append("code = '" + drInsert["customer_code"].ToString() + "';" +
  "name = '" + drInsert["customer_name"].ToString() + "';" +
  "type = '" + drInsert["customer_type"].ToString() + "';" +
  "slkcode = '" + drInsert["slk_code"].ToString() + "';" +
  "createdt = '" + drInsert["create_dt"].ToString() + "';" +
  "createby = '" + drInsert["create_by"].ToString() + "';" +
  "salesacc = '" + drInsert["sales_account"].ToString() + "';" +
  "sysed = '" + drInsert["SYSDE"].ToString() + "';" +
  "sysud = '" + drInsert["SYSUD"].ToString() + "';" +
  "sales = '" + drInsert["sales"].ToString() + "';" +
  "areacode = '" + drInsert["Area_code"].ToString() + "';");
  sb.Append("var insertSql='INSERT INTO Cus_ (customer_code, customer_name, customer_type, slk_code, create_dt, create_by, sales_account, SYSDE, SYSUD,sales,Area_code) VALUES (?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?)';");
  sb.Append("db.transaction(function(tt){" +
  "tt.executeSql(insertSql,[code,name,type,slkcode,createdt,createby,salesacc,sysed,sysud,sales,areacode],function(){},function(){});" +
  "});");
  }


插入数据结果如下:
C0000002845-酷l-王
C0000002845-酷l-王
C0000002845-酷l-王
C0000002845-酷l-王
上边的循环好像没错,为什么插入的数据一直都是重复的,哪些高人指点下。

[解决办法]
重复插入 肯定是你的sb 没有被清空 你的sb 是一直在循环加 字符
改下就好了

C# code
 foreach (DataRow drInsert in setInsert.Tables[0].Rows)  {    StringBulid sb=new StringBulid()} 

热点排行