----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: saileshsaha Message 2 in Discussion Hi! One solution can be if you are using SQL Server. You can use the SQL Server using a command called OpenQuery. You can set up a linked provider to your AS2K session, whereby you can send qualified MDX as the query portion of OpenQuery call. Use the System.Data.SqlClient class in .NET for creating the connection, with the correct connection string, build your MDX query, create your adapter (you'll find many articles on using SQLCommand, etc online - http://www.dotnetjunkies.com, etc) and fill your Dataset. Note, you're going to get back a flattened rowset, of which you can do trick manipulations in displaying using templates, etc binding it in either a DataGrid or DataRepeater (my favorite for flexibility and speed). There are a couple of other means, but nothing quite as reliable *and* fast as OpenQuery through SQL. Hope this helps. Regards, Sailesh ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_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]
