コード例 #1
0
ファイル: Form1.cs プロジェクト: e-iceblue/Spire.DataExport
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			this.accessExport1 = new Spire.DataExport.Access.AccessExport();
			this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
			this.cellExport1 = new Spire.DataExport.XLS.CellExport();
			this.clipboardExport1 = new Spire.DataExport.Clipboard.ClipboardExport();
			this.dbfExport1 = new Spire.DataExport.DBF.DBFExport();
			this.htmlExport1 = new Spire.DataExport.HTML.HTMLExport();
			this.pdfExport1 = new Spire.DataExport.PDF.PDFExport();
			this.rtfExport1 = new Spire.DataExport.RTF.RTFExport();
			this.sqlExport1 = new Spire.DataExport.SQL.SQLExport();
			this.xmlExport1 = new Spire.DataExport.XML.XMLExport();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.button2 = new System.Windows.Forms.Button();
			this.txtCommandText = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.txtConnectString = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.rbnSYLK = new System.Windows.Forms.RadioButton();
			this.rbnDIF = new System.Windows.Forms.RadioButton();
			this.rbnCSV = new System.Windows.Forms.RadioButton();
			this.rbnXLS = new System.Windows.Forms.RadioButton();
			this.rbnHtml = new System.Windows.Forms.RadioButton();
			this.rbnPdf = new System.Windows.Forms.RadioButton();
			this.rbnRtf = new System.Windows.Forms.RadioButton();
			this.rbnClipboard = new System.Windows.Forms.RadioButton();
			this.rbnDbf = new System.Windows.Forms.RadioButton();
			this.rbnAccess = new System.Windows.Forms.RadioButton();
			this.rbnXml = new System.Windows.Forms.RadioButton();
			this.rbnSql = new System.Windows.Forms.RadioButton();
			this.radioButton1 = new System.Windows.Forms.RadioButton();
			this.dgDetail = new System.Windows.Forms.DataGrid();
			this.btnRun = new System.Windows.Forms.Button();
			this.btnAbout = new System.Windows.Forms.Button();
			this.txtExport1 = new Spire.DataExport.TXT.TXTExport();
			this.txtExport2 = new Spire.DataExport.TXT.TXTExport();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgDetail)).BeginInit();
			this.SuspendLayout();
			//
			// accessExport1
			//
			this.accessExport1.DatabaseName = "test.mdb";
			this.accessExport1.DataFormats.CultureName = "zh-CN";
			this.accessExport1.DataFormats.Currency = "c";
			this.accessExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.accessExport1.DataFormats.Float = "g";
			this.accessExport1.DataFormats.Integer = "g";
			this.accessExport1.DataFormats.Time = "H:mm";
			this.accessExport1.SQLCommand = this.oleDbCommand1;
			this.accessExport1.TableName = "ExportData";
			//
			// oleDbCommand1
			//
			this.oleDbCommand1.CommandText = "select * from parts";
			this.oleDbCommand1.Connection = this.oleDbConnection1;
			//
			// oleDbConnection1
			//
			this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source="".\..\database\demo.mdb"";Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
			//
			// cellExport1
			//
			this.cellExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.cellExport1.AutoFitColWidth = true;
			this.cellExport1.DataFormats.CultureName = "zh-CN";
			this.cellExport1.DataFormats.Currency = "гд#,###,##0.00";
			this.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.cellExport1.DataFormats.Float = "#,###,##0.00";
			this.cellExport1.DataFormats.Integer = "#,###,##0";
			this.cellExport1.DataFormats.Time = "H:mm";
			this.cellExport1.FileName = "sample.xls";
			this.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.DefaultFont.Name = "Arial";
			this.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
			this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
			this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
			this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
			this.cellExport1.SheetOptions.NoteFormat.Font.Bold = true;
			this.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma";
			this.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F;
			this.cellExport1.SheetOptions.TitlesFormat.Font.Bold = true;
			this.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial";
			this.cellExport1.SQLCommand = this.oleDbCommand1;
			//
			// clipboardExport1
			//
			this.clipboardExport1.DataFormats.CultureName = "zh-CN";
			this.clipboardExport1.DataFormats.Currency = "c";
			this.clipboardExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.clipboardExport1.DataFormats.Float = "g";
			this.clipboardExport1.DataFormats.Integer = "g";
			this.clipboardExport1.DataFormats.Time = "H:mm";
			this.clipboardExport1.ShowContent = true;
			this.clipboardExport1.SQLCommand = this.oleDbCommand1;
			//
			// dbfExport1
			//
			this.dbfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.dbfExport1.FileName = "sample.dbf";
			this.dbfExport1.SQLCommand = this.oleDbCommand1;
			//
			// htmlExport1
			//
			this.htmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.htmlExport1.DataFormats.CultureName = "zh-CN";
			this.htmlExport1.DataFormats.Currency = "c";
			this.htmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.htmlExport1.DataFormats.Float = "g";
			this.htmlExport1.DataFormats.Integer = "g";
			this.htmlExport1.DataFormats.Time = "H:mm";
			this.htmlExport1.FileName = "sample.html";
			this.htmlExport1.HtmlStyle = Spire.DataExport.HTML.HtmlStyle.MSMoney;
			this.htmlExport1.HtmlTableOptions.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(222)), ((System.Byte)(231)), ((System.Byte)(222)));
			this.htmlExport1.HtmlTableOptions.FontColor = System.Drawing.Color.Black;
			this.htmlExport1.HtmlTableOptions.HeadersBackColor = System.Drawing.Color.FromArgb(((System.Byte)(206)), ((System.Byte)(198)), ((System.Byte)(181)));
			this.htmlExport1.HtmlTableOptions.HeadersFontColor = System.Drawing.Color.Black;
			this.htmlExport1.HtmlTableOptions.OddBackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(251)), ((System.Byte)(240)));
			this.htmlExport1.HtmlTextOptions.BackgroundColor = System.Drawing.Color.White;
			this.htmlExport1.HtmlTextOptions.Font = new System.Drawing.Font("Arial", 8F);
			this.htmlExport1.HtmlTextOptions.LinkActiveColor = System.Drawing.Color.Blue;
			this.htmlExport1.HtmlTextOptions.LinkColor = System.Drawing.Color.Red;
			this.htmlExport1.HtmlTextOptions.LinkVisitedColor = System.Drawing.Color.Purple;
			this.htmlExport1.SQLCommand = this.oleDbCommand1;
			//
			// pdfExport1
			//
			this.pdfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.pdfExport1.DataFormats.CultureName = "zh-CN";
			this.pdfExport1.DataFormats.Currency = "c";
			this.pdfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.pdfExport1.DataFormats.Float = "g";
			this.pdfExport1.DataFormats.Integer = "g";
			this.pdfExport1.DataFormats.Time = "H:mm";
			this.pdfExport1.FileName = "sample.pdf";
			this.pdfExport1.PDFOptions.PageOptions.Format = Spire.DataExport.PDF.PageFormat.User;
			this.pdfExport1.PDFOptions.PageOptions.Height = 11.67;
			this.pdfExport1.PDFOptions.PageOptions.MarginBottom = 0.78;
			this.pdfExport1.PDFOptions.PageOptions.MarginLeft = 1.17;
			this.pdfExport1.PDFOptions.PageOptions.MarginRight = 0.57;
			this.pdfExport1.PDFOptions.PageOptions.MarginTop = 0.78;
			this.pdfExport1.PDFOptions.PageOptions.Width = 8.25;
			this.pdfExport1.SQLCommand = this.oleDbCommand1;
			//
			// rtfExport1
			//
			this.rtfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.rtfExport1.DataFormats.CultureName = "zh-CN";
			this.rtfExport1.DataFormats.Currency = "c";
			this.rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.rtfExport1.DataFormats.Float = "g";
			this.rtfExport1.DataFormats.Integer = "g";
			this.rtfExport1.DataFormats.Time = "H:mm";
			this.rtfExport1.FileName = "sample.doc";
			this.rtfExport1.RTFOptions.DataStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
			this.rtfExport1.RTFOptions.FooterStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
			this.rtfExport1.RTFOptions.HeaderStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
			this.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center;
			this.rtfExport1.RTFOptions.TitleStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
			this.rtfExport1.SQLCommand = this.oleDbCommand1;
			//
			// sqlExport1
			//
			this.sqlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.sqlExport1.CommitStatement = "COMMIT;";
			this.sqlExport1.DataFormats.CultureName = "zh-CN";
			this.sqlExport1.DataFormats.Currency = "c";
			this.sqlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.sqlExport1.DataFormats.Float = "g";
			this.sqlExport1.DataFormats.Integer = "g";
			this.sqlExport1.DataFormats.Time = "H:mm";
			this.sqlExport1.FileName = "sample.sql";
			this.sqlExport1.SQLCommand = this.oleDbCommand1;
			this.sqlExport1.TableName = "TestTable";
			//
			// xmlExport1
			//
			this.xmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.xmlExport1.DataFormats.CultureName = "zh-CN";
			this.xmlExport1.DataFormats.Currency = "c";
			this.xmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.xmlExport1.DataFormats.Float = "g";
			this.xmlExport1.DataFormats.Integer = "g";
			this.xmlExport1.DataFormats.Time = "H:mm";
			this.xmlExport1.FileName = "sample.xml";
			this.xmlExport1.SQLCommand = this.oleDbCommand1;
			//
			// groupBox1
			//
			this.groupBox1.Controls.Add(this.button2);
			this.groupBox1.Controls.Add(this.txtCommandText);
			this.groupBox1.Controls.Add(this.label2);
			this.groupBox1.Controls.Add(this.txtConnectString);
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.Location = new System.Drawing.Point(16, 13);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(312, 155);
			this.groupBox1.TabIndex = 0;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = " Data source ";
			//
			// button2
			//
			this.button2.Location = new System.Drawing.Point(232, 125);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(64, 23);
			this.button2.TabIndex = 5;
			this.button2.Text = "Load";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			//
			// txtCommandText
			//
			this.txtCommandText.Location = new System.Drawing.Point(17, 95);
			this.txtCommandText.Name = "txtCommandText";
			this.txtCommandText.Size = new System.Drawing.Size(279, 21);
			this.txtCommandText.TabIndex = 3;
			this.txtCommandText.Text = "select * from parts";
			//
			// label2
			//
			this.label2.Location = new System.Drawing.Point(16, 75);
			this.label2.Name = "label2";
			this.label2.TabIndex = 2;
			this.label2.Text = "Command Text:";
			//
			// txtConnectString
			//
			this.txtConnectString.Location = new System.Drawing.Point(16, 43);
			this.txtConnectString.Name = "txtConnectString";
			this.txtConnectString.Size = new System.Drawing.Size(280, 21);
			this.txtConnectString.TabIndex = 1;
			this.txtConnectString.Text = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\\\..\\\\..\\\\..\\\\database\\\\demo.mdb";
			//
			// label1
			//
			this.label1.Location = new System.Drawing.Point(15, 23);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(121, 16);
			this.label1.TabIndex = 0;
			this.label1.Text = "Connection string:";
			//
			// groupBox2
			//
			this.groupBox2.Controls.Add(this.rbnSYLK);
			this.groupBox2.Controls.Add(this.rbnDIF);
			this.groupBox2.Controls.Add(this.rbnCSV);
			this.groupBox2.Controls.Add(this.rbnXLS);
			this.groupBox2.Controls.Add(this.rbnHtml);
			this.groupBox2.Controls.Add(this.rbnPdf);
			this.groupBox2.Controls.Add(this.rbnRtf);
			this.groupBox2.Controls.Add(this.rbnClipboard);
			this.groupBox2.Controls.Add(this.rbnDbf);
			this.groupBox2.Controls.Add(this.rbnAccess);
			this.groupBox2.Controls.Add(this.rbnXml);
			this.groupBox2.Controls.Add(this.rbnSql);
			this.groupBox2.Controls.Add(this.radioButton1);
			this.groupBox2.Location = new System.Drawing.Point(336, 12);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(264, 240);
			this.groupBox2.TabIndex = 1;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = " Export file format ";
			//
			// rbnSYLK
			//
			this.rbnSYLK.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnSYLK.Location = new System.Drawing.Point(152, 144);
			this.rbnSYLK.Name = "rbnSYLK";
			this.rbnSYLK.Size = new System.Drawing.Size(96, 26);
			this.rbnSYLK.TabIndex = 10;
			this.rbnSYLK.Tag = "10";
			this.rbnSYLK.Text = " SYLK";
			this.rbnSYLK.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnDIF
			//
			this.rbnDIF.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnDIF.Location = new System.Drawing.Point(152, 176);
			this.rbnDIF.Name = "rbnDIF";
			this.rbnDIF.Size = new System.Drawing.Size(96, 26);
			this.rbnDIF.TabIndex = 9;
			this.rbnDIF.Tag = "12";
			this.rbnDIF.Text = " DIF";
			this.rbnDIF.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnCSV
			//
			this.rbnCSV.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnCSV.Location = new System.Drawing.Point(24, 176);
			this.rbnCSV.Name = "rbnCSV";
			this.rbnCSV.Size = new System.Drawing.Size(96, 26);
			this.rbnCSV.TabIndex = 8;
			this.rbnCSV.Tag = "11";
			this.rbnCSV.Text = " CSV";
			this.rbnCSV.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnXLS
			//
			this.rbnXLS.Checked = true;
			this.rbnXLS.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnXLS.Location = new System.Drawing.Point(24, 16);
			this.rbnXLS.Name = "rbnXLS";
			this.rbnXLS.TabIndex = 0;
			this.rbnXLS.TabStop = true;
			this.rbnXLS.Tag = "1";
			this.rbnXLS.Text = " XLS";
			this.rbnXLS.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnHtml
			//
			this.rbnHtml.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnHtml.Location = new System.Drawing.Point(152, 16);
			this.rbnHtml.Name = "rbnHtml";
			this.rbnHtml.TabIndex = 0;
			this.rbnHtml.Tag = "2";
			this.rbnHtml.Text = " HTML";
			this.rbnHtml.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnPdf
			//
			this.rbnPdf.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnPdf.Location = new System.Drawing.Point(24, 48);
			this.rbnPdf.Name = "rbnPdf";
			this.rbnPdf.TabIndex = 0;
			this.rbnPdf.Tag = "3";
			this.rbnPdf.Text = " PDF";
			this.rbnPdf.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnRtf
			//
			this.rbnRtf.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnRtf.Location = new System.Drawing.Point(152, 48);
			this.rbnRtf.Name = "rbnRtf";
			this.rbnRtf.TabIndex = 0;
			this.rbnRtf.Tag = "4";
			this.rbnRtf.Text = " RTF";
			this.rbnRtf.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnClipboard
			//
			this.rbnClipboard.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnClipboard.Location = new System.Drawing.Point(24, 80);
			this.rbnClipboard.Name = "rbnClipboard";
			this.rbnClipboard.TabIndex = 0;
			this.rbnClipboard.Tag = "5";
			this.rbnClipboard.Text = " Clipboard";
			this.rbnClipboard.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnDbf
			//
			this.rbnDbf.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnDbf.Location = new System.Drawing.Point(152, 80);
			this.rbnDbf.Name = "rbnDbf";
			this.rbnDbf.TabIndex = 0;
			this.rbnDbf.Tag = "6";
			this.rbnDbf.Text = " DBF";
			this.rbnDbf.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnAccess
			//
			this.rbnAccess.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnAccess.Location = new System.Drawing.Point(24, 112);
			this.rbnAccess.Name = "rbnAccess";
			this.rbnAccess.TabIndex = 0;
			this.rbnAccess.Tag = "7";
			this.rbnAccess.Text = " MS Access";
			this.rbnAccess.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnXml
			//
			this.rbnXml.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnXml.Location = new System.Drawing.Point(152, 112);
			this.rbnXml.Name = "rbnXml";
			this.rbnXml.TabIndex = 0;
			this.rbnXml.Tag = "8";
			this.rbnXml.Text = " XML";
			this.rbnXml.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// rbnSql
			//
			this.rbnSql.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.rbnSql.Location = new System.Drawing.Point(24, 144);
			this.rbnSql.Name = "rbnSql";
			this.rbnSql.TabIndex = 0;
			this.rbnSql.Tag = "9";
			this.rbnSql.Text = " SQL Script";
			this.rbnSql.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// radioButton1
			//
			this.radioButton1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.radioButton1.Location = new System.Drawing.Point(24, 208);
			this.radioButton1.Name = "radioButton1";
			this.radioButton1.Size = new System.Drawing.Size(96, 26);
			this.radioButton1.TabIndex = 8;
			this.radioButton1.Tag = "13";
			this.radioButton1.Text = " Text";
			this.radioButton1.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
			//
			// dgDetail
			//
			this.dgDetail.DataMember = "";
			this.dgDetail.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dgDetail.Location = new System.Drawing.Point(16, 264);
			this.dgDetail.Name = "dgDetail";
			this.dgDetail.Size = new System.Drawing.Size(584, 128);
			this.dgDetail.TabIndex = 0;
			//
			// btnRun
			//
			this.btnRun.Location = new System.Drawing.Point(432, 408);
			this.btnRun.Name = "btnRun";
			this.btnRun.TabIndex = 2;
			this.btnRun.Text = "Run";
			this.btnRun.Click += new System.EventHandler(this.btnRun_Click);
			//
			// btnAbout
			//
			this.btnAbout.Location = new System.Drawing.Point(520, 408);
			this.btnAbout.Name = "btnAbout";
			this.btnAbout.TabIndex = 3;
			this.btnAbout.Text = "Close";
			this.btnAbout.Click += new System.EventHandler(this.btnAbout_Click);
			//
			// txtExport1
			//
			this.txtExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
			this.txtExport1.DataFormats.CultureName = "zh-CN";
			this.txtExport1.DataFormats.Currency = "c";
			this.txtExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.txtExport1.DataFormats.Float = "g";
			this.txtExport1.DataFormats.Integer = "g";
			this.txtExport1.DataFormats.Time = "H:mm";
            this.txtExport1.DataEncoding = Spire.DataExport.Common.EncodingType.ASCII;
			this.txtExport1.SQLCommand = this.oleDbCommand1;
			//
			// txtExport2
			//
			this.txtExport2.DataFormats.CultureName = "zh-CN";
			this.txtExport2.DataFormats.Currency = "c";
			this.txtExport2.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.txtExport2.DataFormats.Float = "g";
			this.txtExport2.DataFormats.Integer = "g";
			this.txtExport2.DataFormats.Time = "H:mm";
			//
			// Form1
			//
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(616, 438);
			this.Controls.Add(this.btnAbout);
			this.Controls.Add(this.btnRun);
			this.Controls.Add(this.dgDetail);
			this.Controls.Add(this.groupBox2);
			this.Controls.Add(this.groupBox1);
			this.Name = "Form1";
			this.Text = "Sample";
			this.Load += new System.EventHandler(this.Form1_Load);
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dgDetail)).EndInit();
			this.ResumeLayout(false);

		}
