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

诸位大侠帮小弟看看

2012-07-29 
各位大侠帮小弟看看try{for (int i 0 i dt.Rows.Count-1 i++){fid Convert.ToInt32(dt.Rows[i][fi

各位大侠帮小弟看看
try
  {
   

  for (int i = 0; i < dt.Rows.Count-1; i++)
  {
   
  fid =Convert.ToInt32(dt.Rows[i]["fid"].ToString());
  fname = dt.Rows[i]["fname"].ToString();
  fsellprice =Convert.ToDouble(dt.Rows[i]["fsellprice"].ToString());
  fnumber =Convert.ToInt32(dt.Rows[i]["fnumber"].ToString());
  funitprice =Convert.ToDouble(dt.Rows[i]["funitprice"].ToString());
  fbarcode =Convert.ToInt32(dt.Rows[i]["fbarcode"].ToString() ); 

  sql = "insert into ftest(fid,fname,fsellprice,fnumber,funitprice,fbarcode) values(" + fid + ",'" + fname + "'," + fsellprice + "," + fnumber + "," + funitprice + "," + fbarcode + ")";
  MySqlCommand cmd = new MySqlCommand(sql, conn);
  int count = Convert.ToInt32(cmd.ExecuteNonQuery());
  //if (count == 1)
  //{
  // MessageBox.Show("保存成功", "提示");
  //}
  //else
  //{
  // MessageBox.Show("保存失败", "提示");
  //}
   
  }
   


  }
我想在执行完循环之后再提示保存成功或者失败,因为我定义的 count是在循环体里面的,在循环体外面无法使用。各位大侠有什么方法?

[解决办法]
int count

放函数外面啊不久可以在其他地方使用啊

[解决办法]

C# code
int count=0;try  {      for (int i = 0; i < dt.Rows.Count-1; i++)  {      fid =Convert.ToInt32(dt.Rows[i]["fid"].ToString());  fname = dt.Rows[i]["fname"].ToString();  fsellprice =Convert.ToDouble(dt.Rows[i]["fsellprice"].ToString());  fnumber =Convert.ToInt32(dt.Rows[i]["fnumber"].ToString());  funitprice =Convert.ToDouble(dt.Rows[i]["funitprice"].ToString());  fbarcode =Convert.ToInt32(dt.Rows[i]["fbarcode"].ToString() );    sql = "insert into ftest(fid,fname,fsellprice,fnumber,funitprice,fbarcode) values(" + fid + ",'" + fname + "'," + fsellprice + "," + fnumber + "," + funitprice + "," + fbarcode + ")";  MySqlCommand cmd = new MySqlCommand(sql, conn);   count = Convert.ToInt32(cmd.ExecuteNonQuery());    }    //if (count == 1)  //{  // MessageBox.Show("保存成功", "提示");  //}  //else  //{  // MessageBox.Show("保存失败", "提示");  //}      }
[解决办法]
count 放到循环体外面定义,不就OK 了嘛

热点排行