Thanks for the response Jon!

Hi all: I have inherited a web application that's used for reporting. Each report has three main sections: Input section where the users select dates and other info, Summary screen where a summary of the data is shown, and a Detail screen where detailed data is shown. I don't think it makes sense to create a new Input, Summary, and Detail page when a user asks for a new report. Too much duplication! Is there a pattern I can use to simplify this? Let me know if you need more details. Thanks! Nick

I Googled this issue earlier and that site came up. Just thought I'd take the easy way out hoping someone has tried the exact same thing as myself. Thanks for responses led mike!

led mike wrote:

I'm assuming you mean inserting the SQL String as text into an XML TextNode yes?

No. The posted query is what I use to get the locations from SQL. I want to export the location list to XML and read the XML with .NET. The query is actually being ran in Query Analyzer.

Hi everyone: I'm having trouble exporting the follow query to XML in a valid format. For some reason it wraps in the middle of a few elements causing .NET to say the end tag is missing. I'm using SQL '05 and when I show the query results in text the same exact thing happens. Is it possible for to "Export to File" from within Management Studio and specify the format? SELECT DISTINCT origin_location AS location FROM famis_locations WHERE origin_location <> '' ORDER BY origin_location FOR XML AUTO, ELEMENTS Thanks!

You're right Guffa. It works now, thanks!

Hi Tom: It's this line: --------------------- grid.DataSource = ds --------------------- I don't understand how the dataset could be blank. The file I'm pointing to in the ReadXML method has data in it.

Hi All: I'm trying to dynamically create a datagrid and fill it with XML data. But I get an "Object reference not set to an instance of an object." error when running it. See the code below. What am I missing? Public Sub CreateDynamicGrid() Dim ds As New DataSet Dim grid As System.Web.UI.WebControls.DataGrid Try 'Place the XML information into a dataset ds.ReadXml("C:\Temp\test.xml") 'The dataset is used as the data source for our newly created datatrid grid grid.DataSource = ds grid.DataBind() 'grid is added to the PlaceHolder PlaceHolder.Controls.Add(grid) Catch ex As Exception Response.Write(ex.Message.ToString) End Try End Sub Thanks in advance!