通过VBS访问SQL数据库服务器中master数据库下的表格数据Userdata,并且把数据查询结果显示在DBGrid控件中,编写了如下脚本,运行没有结果。请高手帮忙修正下!
其中DBGrid控件在画面上的名字为DBGRID。
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim ConString,objConnection,objRecordset,strSQL
'ConString="Provider = SQLOLEDB.1 ;DRIVER=SQLERVER;SERVER=ES021\WINCC;DATABASE=master;UID=;PWD="
ConString="Provider=SQLOLEDB.1; Server=ES021\WINCC; Database=master; Integrated Security=SSPI"
Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString=ConString
objConnection.Open
strSQL=" select * from Userdata "
Set objRecordset = objConnection.Execute(strSQL)
Dim Grid
Set Grid=ScreenItems("DBGRID")
Set Grid.DataSource = objRecordset.Recordset
Grid.Refresh
Set objRecordset = Nothing
objConnection.Close
Set objConnection = Nothing
End Sub