Member Avatar for romes

hi ive been trying to insert specific data into a certain textbox from an access table, ive managed to pull the information from one field onto a listbox but i cant grab specific data and load it onto a textbox: here is the code, if anyone can help please that would be great...

    Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\student.mdb;User Id=admin;Password=;"
    Dim dataBaseConnection As New OleDbConnection(cnString)
    Dim dataBaseCommand As New OleDbCommand("SELECT Name FROM Student WHERE Student Number = """ & txtSearch.Text & """", dataBaseConnection)
    Dim dataReader As OleDbDataReader
    Try
        dataBaseConnection.Open()
        dataReader = dataBaseCommand.ExecuteReader()
        dataSet.Tables.Add(dataTable)
        dataSet.Tables(0).Load(dataReader)


        'Manual Binding - ultimate control
        Dim i As Integer

        For i = 0 To dataSet.Tables(0).Rows.Count - 1
            txtStuName.Text.Contains(dataSet.Tables(0).Rows(i).Item("Name").ToString())
        Next
    Catch ex As Exception
    End Try
Edited by TrustyTony because: fixed formatting
  • 2 Contributors
  • 1 Reply
  • 93 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by binoj_daniel
Member Avatar for binoj_daniel

Please read this article on how to connect to an access DB and fetch results. I will be posting more articles with samples soon. Click here

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.