Location:
Search - ADODB vb
Search list
Description: VB打开各种数据的方法,不要用Environment，直接添加DataReport。在细节中用RptTextBox控件按自己的打印要求布局。将其DataField属性对应相应的字段，注意不要设置DataMember-VB opened various kinds of data, not to use the Environment, direct DataReport added. The details RptTextBox controls used by the print layout requirements. Its DataField attribute with corresponding field, the attention should not erect DataMember
Platform: |
Size: 981 |
Author: 郭军权 |
Hits:
Description: 使用VB编写的搜索UTF-8编码的文件内的字符
很有用处的一个小程序!
还可以支持多种编码,使用了FSO与ADODB.Atream组件.
可能存在较多的bug,欢迎指正.-use VB search UTF-8 encoded characters within the document useful in a small procedure. Also to support a variety of coding, and the use of FSO ADODB.Atream components. there may be more of the bug, welcomed the correction.
Platform: |
Size: 3702 |
Author: 王立坚 |
Hits:
Description: VB打开各种数据的方法,不要用Environment，直接添加DataReport。在细节中用RptTextBox控件按自己的打印要求布局。将其DataField属性对应相应的字段，注意不要设置DataMember-VB opened various kinds of data, not to use the Environment, direct DataReport added. The details RptTextBox controls used by the print layout requirements. Its DataField attribute with corresponding field, the attention should not erect DataMember
Platform: |
Size: 1024 |
Author: 郭军权 |
Hits:
Description: 使用VB编写的搜索UTF-8编码的文件内的字符
很有用处的一个小程序!
还可以支持多种编码,使用了FSO与ADODB.Atream组件.
可能存在较多的bug,欢迎指正.-use VB search UTF-8 encoded characters within the document useful in a small procedure. Also to support a variety of coding, and the use of FSO ADODB.Atream components. there may be more of the bug, welcomed the correction.
Platform: |
Size: 3072 |
Author: 王立坚 |
Hits:
Description: 数据库的连接操作一些修改操作 ..adodb对象与adodc控件连接-Database connection to operate some changes to the operation .. adodb object with ADODC control connection
Platform: |
Size: 105472 |
Author: sdsad |
Hits:
Description: 用VB+MapX的轨迹回放源码。主要是用到了ADODB.Recordset。-With VB+ MapX track playback source. Is mainly used in the ADODB.Recordset.
Platform: |
Size: 8192 |
Author: sharing |
Hits:
Description: 分享一个简单的vb Mschart演示软件,能够连接adodb 跟access数据库-share one simple vb mschart control sample, it use adodb and access to select data.
Platform: |
Size: 61440 |
Author: bingo |
Hits:
Description: 利用vb开发环境连接wincc数据库，将wincc运行的数据导入excel中-SQL excel VB WINCC ADODB.Connection recorderset.Open AdoSql, Connection, adOpenDynamic, adLockOptimistic
Platform: |
Size: 3072 |
Author: 孙红权 |
Hits:
Description: 怎样用vb打开Excel用EXCEL对象读取EXCEL文件中数据.然后通过ADODB连接SQL进和导入
-How to use vb open Excel with Excel object read data in Excel file. Then through the ADODB connection SQL in and import
Platform: |
Size: 9216 |
Author: xsen |
Hits:
Description: ADODB在vb中的使用方法 -ADODB to use in vb ADODB use in vb
Platform: |
Size: 14336 |
Author: 刘静波 |
Hits:
Description: vb ADO方式，连接SQLSERVER数据库。-vb ADO, connect to the .
Platform: |
Size: 5120 |
Author: 张涛 |
Hits:
Description: database program in vb using adodb
Platform: |
Size: 3072 |
Author: lata |
Hits:
Description: VB使用ADODB查询数据库并按照日期和时间进行排序，最后将数据在DataGrid控件中显示出来。-VB using ADODB query and sort by date and time, and finally the data displayed in the DataGrid control.
Platform: |
Size: 9216 |
Author: zc |
Hits:
Description: 图书Public Sys_LoginSucceeded As Boolean '用户登录标志
Public Sys_UserID As String '用户ID
Public Sys_BorrowTLimited As Integer '借书时限
Public Sys_Borrow2TLimited As Integer '续借时限
Public Sys_MaxBorrow As Integer '最大借书量
Public Sys_MaxFine As Double '最高罚款额
Public Sys_DailyFine As Double '每日罚款
Public ConnectionString As String '数据库连接字符串
Public Sub SetSystemPar()
'得到参数值
Dim rst As ADODB.Recordset
Dim SQL As String
Dim msg As String
SQL = "select * from 参数配置表 "
Set rst = SelectSQL(SQL, msg)
If rst.RecordCount > 0 Then '如果存在记录
Sys_BorrowTLimited = rst.Fields("borrowTL")
Sys_Borrow2TLimited = rst.Fields("borrow2TL")
Sys_MaxBorrow = rst.Fields("maxBooks")
Sys_MaxFine = rst.Fields("maxFines")
Sys_DailyFine = rst.Fields("finedaily")
End If
End Sub
'Download by http://www.NewXing.com
Public Function GetConnStr() As String
'得到数据库连接字符串，用户可以在此处设置连接字符串
GetConnStr = ConnectionString
End Function
Public Function OpenConn(ByRef Conn As ADODB.Connection) As Boolean
'打开数据库连接，连接成功返回true，出错时返回false
Set Conn = New ADODB.Connection
'出错处理
On Error GoTo ErrorHandle
Conn.Open GetConnStr
OpenConn = True
Exit Function
ErrorHandle:
Platform: |
Size: 429722 |
Author: cxp9395 |
Hits: