用dapt.Update(ds)更新数据库时我怎么记时间?

Question

 C#中:
                     try
                    {
                        conn.Open();
                        string strSelect = string.Format("select * from {0}", cmbTable.Text);
                        SqlDataAdapter dapt = new SqlDataAdapter(strSelect, conn);
                        SqlCommandBuilder builder = new SqlCommandBuilder(dapt);
                        DataSet ds = new DataSet();
                        dapt.Fill(ds);
                        progressBar1.Maximum = ds.Tables[0].Rows.Count;
                        progressBar1.Visible = true;
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            dr[cmbSaveCol.Text] = Hz2Py.SetToLower(dr[cmbSelectCol.Text].ToString());
                            progressBar1.Value++;
                        }                        dapt.Update(ds);
                        conn.Close();
                        MessageBox.Show("操作成功");                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.ToString());
                    }
这里我要用progressBar1用来记录程序还有多少时间完成,但是我写在foreach中显然是不对的,Update(ds)时还有一段时间,这我怎么判断?

Answer 1

这没办法,不能追踪到内部,你可以一条一条的自己写