1180
社区成员
- 主页
...全文
请发表友善的回复…
发表回复
Andy__Huang 2004-10-04
在綁定數據庫的sql語句里﹐不要用select * from tb
而是用select col1,col3,col5....from tb
而是用select col1,col3,col5....from tb
GGL123 2004-10-04
DataGrid1.Columns(1).Visible =true
DataGrid1.Columns(3).Visible =true
DataGrid1.Columns(5).Visible =true
DataGrid1.Columns(2).Visible =False
DataGrid1.Columns(4).Visible =False
DataGrid1.Columns(6).Visible =False
DataGrid1.Columns(3).Visible =true
DataGrid1.Columns(5).Visible =true
DataGrid1.Columns(2).Visible =False
DataGrid1.Columns(4).Visible =False
DataGrid1.Columns(6).Visible =False
lmshj 2004-10-04
问个问题，怎样发问？
tztz520 2004-10-04
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb"
db.Open
rs.CursorLocation = adUseClient
rs.Open "select id,myname sex from usertable", db'在这里控制,用select xx,xx,xx,xx from来显示你想显示的列
Set DataGrid1.DataSource = rs
DataGrid1.Refresh
Dim rs As New ADODB.Recordset
db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb"
db.Open
rs.CursorLocation = adUseClient
rs.Open "select id,myname sex from usertable", db'在这里控制,用select xx,xx,xx,xx from来显示你想显示的列
Set DataGrid1.DataSource = rs
DataGrid1.Refresh