Apply the filter when you fill the DataSet or DataTable from XML and use it directly, so that you avoid filtering on DataTable (using DataTable.Select)
On Thu, Jun 17, 2010 at 2:33 PM, Troy International <[email protected]>wrote: > hi.. previous i used to query on DB so as it takes some time so i just pass > the DB recrod to XML file so from the xml i am going to get the Dataset or > Datatable - from that i filter the data. > > So why if the Datatable contains 500 or more records , while filtering the > data it doesn't get the value it shows null is this bug ...... ??? or how to > solve this issue.. > > > On Wed, Jun 16, 2010 at 7:08 PM, Stephen Russell <[email protected]>wrote: > >> On Wed, Jun 16, 2010 at 8:15 AM, Troy International <[email protected]> >> wrote: >> > hi its working on local ..and also i checked by having 500 rows on your >> > Datatable , and use select whether you getting the value or not .. for >> me >> > the dr shows 0 >> > >> > I checked on local ie: if the data in the Datatable has limited record >> i: >> > 340 or something , i am getting the value at dr but if there is more >> than >> > 800 records the dr shows 0 value.. >> > >> > I do no why ? >> --------------------------------- >> >> Considering that this array is to be used for a drop down list. If >> you have 300 items are you already over the point of useful? I know >> you can "present" it but can a user consume it? >> >> Can you do a dataview from the dt? >> >> -- >> Stephen Russell >> >> Sr. Production Systems Programmer >> CIMSgts >> >> 901.246-0159 cell >> > >
