private DataTable ValuesTable(string sXml) { DataTable dt = null; try { if (!Sql.IsEmptyString(sXml)) { XmlDocument xml = new XmlDocument(); xml.LoadXml(sXml); dt = XmlUtil.CreateDataTable(xml.DocumentElement, "list", new string[] { "text", "value" }); } } catch { } return(dt); }
private void Page_Load(object sender, System.EventArgs e) { try { DataTable dt = Cache.Get("PublicSugarCRMLanguagePacks.xml") as DataTable; if (dt == null) { XmlDocument xml = new XmlDocument(); if (!IsPostBack) { try { #if DEBUG xml.Load(Server.MapPath("PublicSugarCRMLanguagePacks.xml")); #else xml.Load("http://demo.splendidcrm.com/Administration/Terminology/Import/PublicSugarCRMLanguagePacks.xml"); #endif } catch { xml.Load(Server.MapPath("PublicSugarCRMLanguagePacks.xml")); } } dt = XmlUtil.CreateDataTable(xml.DocumentElement, "LanguagePack", new string[] { "Name", "Date", "Description", "URL" }); Cache.Insert("PublicSugarCRMLanguagePacks.xml", dt, null, DateTime.Now.AddHours(1), System.Web.Caching.Cache.NoSlidingExpiration); } vwMain = new DataView(dt); vwMain.RowFilter = "URL > ''"; vwMain.Sort = "Name"; grdMain.DataSource = vwMain; if (!IsPostBack) { grdMain.DataBind(); } } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); lblError.Text = ex.Message; } }