Option Explicit Private conn As ADODB.Connection Private rs As ADODB.RecordsetPrivate Sub Form_Load() Dim apppath As String Dim dbfilename As String Dim ConnectString As String Dim i As Integer Set conn = New ADODB.Connection Dim sql As String Set conn = New ADODB.Connection dbfilename = "F:\csdn_vb\controls\listbox\article.mdb" ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ dbfilename & ";Persist Security Info=False;"
On Error Resume Next With conn .CursorLocation = adUseClient .Open ConnectString End With Set rs = New ADODB.Recordset rs.Open "select id,mc from mz", conn, 1, 3 If rs.EOF Then Exit Sub End IfFor i = 0 To rs.RecordCount - 1 List1.AddItem rs.Fields("mc") List1.ItemData(i) = rs.Fields("id") rs.MoveNext Next rs.Close Set rs = Nothing End SubPrivate Sub List1_Click() Dim strsql As String strsql = "select memo from mz where id=" & List1.ItemData(List1.ListIndex) Set rs = New ADODB.Recordset rs.Open strsql, conn, 1, 3 Dim s As String Text1.Text = rs.Fields("memo") End Sub
do while 或者for 等语句循环添加进去
还有打印用什么控件,高手请多指点。最好帮我初始化下!datareportOption ExplicitDim adoConnectionX As New ADODB.Connection Dim adoRecordsetX As New ADODB.RecordsetPrivate Sub DataReport_Initialize() 'printer.Orientation = '以下准备数据源(记录集) '要打印的数据源(记录集)必须是一个全局级别的,或者是本设计器模块级别的记录集
Private cnnAdd As New ADODB.Connection Private AdoRSAdd As New ADODB.Recordset If AdoRSAdd.State = 1 Then AdoRSAdd.Close cnnAdd.Close Set AdoRSAdd = Nothing End If
cnnAdd.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & App.Path & "\SCGL.mdb;" AdoRSAdd.Open Strcnn, cnnAdd, adOpenStatic, adLockBatchOptimistic 'Strcnn为SQL查询语句 With AdoRSAdd .MoveFirst i = 0 For i = 0 To .RecordCount - 1 Combo1.List(i) = Trim(IIf(IsNull(.Fields(0)), "", .Fields(0))) '这里的数据表只有一列 .MoveNext Next End With
'SQL中的使用 Option ExplicitPrivate conn As ADODB.Connection Private rs As ADODB.Recordset conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;" & _ "User ID=用户名;Password=密码;Initial Catalog=数据库名;Data Source=机器名或IP" conn.Openrs.CursorLocation = adUseClientsqlstr = "select distinct 某字段 from 表 "rs.Open sqlstr, conn Do Until rs.EOF Combo2.AddItem rs(某字段).Value '调用表里的数据 rs.MoveNext Loop rs.Close Set rs = Nothing conn.Close Set conn = Nothing 'Access中的使用 Option ExplicitPrivate conn As ADODB.Connection Private rs As ADODB.Recordset'conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "数据.mdb;Persist Security Info=False" conn.Openrs.CursorLocation = adUseClientsqlstr = "select distinct 某字段 from 表 "rs.Open sqlstr, conn Do Until rs.EOF Combo2.AddItem rs(某字段).Value '调用表里的数据 rs.MoveNext Loop rs.Close Set rs = Nothing conn.Close Set conn = Nothing
Private conn As ADODB.Connection
Private rs As ADODB.RecordsetPrivate Sub Form_Load()
Dim apppath As String
Dim dbfilename As String
Dim ConnectString As String
Dim i As Integer
Set conn = New ADODB.Connection
Dim sql As String
Set conn = New ADODB.Connection
dbfilename = "F:\csdn_vb\controls\listbox\article.mdb"
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
dbfilename & ";Persist Security Info=False;"
On Error Resume Next
With conn
.CursorLocation = adUseClient
.Open ConnectString
End With
Set rs = New ADODB.Recordset
rs.Open "select id,mc from mz", conn, 1, 3
If rs.EOF Then
Exit Sub
End IfFor i = 0 To rs.RecordCount - 1
List1.AddItem rs.Fields("mc")
List1.ItemData(i) = rs.Fields("id")
rs.MoveNext
Next
rs.Close
Set rs = Nothing
End SubPrivate Sub List1_Click()
Dim strsql As String
strsql = "select memo from mz where id=" & List1.ItemData(List1.ListIndex)
Set rs = New ADODB.Recordset
rs.Open strsql, conn, 1, 3
Dim s As String
Text1.Text = rs.Fields("memo")
End Sub
Dim adoRecordsetX As New ADODB.RecordsetPrivate Sub DataReport_Initialize()
'printer.Orientation =
'以下准备数据源(记录集)
'要打印的数据源(记录集)必须是一个全局级别的,或者是本设计器模块级别的记录集
'数据库使用的是 Northwind.mdb
adoConnectionX.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\Northwind.mdb"
adoRecordsetX.Open "select * from 产品", adoConnectionX
Set DataReport1.DataSource = adoRecordsetX '设置 DataReport 的数据源
我连的时候老是测试通不过,显示用户“TOR”登陆失败
这是怎么回事,要怎么设置才行?
Set conn = New ADODB.Connection
ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=MyBookShop;Data Source=yang"不建议使用odbc
看数据库的连接
http://www.connectionstrings.com
没用过SQL的,SQL语句看不懂啊!
Private AdoRSAdd As New ADODB.Recordset If AdoRSAdd.State = 1 Then
AdoRSAdd.Close
cnnAdd.Close
Set AdoRSAdd = Nothing
End If
cnnAdd.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\SCGL.mdb;"
AdoRSAdd.Open Strcnn, cnnAdd, adOpenStatic, adLockBatchOptimistic 'Strcnn为SQL查询语句 With AdoRSAdd
.MoveFirst
i = 0
For i = 0 To .RecordCount - 1
Combo1.List(i) = Trim(IIf(IsNull(.Fields(0)), "", .Fields(0))) '这里的数据表只有一列
.MoveNext
Next
End With
Option ExplicitPrivate conn As ADODB.Connection
Private rs As ADODB.Recordset
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;" & _
"User ID=用户名;Password=密码;Initial Catalog=数据库名;Data Source=机器名或IP"
conn.Openrs.CursorLocation = adUseClientsqlstr = "select distinct 某字段 from 表 "rs.Open sqlstr, conn
Do Until rs.EOF
Combo2.AddItem rs(某字段).Value '调用表里的数据
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
'Access中的使用
Option ExplicitPrivate conn As ADODB.Connection
Private rs As ADODB.Recordset'conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "数据.mdb;Persist Security Info=False"
conn.Openrs.CursorLocation = adUseClientsqlstr = "select distinct 某字段 from 表 "rs.Open sqlstr, conn
Do Until rs.EOF
Combo2.AddItem rs(某字段).Value '调用表里的数据
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
我们公司的软件就用到了,告诉我你的邮箱吧!我发一份指导书给你参考。