Click here to Skip to main content
15,888,129 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
My elements on the form in the presentation tier is not binding, i have code snippets below, can anyone point me in the right direction?

Pretension Tier
VB
Private Sub frmCompany_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Dim comCon As New LogicTier.LogicTier.Company
    DataSetCompany = comCon.loadCompanies
    adpCompany.Fill(DataSetCompany)
    enablebinding()
    disablefields()
End Sub
  Private Sub enablebinding()
    txtCompNo.DataBindings.Add("Text", DataSetCompany, "Company.CompanyNo")
   End Sub


Logic Tier

VB
Public Function loadCompanies()
        Dim dtInstance = DBOperations.GetInstance
        Dim dsCompany As DataSet = dtInstance.getCompanyDataSet()
        Return dsCompany
 End Function

Data Tier

VB
Private Sub New()
    Me.connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = winsteelVers5.mdb")

End Sub  

Public Shared ReadOnly Property GetInstance As DBOperations
    Get
        Static Instance As DBOperations = New DBOperations
        Return Instance
    End Get
End Property

Public Function getCompanyDataSet()
    Me.connection.Open()

    Dim daCompany As New OleDbDataAdapter("Select * From Company", Me.connection.ConnectionString)

    Dim dsCompany As New DataSet("Companys")

    daCompany.FillSchema(dsCompany, SchemaType.Source, "Company")
    daCompany.Fill(dsCompany, "Company")

    Return dsCompany
End Function
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900