コード例 #2
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.accessExport1    = new Spire.DataExport.Access.AccessExport();
     this.oleDbCommand1    = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.cellExport1      = new Spire.DataExport.XLS.CellExport();
     this.clipboardExport1 = new Spire.DataExport.Clipboard.ClipboardExport();
     this.dbfExport1       = new Spire.DataExport.DBF.DBFExport();
     this.htmlExport1      = new Spire.DataExport.HTML.HTMLExport();
     this.pdfExport1       = new Spire.DataExport.PDF.PDFExport();
     this.rtfExport1       = new Spire.DataExport.RTF.RTFExport();
     this.sqlExport1       = new Spire.DataExport.SQL.SQLExport();
     this.xmlExport1       = new Spire.DataExport.XML.XMLExport();
     this.groupBox1        = new System.Windows.Forms.GroupBox();
     this.button2          = new System.Windows.Forms.Button();
     this.txtCommandText   = new System.Windows.Forms.TextBox();
     this.label2           = new System.Windows.Forms.Label();
     this.txtConnectString = new System.Windows.Forms.TextBox();
     this.label1           = new System.Windows.Forms.Label();
     this.groupBox2        = new System.Windows.Forms.GroupBox();
     this.rbnSYLK          = new System.Windows.Forms.RadioButton();
     this.rbnDIF           = new System.Windows.Forms.RadioButton();
     this.rbnCSV           = new System.Windows.Forms.RadioButton();
     this.rbnXLS           = new System.Windows.Forms.RadioButton();
     this.rbnHtml          = new System.Windows.Forms.RadioButton();
     this.rbnPdf           = new System.Windows.Forms.RadioButton();
     this.rbnRtf           = new System.Windows.Forms.RadioButton();
     this.rbnClipboard     = new System.Windows.Forms.RadioButton();
     this.rbnDbf           = new System.Windows.Forms.RadioButton();
     this.rbnAccess        = new System.Windows.Forms.RadioButton();
     this.rbnXml           = new System.Windows.Forms.RadioButton();
     this.rbnSql           = new System.Windows.Forms.RadioButton();
     this.radioButton1     = new System.Windows.Forms.RadioButton();
     this.dgDetail         = new System.Windows.Forms.DataGrid();
     this.btnRun           = new System.Windows.Forms.Button();
     this.btnAbout         = new System.Windows.Forms.Button();
     this.txtExport1       = new Spire.DataExport.TXT.TXTExport();
     this.txtExport2       = new Spire.DataExport.TXT.TXTExport();
     this.groupBox1.SuspendLayout();
     this.groupBox2.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.dgDetail)).BeginInit();
     this.SuspendLayout();
     //
     // accessExport1
     //
     this.accessExport1.DatabaseName            = "test.mdb";
     this.accessExport1.DataFormats.CultureName = "zh-CN";
     this.accessExport1.DataFormats.Currency    = "c";
     this.accessExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.accessExport1.DataFormats.Float       = "g";
     this.accessExport1.DataFormats.Integer     = "g";
     this.accessExport1.DataFormats.Time        = "H:mm";
     this.accessExport1.SQLCommand = this.oleDbCommand1;
     this.accessExport1.TableName  = "ExportData";
     //
     // oleDbCommand1
     //
     this.oleDbCommand1.CommandText = "select * from parts";
     this.oleDbCommand1.Connection  = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source="".\..\database\demo.mdb"";Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
     //
     // cellExport1
     //
     this.cellExport1.ActionAfterExport       = Spire.DataExport.Common.ActionType.OpenView;
     this.cellExport1.AutoFitColWidth         = true;
     this.cellExport1.DataFormats.CultureName = "zh-CN";
     this.cellExport1.DataFormats.Currency    = "гд#,###,##0.00";
     this.cellExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.cellExport1.DataFormats.Float       = "#,###,##0.00";
     this.cellExport1.DataFormats.Integer     = "#,###,##0";
     this.cellExport1.DataFormats.Time        = "H:mm";
     this.cellExport1.FileName = "sample.xls";
     this.cellExport1.SheetOptions.AggregateFormat.Font.Name       = "Arial";
     this.cellExport1.SheetOptions.CustomDataFormat.Font.Name      = "Arial";
     this.cellExport1.SheetOptions.DefaultFont.Name                = "Arial";
     this.cellExport1.SheetOptions.FooterFormat.Font.Name          = "Arial";
     this.cellExport1.SheetOptions.HeaderFormat.Font.Name          = "Arial";
     this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color      = Spire.DataExport.XLS.CellColor.Blue;
     this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name       = "Arial";
     this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline  = Spire.DataExport.XLS.XlsFontUnderline.Single;
     this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
     this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical   = Spire.DataExport.XLS.VerticalAlignment.Top;
     this.cellExport1.SheetOptions.NoteFormat.Font.Bold            = true;
     this.cellExport1.SheetOptions.NoteFormat.Font.Name            = "Tahoma";
     this.cellExport1.SheetOptions.NoteFormat.Font.Size            = 8F;
     this.cellExport1.SheetOptions.TitlesFormat.Font.Bold          = true;
     this.cellExport1.SheetOptions.TitlesFormat.Font.Name          = "Arial";
     this.cellExport1.SQLCommand = this.oleDbCommand1;
     //
     // clipboardExport1
     //
     this.clipboardExport1.DataFormats.CultureName = "zh-CN";
     this.clipboardExport1.DataFormats.Currency    = "c";
     this.clipboardExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.clipboardExport1.DataFormats.Float       = "g";
     this.clipboardExport1.DataFormats.Integer     = "g";
     this.clipboardExport1.DataFormats.Time        = "H:mm";
     this.clipboardExport1.ShowContent             = true;
     this.clipboardExport1.SQLCommand = this.oleDbCommand1;
     //
     // dbfExport1
     //
     this.dbfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
     this.dbfExport1.FileName          = "sample.dbf";
     this.dbfExport1.SQLCommand        = this.oleDbCommand1;
     //
     // htmlExport1
     //
     this.htmlExport1.ActionAfterExport       = Spire.DataExport.Common.ActionType.OpenView;
     this.htmlExport1.DataFormats.CultureName = "zh-CN";
     this.htmlExport1.DataFormats.Currency    = "c";
     this.htmlExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.htmlExport1.DataFormats.Float       = "g";
     this.htmlExport1.DataFormats.Integer     = "g";
     this.htmlExport1.DataFormats.Time        = "H:mm";
     this.htmlExport1.FileName  = "sample.html";
     this.htmlExport1.HtmlStyle = Spire.DataExport.HTML.HtmlStyle.MSMoney;
     this.htmlExport1.HtmlTableOptions.BackColor        = System.Drawing.Color.FromArgb(((System.Byte)(222)), ((System.Byte)(231)), ((System.Byte)(222)));
     this.htmlExport1.HtmlTableOptions.FontColor        = System.Drawing.Color.Black;
     this.htmlExport1.HtmlTableOptions.HeadersBackColor = System.Drawing.Color.FromArgb(((System.Byte)(206)), ((System.Byte)(198)), ((System.Byte)(181)));
     this.htmlExport1.HtmlTableOptions.HeadersFontColor = System.Drawing.Color.Black;
     this.htmlExport1.HtmlTableOptions.OddBackColor     = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(251)), ((System.Byte)(240)));
     this.htmlExport1.HtmlTextOptions.BackgroundColor   = System.Drawing.Color.White;
     this.htmlExport1.HtmlTextOptions.Font             = new System.Drawing.Font("Arial", 8F);
     this.htmlExport1.HtmlTextOptions.LinkActiveColor  = System.Drawing.Color.Blue;
     this.htmlExport1.HtmlTextOptions.LinkColor        = System.Drawing.Color.Red;
     this.htmlExport1.HtmlTextOptions.LinkVisitedColor = System.Drawing.Color.Purple;
     this.htmlExport1.SQLCommand = this.oleDbCommand1;
     //
     // pdfExport1
     //
     this.pdfExport1.ActionAfterExport       = Spire.DataExport.Common.ActionType.OpenView;
     this.pdfExport1.DataFormats.CultureName = "zh-CN";
     this.pdfExport1.DataFormats.Currency    = "c";
     this.pdfExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.pdfExport1.DataFormats.Float       = "g";
     this.pdfExport1.DataFormats.Integer     = "g";
     this.pdfExport1.DataFormats.Time        = "H:mm";
     this.pdfExport1.FileName = "sample.pdf";
     this.pdfExport1.PDFOptions.PageOptions.Format       = Spire.DataExport.PDF.PageFormat.User;
     this.pdfExport1.PDFOptions.PageOptions.Height       = 11.67;
     this.pdfExport1.PDFOptions.PageOptions.MarginBottom = 0.78;
     this.pdfExport1.PDFOptions.PageOptions.MarginLeft   = 1.17;
     this.pdfExport1.PDFOptions.PageOptions.MarginRight  = 0.57;
     this.pdfExport1.PDFOptions.PageOptions.MarginTop    = 0.78;
     this.pdfExport1.PDFOptions.PageOptions.Width        = 8.25;
     this.pdfExport1.SQLCommand = this.oleDbCommand1;
     //
     // rtfExport1
     //
     this.rtfExport1.ActionAfterExport       = Spire.DataExport.Common.ActionType.OpenView;
     this.rtfExport1.DataFormats.CultureName = "zh-CN";
     this.rtfExport1.DataFormats.Currency    = "c";
     this.rtfExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.rtfExport1.DataFormats.Float       = "g";
     this.rtfExport1.DataFormats.Integer     = "g";
     this.rtfExport1.DataFormats.Time        = "H:mm";
     this.rtfExport1.FileName = "sample.doc";
     this.rtfExport1.RTFOptions.DataStyle.Font       = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
     this.rtfExport1.RTFOptions.FooterStyle.Font     = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
     this.rtfExport1.RTFOptions.HeaderStyle.Font     = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
     this.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center;
     this.rtfExport1.RTFOptions.TitleStyle.Font      = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
     this.rtfExport1.SQLCommand = this.oleDbCommand1;
     //
     // sqlExport1
     //
     this.sqlExport1.ActionAfterExport       = Spire.DataExport.Common.ActionType.OpenView;
     this.sqlExport1.CommitStatement         = "COMMIT;";
     this.sqlExport1.DataFormats.CultureName = "zh-CN";
     this.sqlExport1.DataFormats.Currency    = "c";
     this.sqlExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.sqlExport1.DataFormats.Float       = "g";
     this.sqlExport1.DataFormats.Integer     = "g";
     this.sqlExport1.DataFormats.Time        = "H:mm";
     this.sqlExport1.FileName   = "sample.sql";
     this.sqlExport1.SQLCommand = this.oleDbCommand1;
     this.sqlExport1.TableName  = "TestTable";
     //
     // xmlExport1
     //
     this.xmlExport1.ActionAfterExport       = Spire.DataExport.Common.ActionType.OpenView;
     this.xmlExport1.DataFormats.CultureName = "zh-CN";
     this.xmlExport1.DataFormats.Currency    = "c";
     this.xmlExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.xmlExport1.DataFormats.Float       = "g";
     this.xmlExport1.DataFormats.Integer     = "g";
     this.xmlExport1.DataFormats.Time        = "H:mm";
     this.xmlExport1.FileName   = "sample.xml";
     this.xmlExport1.SQLCommand = this.oleDbCommand1;
     //
     // groupBox1
     //
     this.groupBox1.Controls.Add(this.button2);
     this.groupBox1.Controls.Add(this.txtCommandText);
     this.groupBox1.Controls.Add(this.label2);
     this.groupBox1.Controls.Add(this.txtConnectString);
     this.groupBox1.Controls.Add(this.label1);
     this.groupBox1.Location = new System.Drawing.Point(16, 13);
     this.groupBox1.Name     = "groupBox1";
     this.groupBox1.Size     = new System.Drawing.Size(312, 155);
     this.groupBox1.TabIndex = 0;
     this.groupBox1.TabStop  = false;
     this.groupBox1.Text     = " Data source ";
     //
     // button2
     //
     this.button2.Location = new System.Drawing.Point(232, 125);
     this.button2.Name     = "button2";
     this.button2.Size     = new System.Drawing.Size(64, 23);
     this.button2.TabIndex = 5;
     this.button2.Text     = "Load";
     this.button2.Click   += new System.EventHandler(this.button2_Click);
     //
     // txtCommandText
     //
     this.txtCommandText.Location = new System.Drawing.Point(17, 95);
     this.txtCommandText.Name     = "txtCommandText";
     this.txtCommandText.Size     = new System.Drawing.Size(279, 21);
     this.txtCommandText.TabIndex = 3;
     this.txtCommandText.Text     = "select * from parts";
     //
     // label2
     //
     this.label2.Location = new System.Drawing.Point(16, 75);
     this.label2.Name     = "label2";
     this.label2.TabIndex = 2;
     this.label2.Text     = "Command Text:";
     //
     // txtConnectString
     //
     this.txtConnectString.Location = new System.Drawing.Point(16, 43);
     this.txtConnectString.Name     = "txtConnectString";
     this.txtConnectString.Size     = new System.Drawing.Size(280, 21);
     this.txtConnectString.TabIndex = 1;
     this.txtConnectString.Text     = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\\\..\\\\..\\\\..\\\\database\\\\demo.mdb";
     //
     // label1
     //
     this.label1.Location = new System.Drawing.Point(15, 23);
     this.label1.Name     = "label1";
     this.label1.Size     = new System.Drawing.Size(121, 16);
     this.label1.TabIndex = 0;
     this.label1.Text     = "Connection string:";
     //
     // groupBox2
     //
     this.groupBox2.Controls.Add(this.rbnSYLK);
     this.groupBox2.Controls.Add(this.rbnDIF);
     this.groupBox2.Controls.Add(this.rbnCSV);
     this.groupBox2.Controls.Add(this.rbnXLS);
     this.groupBox2.Controls.Add(this.rbnHtml);
     this.groupBox2.Controls.Add(this.rbnPdf);
     this.groupBox2.Controls.Add(this.rbnRtf);
     this.groupBox2.Controls.Add(this.rbnClipboard);
     this.groupBox2.Controls.Add(this.rbnDbf);
     this.groupBox2.Controls.Add(this.rbnAccess);
     this.groupBox2.Controls.Add(this.rbnXml);
     this.groupBox2.Controls.Add(this.rbnSql);
     this.groupBox2.Controls.Add(this.radioButton1);
     this.groupBox2.Location = new System.Drawing.Point(336, 12);
     this.groupBox2.Name     = "groupBox2";
     this.groupBox2.Size     = new System.Drawing.Size(264, 240);
     this.groupBox2.TabIndex = 1;
     this.groupBox2.TabStop  = false;
     this.groupBox2.Text     = " Export file format ";
     //
     // rbnSYLK
     //
     this.rbnSYLK.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnSYLK.Location        = new System.Drawing.Point(152, 144);
     this.rbnSYLK.Name            = "rbnSYLK";
     this.rbnSYLK.Size            = new System.Drawing.Size(96, 26);
     this.rbnSYLK.TabIndex        = 10;
     this.rbnSYLK.Tag             = "10";
     this.rbnSYLK.Text            = " SYLK";
     this.rbnSYLK.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnDIF
     //
     this.rbnDIF.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnDIF.Location        = new System.Drawing.Point(152, 176);
     this.rbnDIF.Name            = "rbnDIF";
     this.rbnDIF.Size            = new System.Drawing.Size(96, 26);
     this.rbnDIF.TabIndex        = 9;
     this.rbnDIF.Tag             = "12";
     this.rbnDIF.Text            = " DIF";
     this.rbnDIF.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnCSV
     //
     this.rbnCSV.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnCSV.Location        = new System.Drawing.Point(24, 176);
     this.rbnCSV.Name            = "rbnCSV";
     this.rbnCSV.Size            = new System.Drawing.Size(96, 26);
     this.rbnCSV.TabIndex        = 8;
     this.rbnCSV.Tag             = "11";
     this.rbnCSV.Text            = " CSV";
     this.rbnCSV.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnXLS
     //
     this.rbnXLS.Checked         = true;
     this.rbnXLS.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnXLS.Location        = new System.Drawing.Point(24, 16);
     this.rbnXLS.Name            = "rbnXLS";
     this.rbnXLS.TabIndex        = 0;
     this.rbnXLS.TabStop         = true;
     this.rbnXLS.Tag             = "1";
     this.rbnXLS.Text            = " XLS";
     this.rbnXLS.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnHtml
     //
     this.rbnHtml.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnHtml.Location        = new System.Drawing.Point(152, 16);
     this.rbnHtml.Name            = "rbnHtml";
     this.rbnHtml.TabIndex        = 0;
     this.rbnHtml.Tag             = "2";
     this.rbnHtml.Text            = " HTML";
     this.rbnHtml.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnPdf
     //
     this.rbnPdf.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnPdf.Location        = new System.Drawing.Point(24, 48);
     this.rbnPdf.Name            = "rbnPdf";
     this.rbnPdf.TabIndex        = 0;
     this.rbnPdf.Tag             = "3";
     this.rbnPdf.Text            = " PDF";
     this.rbnPdf.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnRtf
     //
     this.rbnRtf.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnRtf.Location        = new System.Drawing.Point(152, 48);
     this.rbnRtf.Name            = "rbnRtf";
     this.rbnRtf.TabIndex        = 0;
     this.rbnRtf.Tag             = "4";
     this.rbnRtf.Text            = " RTF";
     this.rbnRtf.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnClipboard
     //
     this.rbnClipboard.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnClipboard.Location        = new System.Drawing.Point(24, 80);
     this.rbnClipboard.Name            = "rbnClipboard";
     this.rbnClipboard.TabIndex        = 0;
     this.rbnClipboard.Tag             = "5";
     this.rbnClipboard.Text            = " Clipboard";
     this.rbnClipboard.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnDbf
     //
     this.rbnDbf.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnDbf.Location        = new System.Drawing.Point(152, 80);
     this.rbnDbf.Name            = "rbnDbf";
     this.rbnDbf.TabIndex        = 0;
     this.rbnDbf.Tag             = "6";
     this.rbnDbf.Text            = " DBF";
     this.rbnDbf.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnAccess
     //
     this.rbnAccess.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnAccess.Location        = new System.Drawing.Point(24, 112);
     this.rbnAccess.Name            = "rbnAccess";
     this.rbnAccess.TabIndex        = 0;
     this.rbnAccess.Tag             = "7";
     this.rbnAccess.Text            = " MS Access";
     this.rbnAccess.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnXml
     //
     this.rbnXml.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnXml.Location        = new System.Drawing.Point(152, 112);
     this.rbnXml.Name            = "rbnXml";
     this.rbnXml.TabIndex        = 0;
     this.rbnXml.Tag             = "8";
     this.rbnXml.Text            = " XML";
     this.rbnXml.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // rbnSql
     //
     this.rbnSql.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.rbnSql.Location        = new System.Drawing.Point(24, 144);
     this.rbnSql.Name            = "rbnSql";
     this.rbnSql.TabIndex        = 0;
     this.rbnSql.Tag             = "9";
     this.rbnSql.Text            = " SQL Script";
     this.rbnSql.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // radioButton1
     //
     this.radioButton1.FlatStyle       = System.Windows.Forms.FlatStyle.Popup;
     this.radioButton1.Location        = new System.Drawing.Point(24, 208);
     this.radioButton1.Name            = "radioButton1";
     this.radioButton1.Size            = new System.Drawing.Size(96, 26);
     this.radioButton1.TabIndex        = 8;
     this.radioButton1.Tag             = "13";
     this.radioButton1.Text            = " Text";
     this.radioButton1.CheckedChanged += new System.EventHandler(this.rbnHtml_CheckedChanged_1);
     //
     // dgDetail
     //
     this.dgDetail.DataMember      = "";
     this.dgDetail.HeaderForeColor = System.Drawing.SystemColors.ControlText;
     this.dgDetail.Location        = new System.Drawing.Point(16, 264);
     this.dgDetail.Name            = "dgDetail";
     this.dgDetail.Size            = new System.Drawing.Size(584, 128);
     this.dgDetail.TabIndex        = 0;
     //
     // btnRun
     //
     this.btnRun.Location = new System.Drawing.Point(432, 408);
     this.btnRun.Name     = "btnRun";
     this.btnRun.TabIndex = 2;
     this.btnRun.Text     = "Run";
     this.btnRun.Click   += new System.EventHandler(this.btnRun_Click);
     //
     // btnAbout
     //
     this.btnAbout.Location = new System.Drawing.Point(520, 408);
     this.btnAbout.Name     = "btnAbout";
     this.btnAbout.TabIndex = 3;
     this.btnAbout.Text     = "Close";
     this.btnAbout.Click   += new System.EventHandler(this.btnAbout_Click);
     //
     // txtExport1
     //
     this.txtExport1.ActionAfterExport       = Spire.DataExport.Common.ActionType.OpenView;
     this.txtExport1.DataFormats.CultureName = "zh-CN";
     this.txtExport1.DataFormats.Currency    = "c";
     this.txtExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.txtExport1.DataFormats.Float       = "g";
     this.txtExport1.DataFormats.Integer     = "g";
     this.txtExport1.DataFormats.Time        = "H:mm";
     this.txtExport1.DataEncoding            = Spire.DataExport.Common.EncodingType.ASCII;
     this.txtExport1.SQLCommand = this.oleDbCommand1;
     //
     // txtExport2
     //
     this.txtExport2.DataFormats.CultureName = "zh-CN";
     this.txtExport2.DataFormats.Currency    = "c";
     this.txtExport2.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.txtExport2.DataFormats.Float       = "g";
     this.txtExport2.DataFormats.Integer     = "g";
     this.txtExport2.DataFormats.Time        = "H:mm";
     //
     // Form1
     //
     this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
     this.ClientSize        = new System.Drawing.Size(616, 438);
     this.Controls.Add(this.btnAbout);
     this.Controls.Add(this.btnRun);
     this.Controls.Add(this.dgDetail);
     this.Controls.Add(this.groupBox2);
     this.Controls.Add(this.groupBox1);
     this.Name  = "Form1";
     this.Text  = "Sample";
     this.Load += new System.EventHandler(this.Form1_Load);
     this.groupBox1.ResumeLayout(false);
     this.groupBox2.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.dgDetail)).EndInit();
     this.ResumeLayout(false);
 }
