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
08/06/2011 23:07:18
 
 
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:
01513731
Message ID:
01513731
Views:
107
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