Datagrid中显示列的问题？

[kjset]

请问怎样在DATAGRID中随意显示我想显示的列，（例如我只想显示1，3，5而2，4，6不显示）

[tztz520]

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

[lmshj]

问个问题，怎样发问？

[GGL123]

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

[Andy__Huang]

在綁定數據庫的sql語句里﹐不要用select * from tb

而是用select col1,col3,col5....from tb