combox 绑定数据库

combox 有两个属性值：ValueMember 、DisplayMember、前者对应于value、后者对应text 

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;

namespace CheckedlistBox
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            //string strconnection = "server=172.168.1.10;database=wmts;uid=wengtai;pwd=wingtech2013";
            string strconnection = "server=.;database=wmts;uid=sa;pwd=test";
            string strcommand = "select distinct Model from FpOrderNumber";

            using (SqlConnection connection = new SqlConnection(strconnection))
            {
                connection.Open();
                SqlCommand command = new SqlCommand(strcommand, connection);
                SqlDataAdapter adp = new SqlDataAdapter(command);
                DataTable dt = new DataTable();
                adp.Fill(dt);
                comboBox1.DataSource = dt;
                //使用combox.text 获取当前的值时 ValueMember,DisplayMember 二者都可以使用
                //使用comboBox1.SelectedValue获取当前的值时，必须使用ValueMember

                //comboBox1.ValueMember = "Model";
                comboBox1.DisplayMember = "Model";

            }
            //button1.Click += new EventHandler(Button1_Click);
            comboBox1.SelectedValueChanged += new EventHandler(Button1_Click);
            
        }
        
        private void Button1_Click(object sender, EventArgs e)
        {
            string strmessage = string.Empty;

            //strmessage += "Combox选中：" + comboBox1.SelectedValue + "\r";
            strmessage += "Combox选中：" + comboBox1.Text + "\r";

            //strmessage += "Combox选中：" + comboBox1.SelectedText + "\r";
            //strmessage += "Combox选中：" + comboBox1.SelectedItem.ToString() + "\r";

            richTextBox1.AppendText(strmessage);
            richTextBox1.AppendText("\r");
        }
    }

   
}