绑定一个ComboBox，并填充textBoxes

问题描述

我使用以下代码绑定组合框:

I bindind a Combo Box useing this code:

void InformatiiDespreClient()
        {
            txtNumeClient.Items.Clear();
            Program.Connection.CommandText = "select * from DateClientiAmanet";
            DataTable Table = new DataTable();
            Program.Connection.FillDataTable(Table, true);
            txtNumeClient.DataSource = Table;
            txtNumeClient.DisplayMember = "Nume";
            txtNumeClient.ValueMember = "ClientId";
        }

我像这样设置textBox的值:

I set the value of a textBox like this:

this.lblClientID.Text = txtNumeClient.SelectedValue.ToString();

都很好.

我想在文本框或值更改时填充一些文本框

我写了这段代码，但没有用

All good.

I want, when the textbox, or the value change to fill some TextBoxes

I write this code, but not work

void InformatiiDespreClientDetaliate()
       {
           Program.Connection.CommandText = "select * from DateClientiAmanet where ClientId=" + txtNumeClient.SelectedValue.ToString();
           DataTable Table = new DataTable();
           Program.Connection.FillDataTable(Table, true);
           foreach (DataRow Row in Table.Rows)
           {
               txtNume.Text = Table.Rows[0]["Nume"].ToString() + ", " + Table.Rows[0]["Prenume"].ToString();
               txtAdresa.Text = "Strada: " + Table.Rows[0]["Strada"].ToString() + ", nr.: " + Table.Rows[0]["Numarul"].ToString();
               txtCNP.Text = Table.Rows[0]["CNP"].ToString();
           }
       }

Some sugestions?

推荐答案

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using GestiuneProduse;

namespace FereastraPrincipala.Contracte
{
    public partial class InformatiiContracte : UserControl
    {

        private bool ClientiAdaugati = false;

        public InformatiiContracte()
        {
            InitializeComponent();
            
        }

       

        private void InformatiiContracte_Load(object sender, EventArgs e)
        {
            txtNumeClient.Focus();
            InformatiiDespreClient();
        }

        void InformatiiDespreClient()
        {

            txtNumeClient.Items.Clear();
            Program.Connection.CommandText = "select RTRIM(Nume) + '', ''+ RTRIM(Prenume) AS NumeComplet, ClientId from DateClientiAmanet ORDER BY Nume";
            DataTable Table = new DataTable();
            Program.Connection.FillDataTable(Table, true);

            txtNumeClient.DataSource = Table;
            txtNumeClient.DisplayMember = "NumeComplet";
            txtNumeClient.ValueMember = "ClientId";
            ClientiAdaugati = true;

        }


        void InformatiiDespreClientDetaliate()
        {

            Program.Connection.CommandText = "select * from DateClientiAmanet where ClientId=" + txtNumeClient.SelectedValue.ToString();
            DataTable Table = new DataTable();
            Program.Connection.FillDataTable(Table, true);
            foreach (DataRow Row in Table.Rows)
            {
                txtNume.Text = Table.Rows[0]["Nume"].ToString() + ", " + Table.Rows[0]["Prenume"].ToString();
                txtAdresa.Text = "Strada " + Table.Rows[0]["Strada"].ToString() + ", nr. " + Table.Rows[0]["Numarul"].ToString() + ", bl. " + Table.Rows[0]["Bloc"].ToString() + ", sc. " + Table.Rows[0]["Scara"].ToString() + ", et. " + Table.Rows[0]["Etajul"].ToString() + ", ap. " + Table.Rows[0]["Apartament"].ToString();
                txtCNP.Text = Table.Rows[0]["CNP"].ToString();

            }

            this.txtBoxDetaliiClient.Text = "Client: " + txtNumeClient.SelectedValue.ToString();
        }

        private void txtNumeClient_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (this.ClientiAdaugati)
                InformatiiDespreClientDetaliate();

        }

        
    }
}

这篇关于绑定一个ComboBox，并填充textBoxes的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！