473,408 Members | 2,444 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

label refresh problem in vb6

Expand|Select|Wrap|Line Numbers
  1. For krushn = om21 To om42
  2.  
  3. Text7 = krushn
  4.  
  5. If con.State = 1 Then con.Close
  6. con.Open "Provider=Microsoft.Jet.OLEDB----------------------”
  7.  
  8. seetaseeta = 13
  9.  
  10. rs21.Open "select * from savebroadsheet where firstD='" + Text1 + "' and p3='" + Text7 + "'", con, 1, 3
  11. If rs21.RecordCount >= 1 Then seetaseeta = 21
  12.  
  13. If rs21.State = 1 Then rs21.Close
  14. rs21.Open "delete from tempbrodsheet13", con, 1, 3
  15. rs21.Open "tempbrodsheet13", con, 1, 3
  16.  
  17. rs13.Open "select * from allbalu where t1='" + Text1 + "' and l7='" + Text7 + "'", con, 1, 3
  18. Label1.Caption = "Total Employee : " + Trim(Str(rs13.RecordCount))
  19.  
  20. Do While Not rs13.EOF
  21. hh = hh + 1
  22. Label13.Caption = hh
  23. Label13.Refresh
  24.   rs21.AddNew
  25.   rs21!ecode = rs13!t3
  26.   rs21!ename = rs13!l11
  27.   rs21!prebal = Val(Mid(rs13!sx1, 15, 52))
  28.    rs21.Update
  29. rs13.MoveNext
  30. Loop
  31. rs21.Requery
  32. If seetaseeta = 13 Then 
  33. rs65.Open "insert into savebroadsheet select * from tempbrodsheet13", con, 1, 3
  34. endif
  35.  
  36. con.Close
  37.  
  38. Next
  39.  
  40.  
  41.  
Problem :
i am display value of hh label13
and refresh label every time..but after some time label refreshing is stop..but processing is going on...but i dont know how label refreshing is stop........plz help me...
Apr 7 '16 #1
1 1638
Expand|Select|Wrap|Line Numbers
  1.  
  2.  
  3. For krushn = om21 To om42
  4.  
  5. Text7 = krushn
  6.  
  7. If con.State = 1 Then con.Close
  8. con.Open "Provider=Microsoft.Jet.OLEDB----------------------”
  9.  
  10. seetaseeta = 13
  11.  
  12. rs21.Open "select * from savebroadsheet where firstD='" + Text1 + "' and p3='" + Text7 + "'", con, 1, 3
  13. If rs21.RecordCount >= 1 Then seetaseeta = 21
  14.  
  15. If rs21.State = 1 Then rs21.Close
  16. rs21.Open "delete from tempbrodsheet13", con, 1, 3
  17. rs21.Open "tempbrodsheet13", con, 1, 3
  18.  
  19. rs13.Open "select * from allbalu where t1='" + Text1 + "' and l7='" + Text7 + "'", con, 1, 3
  20. Label1.Caption = "Total Employee : " + Trim(Str(rs13.RecordCount))
  21.  
  22. Do While Not rs13.EOF
  23. hh = hh + 1
  24. Label13.Caption = hh
  25. Label13.Refresh
  26.   rs21.AddNew
  27.   rs21!ecode = rs13!t3
  28.   rs21!ename = rs13!l11
  29.   rs21!prebal = Val(Mid(rs13!sx1, 15, 52))
  30.    rs21.Update
  31. rs13.MoveNext
  32. Loop
  33. rs21.Requery
  34. If seetaseeta = 13 Then 
  35. rs65.Open "insert into savebroadsheet select * from tempbrodsheet13", con, 1, 3
  36. endif
  37.  
  38. con.Close
  39.  
  40. Next
  41.  
  42.  
  43.  
  44.  
Apr 13 '16 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Yogi_Bear_79 | last post by:
Self Taught here so please bear with me. I have the labelRestrictSites as private on the MainForm.cs. I then access the labelRestrictSites.Text thru the public string LabelRestrictSites from...
1
by: nospamjac | last post by:
Hi, Is there a way to update the text of an asp:label on a webform without refreshing the entire page? What is called by button clicks and other events that refresh a webform control? See the...
4
by: Ed Willis | last post by:
If I am processing through a loop in my code and I want to update a row count on the window, how can I make the window refresh and show the label etc. updating? Thanks.
6
by: jcrouse | last post by:
I am rotating some text is some label controls. In the one place I use it it works fine. In the other place I use it I can't figure out the syntax. I don't really understand the event. Where it...
2
by: Ned Balzer | last post by:
Hi, Apologies if this is a newbie question, I haven't found the answer in any faqs. I have an asp.net 2.0 page that sets session variables and then redirects to another page. For the page...
3
by: KenMacksey | last post by:
Hi I am running VB6 on a pentium 4 and Win XP pro. I wrote a small program to copy files to a memory card or mp3 player etc in a specific order or a random order instead of the windows default...
13
by: AKHTAR ALI | last post by:
Dear Sir, i am reading a text file line by line from vb and insert in oracle table through pl/sql procedure. in text file record is 70000, in my code i make a loop to read data in loop and...
2
by: =?Utf-8?B?Y2FzaGRlc2ttYWM=?= | last post by:
Hi, I have a Label on a Windows form (Version 1.1.4322) and while I iterate recursively through a method I want to show the name of the current file being copied to another directory. The...
0
by: Phillip Ian | last post by:
Tried this over in CSharp.General and didn't get anything, so I thought I'd try again here. If there's an AJAX specific group I could ask this in, please let me know...I did look. I'm trying to...
4
by: =?Utf-8?B?YmJkb2J1ZGR5?= | last post by:
I have a couple of questions, these are problems that I have experienced with IE 6 1. I have a label on a form, and sometimes when the form refreshes the label doesn't appear on the screen,...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.