Private Sub Form_Load() Dim Cnn As ADODB.Connection Dim Rs As New ADODB.Recordset Cnn.ConnectionString = "数据库连接字符串" Cnn.Open Rs.Open "SELECT * FROM Info WHERE 编号='" & 条件 & "'", Cnn, adOpenKeyset, adLockReadOnly, adCmdText If Rs.EOF And Rs.BOF Then Else Text1.Text = Rs("编号") Text2.Text = Rs("姓名") Text3.Text = Rs("性别") End If Rs.Close Set Rs = Nothing Cnn.Close Set Cnn = Nothing End Sub
Dim Cnn As ADODB.Connection 应该是Dim Cnn As New ADODB.Connection
哦, 我改成了Dim Cnn As New ADODB.Connection就好了,是我刚才没看到对了,,我想把编号设置为用户输入的是不是该这样? Rs.Open "SELECT * FROM Info WHERE 编号='CoceText.Text'", Cnn, adOpenKeyset, adLockReadOnly, adCmdText这样行吗
要引用ado呢 工程>>引用>>Microsoft ActiveX data objects 2.5Libirary
是这样: "SELECT * FROM Info WHERE 编号='" & CoceText.Text & "'"
Dim Cnn As ADODB.Connection
Dim Rs As New ADODB.Recordset
Cnn.ConnectionString = "数据库连接字符串"
Cnn.Open
Rs.Open "SELECT * FROM Info WHERE 编号='" & 条件 & "'", Cnn, adOpenKeyset, adLockReadOnly, adCmdText
If Rs.EOF And Rs.BOF Then
Else
Text1.Text = Rs("编号")
Text2.Text = Rs("姓名")
Text3.Text = Rs("性别")
End If
Rs.Close
Set Rs = Nothing
Cnn.Close
Set Cnn = Nothing
End Sub
工程>>引用>>Microsoft ActiveX data objects 2.5Libirary