Advertisement

07.07.2008 at 10:25AM PDT, ID: 23544050 | Points: 500
[x]
Attachment Details

VB COM+

Asked by onebite2 in Visual Basic Programming, VB Script, WebApplications

Got a VB 6.0 COM+ question,
I have about 80,000 Records in a recordset, that are in a datatable/grid.
Grid/Datatable has a check box for every record.
User would check the checkbox(on single record or multiple records).
There is Load button on the screen.
When user hits the Load button on the screen.
All the unchecked records need to be deleted out of Recordset as well as out of datatable.
I'm going to show you the code i have but that code takes long time to do this process, if there are arounds 100K records.. Let me know if you have any better suggestions to make this process faster..
We use VB+ASP but the code in VB.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

Rs1.MoveFirst
   i=0
   
'CellObj is checkbox on the datatable. just trying to check if its 'checked or unchecked
   Do While Not Rs1.Eof
     CellObj = DataTable1.CellSet(i, 0).value
     If CellObj=0 Then
        Rs1.Delete
        Rs1.Update
        i = i - 1
     End If
   Rs1.MoveNext
   i = i + 1
   Loop
[+][-]07.07.2008 at 10:56AM PDT, ID: 21947175

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.07.2008 at 11:11AM PDT, ID: 21947276

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.07.2008 at 04:01PM PDT, ID: 21949349

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.10.2008 at 12:40PM PDT, ID: 21976695

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.10.2008 at 02:36PM PDT, ID: 21977602

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 07:58AM PDT, ID: 22069984

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628