private void loadSchemaToolStripMenuItem_Click(object sender, EventArgs e) { // DateTime start = DateTime.Now; //load schema OpenFileDialog dlg = new OpenFileDialog(); dlg.Title = "Open Pivot Table Schema file"; string s = GetFile("blue.appearance.xml"); s = s.Substring(0, s.LastIndexOf(@"\")); dlg.InitialDirectory = s; dlg.Filter = "Pivot Table Schema files (*.schema.xml)|*.schema.xml|All files (*.*)|*.*"; if (dlg.ShowDialog() == DialogResult.OK) { // start = DateTime.Now; Application.DoEvents();// let the dialog close before loading schema try { this.Cursor = Cursors.WaitCursor; PivotSchema schema = PivotSchema.LoadXML(dlg.FileName); pivotGridControl1.ApplySchema(schema); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Cursor = Cursors.Default; } } // this.Text = this.Text + " " + string.Format("Load time: {0} secs", ((TimeSpan)(DateTime.Now - start)).TotalSeconds); // Console.WriteLine(this.Text); }
private void saveSchemaToolStripMenuItem_Click(object sender, EventArgs e) { //save schema SaveFileDialog saveFile = new SaveFileDialog(); saveFile.FileName = "Untitled"; saveFile.DefaultExt = "*.schema.xml"; saveFile.Filter = "Pivot Table Schema files (*.schema.xml)|*.schema.xml|All files (*.*)|*.*"; // get a file name from the user if (saveFile.ShowDialog() == DialogResult.OK) { try { PivotSchema schema = pivotGridControl1.InitSchema(); schema.SaveXML(saveFile.FileName); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }