Question How to make textbox fetch data from a table

[wizard2773]

Hi, how does one manage to make a textbox fetch data from a table record field in ms access database after selecting a record id in a combobox and the value in the textbox must keep changing with the record id in the combobox selected, i managed to make the combobox fetch the record id's from the table field.

Here is my code:

Imports System.Data.OleDb
Module Module1
Public acsconn As New OleDb.OleDbConnection
Public acsdr As OleDbDataReader
Public strsql As String
Sub connect()
acsconn.ConnectionString = "PROVIDER=Microsoft.ACE.OLEDB.12.0; data source=|datadirectory|\FranklinMachine.accdb;"
acsconn.Open()
End Sub
End Module

Public Class frmFranklinManager
Sub fillcombo()
strsql = "select * from tblFranklin"
Dim acscmd As New OleDb.OleDbCommand
acscmd.CommandText = strsql
acscmd.Connection = acsconn
acsdr = acscmd.ExecuteReader
While (acsdr.Read())
ComboBox1.Items.Add(acsdr("FranklinName"))

End While

acscmd.Dispose()
acsdr.Close()


End Sub

PLEASE HELP!

 

[vks_gautam]

you should write your code in combobox selection change event.
"select * from tblFranklin where ........@feild"
use parameter query.
if you don't know here is the link for that
FAQ: How do I make a parameterized query in the database with VB.NET?
if you still find problem u can ask here

 

[jmcilhinney]

You should bind the data to both controls. You then don't need any code to update the TextBox when the selection in the ComboBox changes.

command.CommandText = "SELECT ID, Name FROM SomeTable"

Dim table As New DataTable

Using reader = command.ExecuteReader()
    table.Load(reader)
End Using

With idComboBox
    .DisplayMember = "ID"
    .ValueMember = "ID"
    .DataSource = table
End With

nameTextBox.DataBindings.Add("Text", table, "Name")