-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: CrazyAboutDOTNET
Message 1 in Discussion
Hello everybody,
I m one of the silent member of this group. I m
creating a VB.NET project for transfer database to DBASE to SQL Server. In this
transfer I m doing some calculation with DBASE database and after that I m
putting that calculated data into SQL Server database. I have near about 25
tables. In this program I have two progress bar. First progress bar increases
its value as data transferred in a table and the second progress bar increases
its value as one table transferred. I m using threading and I m calling next
thread at the end of one thread. So to copy one table I have thread and at the
end of the first thread I call the next thread. It works perfectly if I have
few data in a table but if I have 15 to 30 thousand data in any table then it
complete this table but after that it just increase the second progress bar
value and end the program and say �data transfer complete.� Which is at the
last table in transfer. Code is as follows :
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
Sub ThrCust()<o:p></o:p>
ProgressBar2.Value = 0<o:p></o:p>
fromdt = MakeDataset("CUST")<o:p></o:p>
If Not (fromdt Is Nothing) Then TransferCUST(fromdt)<o:p></o:p>
ds.Clear()<o:p></o:p>
ProgressBar1.Value = 0<o:p></o:p>
ProgressBar2.Value += 1<o:p></o:p>
Dim ThSupp As New Thread(New ThreadStart(AddressOf ThrSupp))<o:p></o:p>
ThSupp.Start()<o:p></o:p>
End Sub<o:p></o:p>
<o:p> </o:p>
Sub ThrSupp()<o:p></o:p>
fromdt = MakeDataset("SUPP")<o:p></o:p>
If Not (fromdt Is Nothing) Then TransferSUPP(fromdt)<o:p></o:p>
ds.Clear()<o:p></o:p>
ProgressBar1.Value = 0<o:p></o:p>
ProgressBar2.Value += 1<o:p></o:p>
Dim ThStms As New Thread(New ThreadStart(AddressOf ThrSTMS))<o:p></o:p>
ThStms.Start()<o:p></o:p>
End Sub<o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
Is there anything like timeout in threading or something like this. Problem is
really major for me. If u want any other information please ask me. <o:p></o:p>
<o:p> </o:p>
Thank you in advance.<o:p></o:p>
<o:p> </o:p>
Alankar Jain<o:p></o:p>
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
