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();
}
}
然后在Shared Data Source里指定生成的文件路径,Query String根据微软的说明,为空就可以了。
但是不能正确识别XML文件格式,参照向导生成的格式,缺少了很多元素。
