Avatar of code_me
code_me

asked on 

how to populate listbox From Database in windows form applicaton

how can I Populate the listbox
from Database
the database is sql
Visual Basic.NET

Avatar of undefined
Last Comment
Dirk Haest
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

replace id and onefield:

Dim MyConnection As SqlConnection = New SqlConnection("server=.....................)
        Dim MyCommand As SqlDataAdapter = New SqlDataAdapter("select .............", MyConnection)
        Dim DS As DataSet = New DataSet()

        MyCommand.Fill(DS, "dsListBox")

        MyListBox.DataSource = DS.Tables("dsListBox").DefaultView
        MyListBox.DataValueField = "id"
        MyListBox.DataTextField = "onefield"
        MyListBox.DataBind()
ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo