PC Review


Reply
Thread Tools Rate Thread

dataview filter & for-loop

 
 
Agnes
Guest
Posts: n/a
 
      12th Jul 2004
I got a large dataview and want to filter some data
and use the for-loop to list the data, however, it seems myThought is wrong.
All the data is list.

dvHBL.RowFilter = "jobno='" & strJobno & "' "
For Each drHBL In dvHBL.Table.Rows
tnjob.Nodes.Add(drHBL.Item("jobno") <-- all data is list
regardless the rowfilter
Next


 
Reply With Quote
 
 
 
 
Greg Burns
Guest
Posts: n/a
 
      12th Jul 2004
For Each r As DataRowView In dvHBL
tnjob.Nodes.Add(r.Item("jobno").ToString)
Next

untested

"Agnes" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I got a large dataview and want to filter some data
> and use the for-loop to list the data, however, it seems myThought is

wrong.
> All the data is list.
>
> dvHBL.RowFilter = "jobno='" & strJobno & "' "
> For Each drHBL In dvHBL.Table.Rows
> tnjob.Nodes.Add(drHBL.Item("jobno") <-- all data is

list
> regardless the rowfilter
> Next
>
>



 
Reply With Quote
 
Cor Ligthert
Guest
Posts: n/a
 
      12th Jul 2004
Hi Agnes,

> dvHBL.RowFilter = "jobno='" & strJobno & "' "
> For Each drHBL In dvHBL.Table.Rows
> tnjob.Nodes.Add(drHBL.Item("jobno") <-- all data is

list
> regardless the rowfilter
> Next


Here you say only that you have to take the table from the dataview to go
through.As solution I have nothing to add to the answer from Greg.

Cor


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataView filter Duggi Microsoft C# .NET 2 12th Nov 2008 06:00 PM
Loop to Filter, Name Sheets. If Blank, Exit Loop ryguy7272 Microsoft Excel Programming 3 5th Feb 2008 03:41 PM
HELP: DataView does NOT filter :-( werk@velp.info Microsoft C# .NET 1 20th Jan 2005 04:13 PM
DataView loop and edit? Able Microsoft VB .NET 14 5th Jun 2004 03:37 PM
HOW TO LOOP THROUGH SORTED DATAVIEW? Aric Levin Microsoft ADO .NET 1 21st Oct 2003 02:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:23 PM.