Question

winform 进度条 执行数据库语句

int count = 100;
private void button1_Click(object sender, EventArgs e)
{
if (this.backgroundWorker1.IsBusy)
{
MessageBox.Show("正在执行");
return;
}
//backgroundWorker1.RunWorkerAsync(count); //触发DoWork事件
backgroundWorker1.RunWorkerAsync(count); //触发DoWork事件
}

private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker bw = (BackgroundWorker)sender;
insertData(bw);
//e.Result = insertData(this.backgroundWorker1,e);
}
private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
progressBar1.Value = e.ProgressPercentage;
}
//private void insertData(BackgroundWorker Worker)
private void insertData(BackgroundWorker Worker)
{

//int percent = 0;
SqlConnection Constr = new SqlConnection("server=.;database=supermarket;Uid=sa;Password=pcserver;");//连接数据库
SqlCommand cmd = new SqlCommand("insertOneData ", Constr);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@data1", SqlDbType.Int);
cmd.Parameters.Add("@data2", SqlDbType.Int);
#region //一种用法
for (int i = 0; i < count; i++)
{
try
{

Constr.Open();
cmd.Parameters["@data1"].Value = i + 1;
cmd.Parameters["@data2"].Value = i + 1;
cmd.ExecuteNonQuery();
Worker.ReportProgress(i, Worker);

}
catch (Exception ex)
{
MessageBox.Show("执行行数据库时有语!" + ex.Message);
}
finally
{
if (Constr.State == ConnectionState.Open)
{
Constr.Close();
}
}
#endregion
Thread.Sleep(50); //感觉进度条动的时间有个变化
}
以上代码中,向数据库中插入多条数据用for循环就可以了!然后向 Worker.ReportProgress(i,Worker);中传值改变，请问大吓们，如果我不插件，我select，或者update怎么做，就没有for，怎么改变，请大吓们多指教!小弟非常感谢!或者有操作数据库的方面，请发至我邮箱:873744779@qq.com

Answer 1

你可以用数据库里的存储过程来实现对数据库操作，在窗体里只是调用数据库操作函数就行。