Filling MS Access Data Records to ComboBox in VB.Net

0
82

This tutorial is all about Filling MS Access Data Records to ComboBox in VB.Net. In this Tutorial you will learn Filling MS Access Data Records to ComboBox in VB.Net. So let’s get Started:

  • First is that you have created a MS Access Database file and it should have been put in to the Bin Folder of your Visual Basic Project.

 

  • Open the Visual Basic, Select File on the menu, then click New and create a new project.

 

 

  • Then a New Project Dialog will appear. You can rename your project, depending on what you like to name it. After that click OK

  • After that, design your form like this just like what I’ve shown you below.
    Add a ComboBox from the toolbox.
  • Add this following Codes before the Public Class Form1 Line.
    1. Imports System.Data.OleDb
  • Then, Add this following Declarations below the Public Class Form1 Line.
    1. Public myConnToAccess As OleDbConnection
    2. Dim mySQLCommand As OleDbCommand
    3. Dim mySQLStrg As String
    4. Dim ds As DataSet
    5. Dim da As OleDbDataAdapter
    6. Dim tables As DataTableCollection
  • Finally, add this code to the Form load event.
    1. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    2. myConnToAccess = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Clive\Documents\Visual Studio 2008\clive projects\TableRecordsinCombobox\TableRecordsinCombobox\bin\Debug\Datalist.accdb")
    3. myConnToAccess.Open()
    4. ds = New DataSet
    5. tables = ds.Tables
    6. da = New OleDbDataAdapter("SELECT FULLNAME from tblname", myConnToAccess)
    7. da.Fill(ds, "tblname")
    8. Dim view1 As New DataView(tables(0))
    9. With ComboBox1
    10. .DataSource = ds.Tables("tblname")
    11. .DisplayMember = "FULLNAME"
    12. .ValueMember = "FULLNAME"
    13. .SelectedIndex = 0
    14. .AutoCompleteMode = AutoCompleteMode.SuggestAppend
    15. .AutoCompleteSource = AutoCompleteSource.ListItems
    16. End WithEnd Sub
  • Click F5 to Run the program.

If you have any comments or suggestions about on Filling MS Access Data Records to ComboBox in VB.Net, please feel free to contact our webpage.

Download Filling MS Access Data Records to ComboBox in VB.Net Here

Other Articles Readers might read:

 

 

Facebook Comments
(Visited 107 times, 1 visits today)

LEAVE A REPLY

Please enter your comment!
Please enter your name here