Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can i select only 2 field in table to DataGridView
Message
De
11/06/2011 01:04:38
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
How can i select only 2 field in table to DataGridView
Versions des environnements
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01514107
Message ID:
01514107
Vues:
103
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
Répondre
Fil
Voir

Click here to load this message in the networking platform