7,763
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command2_Click()
Dim cnn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim Read As New ADODB.Recordset
Dim varsource As String
cnn.ConnectionString = "Provider=SQLOLEDB.1;User ID=sa;Password=sa;Initial catalog=db_hsjs;Data Source=127.0.0.1"
cnn.Open
Set Read.ActiveConnection = cnn
Read.CursorType = adOpenStatic
Adodc1.RecordSource = "SELECT * FROM itembase WHERE itemID LIKE 'HSJS000%'"
Text3.Text = Adodc1.RecordSource
End Sub
这直接将"SELECT。。。。。。。。。""