string strCon;
DataSet ds = new DataSet();
XmlDataDocument xmlDataDoc;
strCon = "Server=10.100.3.248;initial catalog=IGS-SMP-WorkTest;User Id=WorkDeveloper;Password=developer;";
string selectText = "SELECT * FROM SMP_WorkItem";
SqlDataAdapter dataAdapter = new SqlDataAdapter(selectText, strCon);
try
{
dataAdapter.Fill(ds);
xmlDataDoc = new XmlDataDocument(ds);
using(XmlTextWriter writer = new XmlTextWriter("Your Report Location",System.Text.Encoding.UTF8))
{
xmlDataDoc.WriteTo(writer);
writer.Flush();
}
}
catch
{
xmlDataDoc = null;
}
finally
{
strCon = null;
ds.Dispose();
}
}