How can I get table/column schema of a sql server database?  i want to
convert the entire schema into an xml file.
thanks in advance.

I am trying to retrieve XML created by ASP pages on different servers
and display them on a single ASP.Net page.
I was planning to use the XMLDocument and XMLResolver objects like
below:

Has anyone noticed that the xml in an app.config file is treated differently
than in a web.confg, or is it just me?
I have a component that parses and processes node fragments that are taken
from a .config file. When used in a .NET web app ( web.config ) the

Hi I wonder if anyone has any ideas about this...
I am dumping the contents of an XmlDocument into a RichTextBox so the
user can see the raw XML. I use a line of code something like this to
lado the Xml text into the textbox:

I am using SQXML3.0 SP2 with some code like this -
using(SqlConnection sqlCon=new
SqlConnection(G2P2DataObject.GetLocalDBConnectionString())) {
sqlCon.Open();

Reading in XML file, changing elements and saving back to the file,
how can i do that, I want to be able to read an XML file and read out
Elements. for example
<name>Tom</tom>

When using XmlSerializer is there anyway of keeping "xsi", "xsd" namespaces
and PI
appearing in the xml file ?
<?xml version="1.0"?>

I have an XSD file in a web directory in "C:\inetpub\wwwroot\xsd\Test.xsd".
This maps to http://localhost/xsd/Test.xsd. I have tried this URL in
Internet Explorer and the file loads fine.
I have opened an XML file in Visual Studio.NET 2003. I have added

I am doing some work with the XmlDocument class for loading and saving files
and I notice that the save call is writing out the empty element in the
following format <element /> - is this formatting possible to control? ie.
get it to write out <element></element>.

Does anyone know any good tools for performing a side by side comparison of
2 xml documents on an element by element and attribute by attribute basis.
Thanks
   Donal

i need to insert data from an xml file into sql server table.
the xml file contains only one record.
how to insert the data? how to map the names of the fields in the xml file
and the table?

how can my code determine the exact line and column of an XmlNode if I need
to generate and error for that node?