public void LoadXML(string filename)
{
DataSet ds = new DataSet();
//DataTable dt = new DataTable();
try
{
/*dt.TableName = "channel";
dt.Columns.Add("description");
dt.Columns.Add("link");
dt.Columns.Add("pubDate");
dt.Columns.Add("docs");
dt.Columns.Add("rating");
dt.Columns.Add("generator");
dt.ReadXml(filename);*/
ds.ReadXml(filename);
if (ds.Tables.Count > 2)
{
if (ds.Tables[1].Rows.Count > 0)
{
// get the info from the channel table
//System.Globalization.Calendar cal = System.Globalization.CultureInfo.CreateSpecificCulture("nl-NL").Calendar;
//System.Globalization.CultureInfo.CreateSpecificCulture("nl-NL").DateTimeFormat
m_LatestReleaseDate = StringToDateTime("en-US", ds.Tables[1].Rows[0]["pubDate"].ToString());
Console.WriteLine("Release date: " + m_LatestReleaseDate.ToString());
}
ds.Tables[2].Columns.Add("Date", System.Type.GetType("System.DateTime"));
foreach (DataRow dr in ds.Tables[2].Rows)
{
try
{
dr["Date"] = StringToDateTime("en-US", dr["pubDate"].ToString()).Date;
}
catch (Exception convE)
{
Console.WriteLine("Failed to convert datetime: " + convE.Message);
}
}
gridControl1.DataSource = ds.Tables[2];
//gridView1.SetMasterRowExpanded(0, true);
gridView1.ExpandAllGroups();
}
}
catch (Exception E)
{
Console.WriteLine(E.Message);
}
}