各位大侠帮小弟看看

NewWorkers 2012-07-24 09:34:59

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是在循环体里面的，在循环体外面无法使用。各位大侠有什么方法？

...全文

66 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

NewWorkers 2012-07-24

打赏
举报

新手学习中，多谢大神指点啊

妖精de独步舞 2012-07-24

打赏
举报

布局不够清晰有点乱不方便改错哦

maji_lulu 2012-07-24

打赏
举报

count 放到循环体外面定义，不就OK 了嘛

q107770540 2012-07-24

打赏
举报

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("保存失败", "提示");

  //}

    



  }