Home » WinForms » ADO.NET DataExtender » Selective load into C1DataViewSet

Re: Selective load into C1DataViewSet

WinForms

ComponentOne's WinForms controls
Details
  • 2 Replies
  • 0 Subscribers
  • 1044 days old
Options

Selective load into C1DataViewSet

  • rated by 0 users
  • This post has 2 Replies |
  • 0 Followers
  • Posted by
    on 10-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

    ,
  • Posted by
    on 12-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
  • Posted by
    on 1-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)