C # backgroundworker_C#while 线程等待_backgroundworker(3)

this.label1.Text=Convert.ToString(((e.ProgressPercentage)*100/progressBar1.Maximum))+"%";

}

publicvoidCompleteWork(objectsender,RunWorkerCompletedEventArgse)

{

this.progressBar1.Value=Total;

this.label1.Text="完成!";

}

publicvoidTransferData(stringexcelFile,stringsheetName,stringconnectionString)

{

try

{

DataSetDS=newDataSet();

stringstrConn="Provider=Microsoft.Jet.OLEDB.4.0;"+"DataSource="+excelFile+";ExtendedProperties=Excel8.0";

OleDbConnectionconn=newOleDbConnection(strConn);

conn.Open();

stringstrExcel=string.Format("select*from[{0}$]",sheetName);

OleDbDataAdapterAdapter=newOleDbDataAdapter(strExcel,conn);

OleDbCommandBuilderBuilder=newOleDbCommandBuilder(Adapter);

Adapter.Fill(DS,sheetName);

using(System.Data.SqlClient.SqlBulkCopybcp=newSystem.Data.SqlClient.SqlBulkCopy(connectionString))

{

intDone=0;

bcp.BatchSize=1000;

bcp.NotifyAfter=1000;

bcp.DestinationTableName="test";

bcp.WriteToServer(DS.Tables[0]);

Done=Done+1000;

bkWorker.ReportProgress(Done);

}

conn.Dispose();

Adapter.Dispose();

Builder.Dispose();

DS.Dispose();

}

catch(Exceptionex)

{

System.Windows.Forms.MessageBox.Show(ex.Message);

}

}

privatevoid取消_Click(objectsender,EventArgse)

{

bkWorker.CancelAsync();

}

}

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-27008-3.html