C1 Community
ComponentOne Community is a free source for developers and help authors to collaborate and communicate.
Forums » WinForms » ADO.NET DataExtender » Selective load into C1DataViewSet

Selective load into C1DataViewSet

rated by 0 users
This post has 2 Replies | 0 Followers

Top 150 Contributor
Posts 42
Reply
vbogey Posted: Wed, Oct 24 2007 4:20 PM

Here is my simple scenario:

I have 2 tables: 

  • Orders with over 1,000,000 rows and 
  • [Order Details with over 5,000,000 rows

How to load just selective row(s) from Orders and only corresponding rows from [Order Details] table into C1DataViewSet?

vbogey

Top 10 Contributor
Posts 1,090
Reply
C1_JohnAd replied on Thu, Dec 20 2007 3:18 PM
Hi vbogey,
 
You can use the RowFilter() property for different views in the C1DataViewSet.
 
For example: If you wish to implement filter on a button click, you can use the code
in the following manner under Button Click event.
 
Me.C1DataViewSet1.Views("Orders").RowFilter = "OrderID = 10248"
 
Since Orders and Order Details will be linked by relation in the ViewSet Designer,
after filtering only corresponding rows from the Order Details will be fetched.
 
I hope this helps.

Regards,
Allen Smith
<vbogey> wrote in message news:199234@10.0.1.98...

Here is my simple scenario:

I have 2 tables: 

  • Orders with over 1,000,000 rows and 
  • [Order Details with over 5,000,000 rows

How to load just selective row(s) from Orders and only corresponding rows from [Order Details] table into C1DataViewSet?

vbogey


http://helpcentral.componentone.com/cs/forums/p/73389/199234.aspx#199234

Top 150 Contributor
Posts 42
Reply
vbogey replied on Tue, Jan 15 2008 1:24 PM

Almost 1 year later I have found the answer for my question.

Sorry Allen, but I can't confirm your findings.

There are 2 aspects of loading data:

  • 1. Loading data from database into dataset table and as a result into C1DataSetView Table and
  • 2. "Loading" or rather selecting data into C1DataSetView View.

You gave me an answer for the second one.

My original question was about loading selective rows from database.

I don't want to load millions of rows of data when I need only just few.

I'm afraid this issue has been overlooked in the design of this component.

You may test my statement debugging ViewSet_Define_Fill_Update.sln to see that filter set on C1DataSetView.View affects only particular C1DataSetView.View and not underlying C1DataSetView.Table.

 

Page 1 of 1 (3 items) | RSS
Contact ComponentOne: 1.800.858.2739 ©1987-2010 ComponentOne LLC All Rights Reserved.