TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mohammad Ishaq
NA
55
19.1k
Help me to connect the access DB
May 30 2014 2:59 PM
Hello to Everyone
I have a combo box on the VB 2008 form.And i am using Access 2007 as database .Now i want to populate the combo box using Access table data base. For this purpose i have write the code but it gives me error.Please let me clear by any experience person to check and correct the code.
My Access file name is "a". and is available on drive E.
For better understand i have also upload a screenshot.
Public Class Form1
Dim cn As New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;Data Source=E:/a.mdb")
Dim da As New OleDb.OleDbDataAdapter()
Dim dt As New DataTable()
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cn.Open()
ComboBox1.Items.Clear()
Dim r As DataRow
For Each r In dt.Rows
ComboBox1.Items.Add(r(1).ToString)
Next
cn.Close()
End Sub
End Class
Thanks For Your Co-Operation
Attachment:
my screenshot.zip
Reply
Answers (
1
)
How to filter a table two times in mvc View
How to make it default