dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: What should be the Row filter for this???

  1. #1
    Join Date
    Apr 2004
    Posts
    123

    What should be the Row filter for this???

    I have a Datatable in the following format

    Colum1 Colum2
    xxx aaa
    xxx bbb
    xxx ccc
    yyy aaa
    yyy a

    and so on...

    I need to create a view to get all the rows with Column1="a particular value" and coulmn2="a combination of column2 values"....or the row filer for the view should be "Column1=xxx" and Column2="aaa AND bbb"..or in other words i need to retrieve rows xxx,aaa and xxx,bbb.I want to eliminate xxx,ccc...how to specify the row filter for this????

    I'm bit new to this,so it would be helpful if you can mention what would be the fastest way to retrieve such an information from a datatable..as my datatable contains more than a million rows..

    Thanks,
    Mmx

  2. #2
    Join Date
    Apr 2006
    Posts
    220

    Re: What should be the Row filter for this???

    Fastest option would be stored procedure. Next comes SQL query. Next comes DataView.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)