XML Data Source
Posted: Tue May 29, 2012 2:57 am
Hello! Thank you again for the outstanding piece of software!
I have a question - there is an XML file I got from SQL request:
So here I have a DataSet with XML inside. How can I attach this XML to my report as DataSource?
I tried something like:
but it does not seem to work.
Any Ideas?
Thank you.
I have a question - there is an XML file I got from SQL request:
Code: Select all
DataTable dt = GetSomeDataTable();
foreach (DataRow dr in dt.Rows)
{
doc = new XmlDocument();
doc.LoadXml((string)dr["resxml"]);
ds = new DataSet();
ds.ReadXml(new XmlNodeReader(doc));
}
I tried something like:
Code: Select all
ds.Tables[0].TableName = "DataSource1";
report.DataSources.Clear();
report.RegData("DataSource1", ds.Tables[0]);
report.Dictionary.Synchronize();
Any Ideas?
Thank you.