コード例 #3
0
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
			this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand();
			this.accessExport1 = new Spire.DataExport.Access.AccessExport();
			this.cellExport1 = new Spire.DataExport.XLS.CellExport();
			this.dbfExport1 = new Spire.DataExport.DBF.DBFExport();
			this.pdfExport1 = new Spire.DataExport.PDF.PDFExport();
			this.rtfExport1 = new Spire.DataExport.RTF.RTFExport();
			this.sqlExport1 = new Spire.DataExport.SQL.SQLExport();
			this.txtExport1 = new Spire.DataExport.TXT.TXTExport();
			this.xmlExport1 = new Spire.DataExport.XML.XMLExport();
			// 
			// oleDbConnection1
			// 
			this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source="".\..\database\demo.mdb"";Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
			// 
			// oleDbCommand1
			// 
			this.oleDbCommand1.CommandText = "SELECT * FROM country";
			this.oleDbCommand1.Connection = this.oleDbConnection1;
			// 
			// accessExport1
			// 
			this.accessExport1.DataFormats.CultureName = "zh-CN";
			this.accessExport1.DataFormats.Currency = "c";
			this.accessExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.accessExport1.DataFormats.Float = "g";
			this.accessExport1.DataFormats.Integer = "g";
			this.accessExport1.DataFormats.Time = "H:mm";
			this.accessExport1.SQLCommand = this.oleDbCommand1;
			// 
			// cellExport1
			// 
			this.cellExport1.DataFormats.CultureName = "zh-CN";
			this.cellExport1.DataFormats.Currency = "гд#,###,##0.00";
			this.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.cellExport1.DataFormats.Float = "#,###,##0.00";
			this.cellExport1.DataFormats.Integer = "#,###,##0";
			this.cellExport1.DataFormats.Time = "H:mm";
			this.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.DefaultFont.Name = "Arial";
			this.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
			this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
			this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
			this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
			this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
			this.cellExport1.SheetOptions.NoteFormat.Font.Bold = true;
			this.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma";
			this.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F;
			this.cellExport1.SheetOptions.TitlesFormat.Font.Bold = true;
			this.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial";
			this.cellExport1.SQLCommand = this.oleDbCommand1;
			// 
			// dbfExport1
			// 
			this.dbfExport1.SQLCommand = this.oleDbCommand1;
			// 
			// pdfExport1
			// 
			this.pdfExport1.DataFormats.CultureName = "zh-CN";
			this.pdfExport1.DataFormats.Currency = "c";
			this.pdfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.pdfExport1.DataFormats.Float = "g";
			this.pdfExport1.DataFormats.Integer = "g";
			this.pdfExport1.DataFormats.Time = "H:mm";
			this.pdfExport1.PDFOptions.PageOptions.Format = Spire.DataExport.PDF.PageFormat.User;
			this.pdfExport1.PDFOptions.PageOptions.Height = 11.67;
			this.pdfExport1.PDFOptions.PageOptions.MarginBottom = 0.78;
			this.pdfExport1.PDFOptions.PageOptions.MarginLeft = 1.17;
			this.pdfExport1.PDFOptions.PageOptions.MarginRight = 0.57;
			this.pdfExport1.PDFOptions.PageOptions.MarginTop = 0.78;
			this.pdfExport1.PDFOptions.PageOptions.Width = 8.25;
			this.pdfExport1.SQLCommand = this.oleDbCommand1;
			// 
			// rtfExport1
			// 
			this.rtfExport1.DataFormats.CultureName = "zh-CN";
			this.rtfExport1.DataFormats.Currency = "c";
			this.rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.rtfExport1.DataFormats.Float = "g";
			this.rtfExport1.DataFormats.Integer = "g";
			this.rtfExport1.DataFormats.Time = "H:mm";
			this.rtfExport1.RTFOptions.DataStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
			this.rtfExport1.RTFOptions.FooterStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
			this.rtfExport1.RTFOptions.HeaderStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
			this.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center;
			this.rtfExport1.RTFOptions.TitleStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
			this.rtfExport1.SQLCommand = this.oleDbCommand1;
			// 
			// sqlExport1
			// 
			this.sqlExport1.DataFormats.CultureName = "zh-CN";
			this.sqlExport1.DataFormats.Currency = "c";
			this.sqlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.sqlExport1.DataFormats.Float = "g";
			this.sqlExport1.DataFormats.Integer = "g";
			this.sqlExport1.DataFormats.Time = "H:mm";
			this.sqlExport1.SQLCommand = this.oleDbCommand1;
			// 
			// txtExport1
			// 
			this.txtExport1.DataFormats.CultureName = "zh-CN";
			this.txtExport1.DataFormats.Currency = "c";
			this.txtExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.txtExport1.DataFormats.Float = "g";
			this.txtExport1.DataFormats.Integer = "g";
			this.txtExport1.DataFormats.Time = "H:mm";
			this.txtExport1.SQLCommand = this.oleDbCommand1;
			// 
			// xmlExport1
			// 
			this.xmlExport1.DataFormats.CultureName = "zh-CN";
			this.xmlExport1.DataFormats.Currency = "c";
			this.xmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
			this.xmlExport1.DataFormats.Float = "g";
			this.xmlExport1.DataFormats.Integer = "g";
			this.xmlExport1.DataFormats.Time = "H:mm";
			this.xmlExport1.SQLCommand = this.oleDbCommand1;

		}
