예제 #1
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);

		}
예제 #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.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;

		}