当我从组合框中选择项目时，如何从数据库填充文本框 [英] How to populate a textbox from database when I select an item from combo box

问题描述

这就是我想要发生的事情：当我从组合框中选择一个项目时，文本框将自动填充数据



当我选择第1列的clientName时，我想用联系人填充文本框，该联系人是客户表的第2列。



我有什么试过：



这是我试过的：

This is what i want to happen: When i select an item from the combobox the textbox will automatically be filled with data

When i select a clientName which is column 1, i want to populate the textbox with contact person which is column 2 of the Clients table.

What I have tried:

this is what i tried:

 'Populate the combox with clientnames from clients '

        Try
            connection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Nikko Jaze Fabellon\Documents\ASRASIM.accdb")
            connection.Open()
            ds = New DataSet
            tables = ds.Tables
            dataAdapter = New OleDbDataAdapter("SELECT [ClientName] from [Clients] where [Status] = 'Active' ", connection)
            dataAdapter.Fill(ds, "Clients")
            Dim view1 As New DataView(tables(0))
            With clientNameText
                .DataSource = ds.Tables("Clients")
                .DisplayMember = "ClientName"
                .ValueMember = "ClientName"
                .SelectedIndex = 0
                .AutoCompleteMode = AutoCompleteMode.SuggestAppend
                .AutoCompleteSource = AutoCompleteSource.ListItems
            End With

'This is where i would enter the codes'

            With clientNameText
                .DisplayMember = "Contact Person"
                .ValueMember = "Contact Person"
                .DataSource = ds.Tables
            End With



            cPersonText.DataBindings.Add("", ds.Tables, "")

推荐答案

正如Maciej所暗示的那样 - 您没有从数据库中提取联系人。您需要更多类似的内容（警告 - 我没有以任何方式进行测试）

As hinted by Maciej - you are not extracting the contact person from the database. You need something more like the following (warning - I have not tested in any way)

taAdapter = New OleDbDataAdapter("SELECT [ClientName],[Contact Person] from [Clients] where [Status] = 'Active' ", connection)
.
.
.
                .DisplayMember = "ClientName"
                .ValueMember = "Client Person"
.
.
.

然后，您可以参考所选行的ValueMember来填充文本框

You can then refer to the ValueMember of the selected row to populate your textbox

这篇关于当我从组合框中选择项目时，如何从数据库填充文本框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！