Selecting first N rows in DataView
-
HI All, I have a requirement where I need to select first N rows from DataView. So how could i achieve this? Thanks, Rachit Damani.
-
HI All, I have a requirement where I need to select first N rows from DataView. So how could i achieve this? Thanks, Rachit Damani.
use SELECT TOP N... << >>
-
use SELECT TOP N... << >>
Thanks for your reply but how i could use select query in dataview? i don't need to select top N rows when i am fetching the data from the database but at some point of time i need to select top N rows from dataview which contains all the data. so is it possible to use select query in dataview? Thanks, Rachit Damani.
-
Thanks for your reply but how i could use select query in dataview? i don't need to select top N rows when i am fetching the data from the database but at some point of time i need to select top N rows from dataview which contains all the data. so is it possible to use select query in dataview? Thanks, Rachit Damani.
for this...you can loop thru the dataview to get the top n records Or better: Add a column on the datatable, set it's autoincrement value, include it in the rowfilter for the dataview Hope you get the idea << >>
-
for this...you can loop thru the dataview to get the top n records Or better: Add a column on the datatable, set it's autoincrement value, include it in the rowfilter for the dataview Hope you get the idea << >>
ya thanks, now i have understood what i need to do thanks a lot Rachit Damani.