Visual Basic .NET处理Excel表格全接触(4)_.Net教程
教程Tag:暂无Tag,欢迎添加,赚取U币!
推荐:解析.NET中字符串替换的五种方法1:使用String.Replace函数替换,但不支持大小写。 2:正则System.Text.Regex替换,用RegExpOption修改是否支持大小写。 3:在小数据的情况下,使用String.SubString和 可以实现间接替
以下为引用的内容: <System.Diagnostics.DebuggerStepThrough ( ) > Private Sub InitializeComponent ( ) Me.Label1 = New System.Windows.Forms.Label Me.Label2 = New System.Windows.Forms.Label Me.Label3 = New System.Windows.Forms.Label Me.Label4 = New System.Windows.Forms.Label Me.Label5 = New System.Windows.Forms.Label Me.TextBox1 = New System.Windows.Forms.TextBox Me.TextBox2 = New System.Windows.Forms.TextBox Me.TextBox3 = New System.Windows.Forms.TextBox Me.TextBox5 = New System.Windows.Forms.TextBox Me.Button1 = New System.Windows.Forms.Button Me.TextBox4 = New System.Windows.Forms.TextBox Me.SuspendLayout ( ) Me.Label1.Location = New System.Drawing.Point ( 40 , 28 ) Me.Label1.Name = "Label1" Me.Label1.Size = New System.Drawing.Size ( 114 , 23 ) Me.Label1.TabIndex = 0 Me.Label1.Text = "数据库服务器名:" Me.Label2.Location = New System.Drawing.Point ( 64 , 59 ) Me.Label2.Name = "Label2" Me.Label2.TabIndex = 1 Me.Label2.Text = "数据库名称:" Me.Label3.Location = New System.Drawing.Point ( 64 , 90 ) Me.Label3.Name = "Label3" Me.Label3.TabIndex = 2 Me.Label3.Text = "数据表名称:" Me.Label4.Location = New System.Drawing.Point ( 88 , 121 ) Me.Label4.Name = "Label4" Me.Label4.TabIndex = 3 Me.Label4.Text = "用户名:" Me.Label5.Location = New System.Drawing.Point ( 98 , 152 ) Me.Label5.Name = "Label5" Me.Label5.TabIndex = 4 Me.Label5.Text = "口令:" Me.TextBox1.Location = New System.Drawing.Point ( 160 , 26 ) Me.TextBox1.Name = "TextBox1" Me.TextBox1.Size = New System.Drawing.Size ( 148 , 21 ) Me.TextBox1.TabIndex = 5 Me.TextBox1.Text = "" Me.TextBox2.Location = New System.Drawing.Point ( 160 , 56 ) Me.TextBox2.Name = "TextBox2" Me.TextBox2.Size = New System.Drawing.Size ( 148 , 21 ) Me.TextBox2.TabIndex = 6 Me.TextBox2.Text = "" Me.TextBox3.Location = New System.Drawing.Point ( 160 , 86 ) Me.TextBox3.Name = "TextBox3" Me.TextBox3.Size = New System.Drawing.Size ( 148 , 21 ) Me.TextBox3.TabIndex = 7 Me.TextBox3.Text = "" Me.TextBox5.Location = New System.Drawing.Point ( 160 , 146 ) Me.TextBox5.Name = "TextBox5" Me.TextBox5.PasswordChar = Microsoft.VisualBasic.ChrW ( 42 ) Me.TextBox5.Size = New System.Drawing.Size ( 148 , 21 ) Me.TextBox5.TabIndex = 9 Me.TextBox5.Text = "" Me.Button1.Location = New System.Drawing.Point ( 120 , 198 ) Me.Button1.Name = "Button1" Me.Button1.Size = New System.Drawing.Size ( 126 , 36 ) Me.Button1.TabIndex = 10 Me.Button1.Text = "导出Excle表格" Me.TextBox4.Location = New System.Drawing.Point ( 160 , 116 ) Me.TextBox4.Name = "TextBox4" Me.TextBox4.Size = New System.Drawing.Size ( 148 , 21 ) Me.TextBox4.TabIndex = 8 Me.TextBox4.Text = "" Me.AutoScaleBaseSize = New System.Drawing.Size ( 6 , 14 ) Me.ClientSize = New System.Drawing.Size ( 374 , 271 ) Me.Controls.Add ( Me.Button1 ) Me.Controls.Add ( Me.TextBox5 ) Me.Controls.Add ( Me.TextBox4 ) Me.Controls.Add ( Me.TextBox3 ) Me.Controls.Add ( Me.TextBox2 ) Me.Controls.Add ( Me.TextBox1 ) Me.Controls.Add ( Me.Label5 ) Me.Controls.Add ( Me.Label4 ) Me.Controls.Add ( Me.Label3 ) Me.Controls.Add ( Me.Label2 ) Me.Controls.Add ( Me.Label1 ) Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle Me.MaximizeBox = False Me.Name = "Form1" Me.Text = "Visual Basic .Net导入数据库数据到Excel表格" Me.ResumeLayout ( False ) End Sub |
分享:.NET教程之--.NET动态创建类的实例解析看了网上很多关于DotNet动态创建类的实例的文章,我这里想总结一下,其实方法很简单,就是用“Activator.CreateInstance”。但是这个方法需要待创建的类的Type作为参数,为了获
相关.Net教程:
- asp.net如何得到GRIDVIEW中某行某列值的方法
- .net SMTP发送Email实例(可带附件)
- js实现广告漂浮效果的小例子
- asp.net Repeater 数据绑定的具体实现
- Asp.Net 无刷新文件上传并显示进度条的实现方法及思路
- Asp.net获取客户端IP常见代码存在的伪造IP问题探讨
- VS2010 水晶报表的使用方法
- ASP.NET中操作SQL数据库(连接字符串的配置及获取)
- asp.net页面传值测试实例代码
- DataGridView - DataGridViewCheckBoxCell的使用介绍
- asp.net中javascript的引用(直接引入和间接引入)
- 三层+存储过程实现分页示例代码
- 相关链接:
- 教程说明:
.Net教程-Visual Basic .NET处理Excel表格全接触(4)。