我先在FORM内加入一个datagrid1..在一个事件中..我执行以下:
Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=sqloledb;Data Source=DB_server;User ID=sa;PWD=as;Initial Catalog=dm_system"
conn.Open
Dim rs As New ADODB.Recordset
rs.ActiveConnection = conn
rs.CursorLocation = adUseClient
rs.Open "select * from ma_interest_tbl"
MsgBox ("this first value is " & rs.Fields(1).Value)
Set DataGrid1.DataSource = rs
' DataGrid1.Refresh
rs.Close
conn.Close已经确定RS能读到数据...但是DATAGRID只是闪一下,并没有出现RS的数据...怪??!!
和Rst.Open SQLString, Conn, adOpenStatic, adLockOptimistic
conn.ConnectionString = "Provider=sqloledb;Data Source=DB_server;User ID=sa;PWD=as;Initial Catalog=dm_system"
Conn.CursorLocation = adUseClient
conn.Open
Dim rs As New ADODB.Recordset
rs.ActiveConnection = conn
rs.CursorLocation = adUseClient
rs.Open "select * from ma_interest_tbl",Conn, adOpenStatic, adLockOptimistic
MsgBox ("this first value is " & rs.Fields(1).Value)
Set DataGrid1.DataSource = rs
' DataGrid1.Refresh
rs.Close
conn.Close
conn.ConnectionString = "Provider=sqloledb;Data Source=DB_server;User ID=sa;PWD=as;Initial Catalog=dm_system"
conn.Open
Dim rs As New ADODB.Recordset rs.CursorLocation = adUseClient
rs.Open "select * from ma_interest_tbl",",Conn, adOpenStatic, adLockOptimistic MsgBox ("this first value is " & rs.Fields(1).Value)
Set DataGrid1.DataSource = rs
rs.Open "select * from ma_interest_tbl",Conn, adOpenStatic, adLockOptimistic
rs.Open "select * from ma_interest_tbl",conn,adOpenStatic, adLockOptimistic,adcmdtext
set datagrid1.datasource=rs
' DataGrid1.Refresh
rs.Close
conn.Close
是这样:Set DataGrid1.DataSource = rs
DataGrid1.Refresh
' rs.Close
' conn.Close
关闭了,就什么都没有了耶