Set DataGrid1.DataSource = Rsdetail //rsdetail是记录集 DataGrid1.Refresh
还有你右击datagrid,在属性中的columns绷定field就行了
dim con as new adodb.connection dim rs as new adodb.recordset con.open "DSN=databasename;UID=sa" rs.open "select * from tablename",con,1,1 with datagrid1 '设置datagrid1的各种属性,比如行,列等外观 end with set datagrid1.datasource=rs
DataGrid1.Refresh
dim rs as new adodb.recordset
con.open "DSN=databasename;UID=sa"
rs.open "select * from tablename",con,1,1
with datagrid1
'设置datagrid1的各种属性,比如行,列等外观
end with
set datagrid1.datasource=rs
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog;database=......,Data Source=..."
Adodc1.RecordSource = "select * from ...... "
datagrid1控件,右键-->属性里设置需要显示的列set datagrid1.datasource=rs