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

}

else

{

char[]TrimChar={'\'','$'};

TableName=TableName.Trim(TrimChar);

}

DataSetDS=newDataSet();

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

OleDbDataAdapterAdapter=newOleDbDataAdapter(strExcel,conn);

OleDbCommandBuilderBuilder=newOleDbCommandBuilder(Adapter);

Adapter.Fill(DS,TableName);

Total=Total+DS.Tables[0].Rows.Count;

Builder.Dispose();

Adapter.Dispose();

DS.Dispose();

}

}

table.Dispose();

conn.Dispose();

}

this.progressBar1.Maximum=Total;

bkWorker.RunWorkerAsync();

}

}

publicvoidDoWork(objectsender,DoWorkEventArgse)

{

stringconnString="Server=GFKSAS3;UID=sa;PWD=f0reC0urt;Database=Northwind";

foreach(stringFileNameinFileNames)

{

OleDbConnectionconn=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;ExtendedProperties=Excel8.0;DataSource="+FileName);

conn.Open();

DataTabletable=conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);

for(inti=0;i<table.Rows.Count;i++)

{

stringTableName=table.Rows[i]["TABLE_NAME"].ToString();

if((TableName.Substring(TableName.Length-1,1)=="$")||(TableName.Substring(0,1)=="'"))

{

if((TableName.Substring(TableName.Length-2,1)=="$"))

{

char[]TrimChar={'\''};

TableName=TableName.Trim(TrimChar);

TableName=TableName.Substring(0,TableName.Length-1);

}

else

{

char[]TrimChar={'\'','$'};

TableName=TableName.Trim(TrimChar);

}

TransferData(FileName,TableName,connString);

}

}

table.Dispose();

conn.Dispose();

}

}

publicvoidProgessChanged(objectsender,ProgressChangedEventArgse)

{

this.progressBar1.Value=e.ProgressPercentage;

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