strConnString="Provider=SQLOLEDB;Persist Security Info=True;Data Source=192.168.0.245;Initial Catalog=pubs;User ID=saa;Password=liang;"
'创建对象ADOConnection
Dim objConn as OleDbConnection
objConn = New OleDbConnection
'创建SQL字符串
Dim strSQL as String = "SELECT * FROM authors"
'创建对象ADODatasetCommand 和Dataset
Dim objDSCommand as OleDbCommand
Dim objDataset as Dataset = New Dataset
objDSCommand = New OleDbCommand(strSQL, objConn)