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);
}
}
}
