----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: BusyWizy Message 3 in Discussion At 12:04 PM 18/07/2003, you wrote: Each DataTable has a DefaultView associated with it. The ApplyDefaultSort property of a dataview is true by default. because of this the dataview always gets sorted on the primary key (if available) even if u don;t do the sort yourself. i don;t know if this applies to your problem.... maybe it does. regards, nauzad kapadia [mvp] >Hi All, I have a SQL select query having 3 table joins. There is no >"order by" in that. when I run this query in MS SQL 2000 query analyser, I >get result in a perticular order. But when I run same using OLE DB, >ADO.NET from my component the order of result set changes. (I am taking it >in a DataTable and passing to ASPX page) When I add some records in one >of the table the order of result set changes again. But still it is >different in SQL and ADO.NET. Although I know that adding Order by >clause and modifying my logic a bit I can get away of this. But I want >to know what is the reasion behind this? Is there any property of Database >that SQL understand but ADO.NET don't? If yes what is that? And how to >manage that? Note: I haven't tried using SQL OLE DB provider, simply >because I can't use it in my application. thanks in advance, Vivek ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
