Dim cn As New adodb.Connection Dim rs As New adodb.Recordset cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind" cn.Open rs.ActiveConnection = cn rs.Source = "select * from Customers" rs.CursorType = adOpenStatic rs.CursorLocation = adUseClient rs.Open Set MSHFlexGrid1.DataSource = rs
Dim cn As New adodb.Connection Dim rs As New adodb.Recordset cn.Open= "Provider=SQLOLEDB.1;Data Source=IPADDRESS;User ID=USERNAME;Password=PASSWORD;DataBase=DBNAME" rs.Open "Select * From TABLE",cn,adOpenStatic Set MSHFlexGrid1.DataSource = rs 大写单词都是变量自己根据实际情况替换
Dim rs As New adodb.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind"
cn.Open
rs.ActiveConnection = cn
rs.Source = "select * from Customers"
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.Open
Set MSHFlexGrid1.DataSource = rs
Dim rs As New adodb.Recordset
cn.Open= "Provider=SQLOLEDB.1;Data Source=IPADDRESS;User ID=USERNAME;Password=PASSWORD;DataBase=DBNAME"
rs.Open "Select * From TABLE",cn,adOpenStatic
Set MSHFlexGrid1.DataSource = rs
大写单词都是变量自己根据实际情况替换