something like (in VB.NET0Dim catDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Categories", nwindConn) Dim MyDS As New DataSet() catDA.Fill(MyDS, "Categories") Dim Mytable As DataTable Mytable = MyDS.Tables("Categories") Mytable.Columns("CategoryID").ColumnMapping = MappingType.Hidden DataGrid1.DataSource = Mytable
dataview只支持一个表,而我想要表中的部分列
datagrid->TableStyles->GridColumnStyles,只加你想要的列
Dim MyDS As New DataSet()
catDA.Fill(MyDS, "Categories")
Dim Mytable As DataTable
Mytable = MyDS.Tables("Categories")
Mytable.Columns("CategoryID").ColumnMapping = MappingType.Hidden
DataGrid1.DataSource = Mytable
里选择了自己要的几列,可是当我Adapter.fill的时候还是显示了全部的列啊!!!怎么回事