public void LoadXMLGridEditor() { try { XmlSerializer serializer = new XmlSerializer(typeof(SPSActionGridConfig)); StringReader stringReader = new StringReader(txtGridXML.Text); _configGrid = (SPSActionGridConfig)serializer.Deserialize(stringReader); stringReader.Close(); pgGrid.SelectedObject = _configGrid; pgGrid.ExpandAllGridItems(); } catch (Exception ex) { Error("Invalid XML. " + ex.Message); } #region OLD CODE //TextReader stringReader = new StringReader(txtGridXML.Text); //_dataSetXMLGrid = new DataSet(); //Stream s = // Assembly.GetExecutingAssembly().GetManifestResourceStream( // "SPSProfessional.ActionDataBase.Generator.Schemas.ActionGridConfig.xsd"); //_dataSetXMLGrid.ReadXmlSchema(s); //XmlTextReader reader = new XmlTextReader(stringReader); //_dataSetXMLGrid.ReadXml(reader); //_dataSetXMLGrid.EnforceConstraints = true; //gridXMLGrid.DataSource = _dataSetXMLGrid.DefaultViewManager; //lstXMLGrid.Items.Clear(); //foreach (DataTable table in _dataSetXMLGrid.Tables) //{ // lstXMLGrid.Items.Add(table.TableName); //} #endregion }
private void mnuGetGridFromClipboard_Click(object sender, EventArgs e) { string XML = Clipboard.GetText(); try { XmlSerializer serializer = new XmlSerializer(typeof(SPSActionGridConfig)); StringReader stringReader = new StringReader(XML); _configGrid = (SPSActionGridConfig)serializer.Deserialize(stringReader); stringReader.Close(); pgGrid.SelectedObject = _configGrid; txtCommand.Text = _configGrid.Query.SelectCommand; Generator.GetGenerator().ConnectionString = _configGrid.DataBase.ConnectionString; FillTables(); pgGrid.ExpandAllGridItems(); Status("ActionDataBaseGrid configuration read sucessfully."); } catch (Exception ex) { Error("Invalid ActionDataBaseGrid XML. " + ex.Message); } }
/// <summary> /// Deserialize the configuration XML /// </summary> private void ReadConfig() { if (!string.IsNullOrEmpty(XmlConfig)) { try { XmlSerializer serializer = new XmlSerializer(typeof(SPSActionGridConfig)); StringReader stringReader = new StringReader(XmlConfig); _config = (SPSActionGridConfig)serializer.Deserialize(stringReader); stringReader.Close(); } catch (InvalidOperationException ex) { TrapSubsystemError(this, new SPSErrorArgs(Title, ex.Message, ex)); DumpException("ReadConfig", ex); } catch (Exception ex) { TrapSubsystemError(this, new SPSErrorArgs(Title, ex.Message, ex)); DumpException("ReadConfig", ex); } } }