index > .NET Framework Data Access and Storage > how to create .xml file using SQL query (SQL Server 2000)

how to create .xml file using SQL query (SQL Server 2000)

i'm using a datawarehouse from which i need to pickup huge data and show it using a grid on a web page.

my thought is to create an .xml file suing SQL query and then create a dataset from the XML file and then bind it to a datagrid?

do any one have any better(best) approach for this?

phanikumarkvr

reply 1

You can use google to search for other answers

More Articles

• Dataset.Tables[0]?????

• Having problem with Fill() method

• Connecting SqlExpress from .net 1.1

• DataGridView vs DataGrid vs VB6 DataGrid

• ODBC TableAdapter Updating

• Problem looping over rows created within the same loop

• DataTable select problem!!!!!!!!!!!!!

• data objects and their limitations

• How to retrieve value from UDT column written using CLR Integrati...

• Read-only database problem after site installation

Welcome to Bokebb New Update

New Articles

• How to Pass in a SQL Decimal with Precis
• DataGridViewCellStyle Editor
• How To Easily Change Connection To Acces
• Urgent! Pls answer me. Database.
• Save SQL dataset to Access database
• Connection Pooling randomly throwing COM
• insert row into table with autoincrement
• Getting deleted child rows for a "S
• Data Sources Window
• Problem using SqlDataAdapter/Query builder
• Update Statement - Syntax Problem
• To clean pool of connections in ADO.NET
• Mapping Xsd element attributes to DataSet
• Optimizing data transfer and storage whe
• Dropdownlist Binding

Hot Articles

• Connecting to SQL Database using Enterpr
• Getting deleted child rows for a "S
• Iframe & SqlDataSource
• Cannot find stored procedure <storedp
• remote SQL server settings
• import / parse DIF files (Data Interchan
• TableAdapter Update problem
• Bug with DeriveParameters?
• GetChanges - Update - Merge result in re
• How to Manage Transactions
• Determine Primary Keys using SqlConnecti
• access sql server database with vb
• Simple Update from a VS 2005 vb project
• Connection Timeout
• Replace a Select Statement

Recommend Articles

• Build connection string like COM?
• ODbc Connection String to Excel
• Isolation.ReadUnCommitted Locking Proble
• parameter Array in Stored Procedure
• How to invoke a .asp file or .aspx file
• Client-side redirect problem
• Where to download interop.mapi.dll?
• How do I display the Connection string b
• Determination of Business Logic location
• Timeout expired. the timeout expired pri
• Where to store SQL server connection str
• The partner transaction manager has disa
• Referencing DLL's in the GAC
• -Using Sproc to insert rows in the DB an
• How do I change the location of "|D