Now the problem is with old DAO and vb6 I was able to load over 4k records in 1-3 secs. the answer I recv'd works perfect the only problem is that it takes 2-5 min to load the data.

I am faily new to ado.net and don't understand why I'm not able to create complex data tables like I did with DAO. somebody suggested we buy ComponentOne's ExpressData and DataComponents but I'm not to sure if my company will go for it.

one table contains all the agent records and the other table contains all the transactions.
I have to add one agent to the control and then add each transaction to that agent.
its not possible to do it in one sweep.. if it was then that would be awsome

ya, I thought the same while answering his first question. But Greg, there is a problem...
nIndex = Me.ctSchedule0.AddItem(strID & ";" & strLname & ";" & StrFname)
Here he needs DISTINCT Agent_Id... I mean each agent has unique nIndex.

But while adding to the "nbar"...
nbar = Me.ctSchedule0.AddTimeBar(nIndex, OleDtRdr.GetInt32(0), OleDtRdr.GetInt32(1), OleDtRdr.GetValue(2), OleDtRdr.GetValue(2)) ..... there he wants all the transaction for that agent.

Ok, here is the PLAN of ACTION: (my suggestion, please correct me if I am wrong)
How about if we make two tables in the dataset... one with DISTINCT AgentID and the other one is basically all the rows of Transaction table. Now we will do something like...
for each row in first table...
> nIndex = Me.ctSchedule0.AddItem(strID ... , and get the nIndex.
> Now if we can make filtered selection from the second table.... (We can filter the view .. right ?)
> insert to "nbar"
Next Row

maybe I didn't understand you comment gregoryyoung.. I am faily new to vb.net and wasn't aware of a datarelation.
my mind seems to be stuck in the vb6 world. I talked my employer into upgrading to vb.net and now I'm faced with learning new code.
if possible can you please provide me with a sample code of a datarelation.

Featured Post

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

1.0 - Introduction
Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET).
If ever there was a subject full of murkiness and bad decisions, it is this one! The first problem seems to be that people considering this task of converting…

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity)
(CODE)
There are three files available HERE (http://www.ecb.europa.eu/stats/exch…

This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory.
NOTE: For Outlook 2016 and 2013 perform the exact same steps.
Open a new email: Click the New email button in Outlook.
Start typing the address: …