![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
vb.net
Emily_1021
这个作者很懒,什么都没留下…
展开
-
vb.net 中Excel的protect sheet的使用
问题描述:用vb.net操作一个Excel后,让sheet1的内容不可修改,如果想要修改,需要按功能取的REVIEW->Unprotect worksheet,这里需要输入密码后,才可以修改文件内容。下图为文件内容不可以修改:点击REVIEW->Unprotect worksheet后输入密码,就可以修改文件内容,如下图:代码就一句话: xlWorkSheet....原创 2019-01-18 17:47:04 · 845 阅读 · 0 评论 -
vb.net读取Excel / Csv 文件的基本方法
Public Shared Function getDateFromBankFile(ByRef fiArr As FileInfo()) As String Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim xlWorkBook As Excel.Workbook Dim x...原创 2019-01-18 18:00:48 · 4442 阅读 · 0 评论 -
vb.net 用sqlCommand操作数据库
'连接数据库的方法:Public Shared Function getConnectionString() As String Dim conStr As String = System.Configuration.ConfigurationManager.ConnectionStrings("TEST.ConnectionString").Conn...原创 2019-01-18 18:05:03 · 2488 阅读 · 1 评论 -
vb.net给DataGridView添加全选功能
Private Sub AddSelectAllCheckBox(ByVal dgv As DataGridView) Dim cbx As New CheckBox cbx.Name = "SelectAll" cbx.Size = New Size(14, 14) Dim rect As Rectangle r...原创 2019-01-18 18:15:25 · 1134 阅读 · 0 评论