How can i select only 2 field in table to DataGridView
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01512304
Message ID:
01512304
Views:
95
Hi all, I use vb.net ,i want to only select 2 field in table to DataGridView.But i try the below code can't it , it also show all table fields .How can i do?
Dim qs AsString = "select funcid funcname from funclib"connection()
cn.Open()
da = NewSqlDataAdapter(qs, cn)
da.Fill(WilsonDataSet, "funclib")
treeGridView1.DataSource =WilsonDataSet.funcname