database

Dear

Create a table in access with three fields:

a. accno

b. name

c. balance

Create a temporary dataset with one method : GetAccountHolders()

Write The following code in Page Load:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim adapter As New DataSet1TableAdapters.bankinfoTableAdapter
        Dim dt As DataTable = adapter.GetAccountHolders()
        DropDownList1.DataSource = dt
        DropDownList1.DataTextField = "Name"
        DropDownList1.DataValueField = "accno"
        DropDownList1.DataBind()
    End Sub

Import the namespaces

a. System.Data

b. System.Data.OLEDB

Thanks