----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: vbohra Message 1 in Discussion 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]
