Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i select only 2 field in table to DataGridView
Message
From
11/06/2011 01:04:38
 
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
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:
01514107
Message ID:
01514107
Views:
102
Hi all,
I use vb.net and dataset. Data table funclib (hase funcid,funcname,seqno,dunctype field), i want to only select 2 field in data table to DataGridView.But i try the below code can't it , it also show all table fields .How can i do, anyone know,thank you ?
 Dim qs As String = "select funcid ,funcname from funclib"
        connection()
        cn.Open()
        da = New SqlDataAdapter(qs, cn)
        
        da.Fill(WilsonDataSet, "funclib")
     treeGridView1.DataSource =WilsonDataSet.funclib
Reply
Map
View

Click here to load this message in the networking platform