By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

Sort Results Different is dataset and dataview

P: n/a
Rob
Hi
I have a dataset that is ordered by the primary key, but when I view it in a dataview with the sort propery filled in with the primary key, the order is different. The data that seems to cause the problem has a dash in it

The dataset records are in this order

bc-misc-label-rpt.exe
bc-MiscLabelPrint.exe
bc-printer-report.exe
bclabelprint.exe

The dataview records are in this order
bclabelprint.exe
bc-MiscLabelPrint.exe
bc-misc-label-rpt.exe
bc-printer-report.exe

Does anyone know what is causing this

I am displaying the dataview records in a datagrid, clicking on a record that I want, and using the dataview find function to retrieve the index to the dataset for the record I want to view/change in another form that is databound to the dataset, and since the order is different, I cannot rely on this function to get my index

Also
Is there a way to find an index to a dataset without going through all the records until you find a match? I know there is the findby function for datasets, but that returns a datarow, not the index

Thank

Nov 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.