コード例 #4
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.oleDbCommand1    = new System.Data.OleDb.OleDbCommand();
     this.accessExport1    = new Spire.DataExport.Access.AccessExport();
     this.cellExport1      = new Spire.DataExport.XLS.CellExport();
     this.dbfExport1       = new Spire.DataExport.DBF.DBFExport();
     this.pdfExport1       = new Spire.DataExport.PDF.PDFExport();
     this.rtfExport1       = new Spire.DataExport.RTF.RTFExport();
     this.sqlExport1       = new Spire.DataExport.SQL.SQLExport();
     this.txtExport1       = new Spire.DataExport.TXT.TXTExport();
     this.xmlExport1       = new Spire.DataExport.XML.XMLExport();
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source="".\..\database\demo.mdb"";Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
     //
     // oleDbCommand1
     //
     this.oleDbCommand1.CommandText = "SELECT * FROM country";
     this.oleDbCommand1.Connection  = this.oleDbConnection1;
     //
     // accessExport1
     //
     this.accessExport1.DataFormats.CultureName = "zh-CN";
     this.accessExport1.DataFormats.Currency    = "c";
     this.accessExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.accessExport1.DataFormats.Float       = "g";
     this.accessExport1.DataFormats.Integer     = "g";
     this.accessExport1.DataFormats.Time        = "H:mm";
     this.accessExport1.SQLCommand = this.oleDbCommand1;
     //
     // cellExport1
     //
     this.cellExport1.DataFormats.CultureName = "zh-CN";
     this.cellExport1.DataFormats.Currency    = "гд#,###,##0.00";
     this.cellExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.cellExport1.DataFormats.Float       = "#,###,##0.00";
     this.cellExport1.DataFormats.Integer     = "#,###,##0";
     this.cellExport1.DataFormats.Time        = "H:mm";
     this.cellExport1.SheetOptions.AggregateFormat.Font.Name       = "Arial";
     this.cellExport1.SheetOptions.CustomDataFormat.Font.Name      = "Arial";
     this.cellExport1.SheetOptions.DefaultFont.Name                = "Arial";
     this.cellExport1.SheetOptions.FooterFormat.Font.Name          = "Arial";
     this.cellExport1.SheetOptions.HeaderFormat.Font.Name          = "Arial";
     this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color      = Spire.DataExport.XLS.CellColor.Blue;
     this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name       = "Arial";
     this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline  = Spire.DataExport.XLS.XlsFontUnderline.Single;
     this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
     this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical   = Spire.DataExport.XLS.VerticalAlignment.Top;
     this.cellExport1.SheetOptions.NoteFormat.Font.Bold            = true;
     this.cellExport1.SheetOptions.NoteFormat.Font.Name            = "Tahoma";
     this.cellExport1.SheetOptions.NoteFormat.Font.Size            = 8F;
     this.cellExport1.SheetOptions.TitlesFormat.Font.Bold          = true;
     this.cellExport1.SheetOptions.TitlesFormat.Font.Name          = "Arial";
     this.cellExport1.SQLCommand = this.oleDbCommand1;
     //
     // dbfExport1
     //
     this.dbfExport1.SQLCommand = this.oleDbCommand1;
     //
     // pdfExport1
     //
     this.pdfExport1.DataFormats.CultureName             = "zh-CN";
     this.pdfExport1.DataFormats.Currency                = "c";
     this.pdfExport1.DataFormats.DateTime                = "yyyy-M-d H:mm";
     this.pdfExport1.DataFormats.Float                   = "g";
     this.pdfExport1.DataFormats.Integer                 = "g";
     this.pdfExport1.DataFormats.Time                    = "H:mm";
     this.pdfExport1.PDFOptions.PageOptions.Format       = Spire.DataExport.PDF.PageFormat.User;
     this.pdfExport1.PDFOptions.PageOptions.Height       = 11.67;
     this.pdfExport1.PDFOptions.PageOptions.MarginBottom = 0.78;
     this.pdfExport1.PDFOptions.PageOptions.MarginLeft   = 1.17;
     this.pdfExport1.PDFOptions.PageOptions.MarginRight  = 0.57;
     this.pdfExport1.PDFOptions.PageOptions.MarginTop    = 0.78;
     this.pdfExport1.PDFOptions.PageOptions.Width        = 8.25;
     this.pdfExport1.SQLCommand = this.oleDbCommand1;
     //
     // rtfExport1
     //
     this.rtfExport1.DataFormats.CultureName         = "zh-CN";
     this.rtfExport1.DataFormats.Currency            = "c";
     this.rtfExport1.DataFormats.DateTime            = "yyyy-M-d H:mm";
     this.rtfExport1.DataFormats.Float               = "g";
     this.rtfExport1.DataFormats.Integer             = "g";
     this.rtfExport1.DataFormats.Time                = "H:mm";
     this.rtfExport1.RTFOptions.DataStyle.Font       = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
     this.rtfExport1.RTFOptions.FooterStyle.Font     = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
     this.rtfExport1.RTFOptions.HeaderStyle.Font     = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
     this.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center;
     this.rtfExport1.RTFOptions.TitleStyle.Font      = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
     this.rtfExport1.SQLCommand = this.oleDbCommand1;
     //
     // sqlExport1
     //
     this.sqlExport1.DataFormats.CultureName = "zh-CN";
     this.sqlExport1.DataFormats.Currency    = "c";
     this.sqlExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.sqlExport1.DataFormats.Float       = "g";
     this.sqlExport1.DataFormats.Integer     = "g";
     this.sqlExport1.DataFormats.Time        = "H:mm";
     this.sqlExport1.SQLCommand = this.oleDbCommand1;
     //
     // txtExport1
     //
     this.txtExport1.DataFormats.CultureName = "zh-CN";
     this.txtExport1.DataFormats.Currency    = "c";
     this.txtExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.txtExport1.DataFormats.Float       = "g";
     this.txtExport1.DataFormats.Integer     = "g";
     this.txtExport1.DataFormats.Time        = "H:mm";
     this.txtExport1.SQLCommand = this.oleDbCommand1;
     //
     // xmlExport1
     //
     this.xmlExport1.DataFormats.CultureName = "zh-CN";
     this.xmlExport1.DataFormats.Currency    = "c";
     this.xmlExport1.DataFormats.DateTime    = "yyyy-M-d H:mm";
     this.xmlExport1.DataFormats.Float       = "g";
     this.xmlExport1.DataFormats.Integer     = "g";
     this.xmlExport1.DataFormats.Time        = "H:mm";
     this.xmlExport1.SQLCommand = this.oleDbCommand1;
 }