Filter Dataview
-
I have a DataView.in some part of my application I I use filter statement to filter it..Then I want to read records in FILTERED dataiview.When I use
myDataView.Table.Rows.CountormyDataView.Table.Rows[i][k]it gives me all records not filter ones. Any suggestion? Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975 -
I have a DataView.in some part of my application I I use filter statement to filter it..Then I want to read records in FILTERED dataiview.When I use
myDataView.Table.Rows.CountormyDataView.Table.Rows[i][k]it gives me all records not filter ones. Any suggestion? Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975myDataView.Table refers to the original table, not the filtered data. Just use
myDataView[i][k];. James Sonork ID: 100.11138 - Hasaki "I left there in the morning with their God tucked underneath my arm their half-assed smiles and the book of rules. So I asked this God a question and by way of firm reply, He said - I'm not the kind you have to wind up on Sundays." "Wind Up" from Aqualung, Jethro Tull 1971 -
myDataView.Table refers to the original table, not the filtered data. Just use
myDataView[i][k];. James Sonork ID: 100.11138 - Hasaki "I left there in the morning with their God tucked underneath my arm their half-assed smiles and the book of rules. So I asked this God a question and by way of firm reply, He said - I'm not the kind you have to wind up on Sundays." "Wind Up" from Aqualung, Jethro Tull 1971 -
wowww,I didn't know it is possible,I have to test it now. Thanks:) Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975Neither did I, this is the second look I've taken at the DataView class and I just noticed it had an indexer on it (so you can use the
myDataView[]syntax). James Sonork ID: 100.11138 - Hasaki "I left there in the morning with their God tucked underneath my arm their half-assed smiles and the book of rules. So I asked this God a question and by way of firm reply, He said - I'm not the kind you have to wind up on Sundays." "Wind Up" from Aqualung, Jethro Tull 1971 -
Neither did I, this is the second look I've taken at the DataView class and I just noticed it had an indexer on it (so you can use the
myDataView[]syntax). James Sonork ID: 100.11138 - Hasaki "I left there in the morning with their God tucked underneath my arm their half-assed smiles and the book of rules. So I asked this God a question and by way of firm reply, He said - I'm not the kind you have to wind up on Sundays." "Wind Up" from Aqualung, Jethro Tull 1971I have another question about it,I used
myDataView[][]and it was ok.Now How can I return NUMBER of filterd ROW,myDataView[]is index of recordset not row. Thanks. Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975 -
I have another question about it,I used
myDataView[][]and it was ok.Now How can I return NUMBER of filterd ROW,myDataView[]is index of recordset not row. Thanks. Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975myDataView.Count;:) James Sonork ID: 100.11138 - Hasaki "I left there in the morning with their God tucked underneath my arm their half-assed smiles and the book of rules. So I asked this God a question and by way of firm reply, He said - I'm not the kind you have to wind up on Sundays." "Wind Up" from Aqualung, Jethro Tull 1971 -
myDataView.Count;:) James Sonork ID: 100.11138 - Hasaki "I left there in the morning with their God tucked underneath my arm their half-assed smiles and the book of rules. So I asked this God a question and by way of firm reply, He said - I'm not the kind you have to wind up on Sundays." "Wind Up" from Aqualung, Jethro Tull 1971