C#

Rob Philpott wrote:

but then apart from that you might want to look at the XSD tool which could generate business objects from the schema which you'll have to populate manually through code.

Pete O'Hanlon wrote:

Your choices are either to serialize your different objects out to a temporary location and then use Xslt to convert them

SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(@"cnnstring");
cmd.Connection.Open();
cmd.CommandText = "SELECT * FROM Table1; SELECT * FROM Table2";

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);

ds.WriteXmlSchema(@"C:\dat.xsd");
ds.WriteXml(@"C:\dat.xml");

cmd.Connection.Close();