C--WinForm-中ComboBox数据绑定的问题

Visual C中的数据绑定 2002-02-26 15:49作者：阿虎出处：yesky责任编辑：方舟五 复杂型组件的数据绑定：在上面的介绍中，了解到对复杂型组件的数据绑定是通过设定组件的某些属性来完成数据绑定的。首先来介绍一下ComboBox组件的数据绑定.（1）.ComboBox组件的数据绑定：在得到数据集后，只有设定好ComboBox组件的的三个属性就可以完成数据绑定了，这三个属性是：、DisplayMember、ValueMember。其中DataSource是要显示的数据集，DisplayMember是ComboBox组件显示的字段，ValueMember是实际使用值。具体如下：ComboBox1.DataSource = myDataSet ;ComboBox1.DisplayMember = person.xm ;ComboBox1.ValueMember = person.xm ;注释：此时绑定是Access 2000数据库中person表的xm字段。由此可以得到ComboBox组件数据绑定的源程序代码（Combo01.cs），本代码操作数据库是Access 2000：public class Form1 : Formprivate ComboBox ComboBox1 ;private Button button1 ;private System.Data.DataSet myDataSet ;private System.ComponentModel.Container components = null ;public Form1 ( )file:/打开数据链接，得到数据集GetConnect ( ) ;InitializeComponent ( ) ;file:/清除程序中使用过的资源protected override void Dispose ( bool disposing )if ( disposing )if ( components != null ) components.Dispose ( ) ;base.Dispose ( disposing ) ;private void GetConnect ( )file:/创建一个 OleDbConnectionstring strCon = Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = db.mdb ;OleDbConnection myConn = new OleDbConnection ( strCon ) ;string strCom = SELECT * FROM person ;file:/创建一个 DataSetmyDataSet = new DataSet ( ) ;myConn.Open ( ) ;file:/用 OleDbDataAdapter 得到一个数据集OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ;file:/把Dataset绑定person数据表myCommand.Fill ( myDataSet , person ) ;file:/关闭此OleDbConnectionmyConn.Close ( ) ;private void button1_Click ( object sender , System.EventArgs e )ComboBox1.DataSource = myDataSet ;ComboBox1.DisplayMember = person.xm ;ComboBox1.ValueMember = person.xm ;static void Main ( ) Application.Run ( new Form1 ( ) ) ;图03：对ComboBox组件数据绑定的程序界面 得到了ComboBox组件对本地数据库的数据绑定程序，也就十分方便的得到ComboBox组件绑定Sql Server 2000源程序代码（Combox02.cs）具体如下：public class Form1 : Formprivate ComboBox ComboBox1 ;private Button button1 ;private System.Data.DataSet myDataSet ;private System.ComponentModel.Container components = null ;public Form1 ( )file:/打开数据链接，得到数据集GetConnect ( ) ;InitializeComponent ( ) ;file:/清除程序中使用过的资源protected override void Dispose ( bool disposing )if ( disposing )if ( components != null ) components.Dispose ( ) ;base.Dispose ( disposing ) ;private void GetConnect ( )/ 设定数据连接字符串，此字符串的意思是打开Sql server数据库，服务器名称为server1,数据库为data1string strCon = Provider = SQLOLEDB.1 ; Persist Security Info = False ; User ID = sa ; Initial Catalog = data1 ; Data Source = server1 ;OleDbConnection myConn = new OleDbConnection ( strCon ) ;myConn.Open ( ) ;string strCom = SELECT * FROM person ;file:/创建一个 DataSetmyDataSet = new DataSet ( ) ;file:/用 OleDbDataAdapter 得到一个数据集OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ;file:/把Dataset绑定person数据表myCommand.Fill ( myDataSet , person ) ;file:/关闭此OleDbConnectionmyConn.Close ( ) ;private void button1_Click ( object sender , System.EventArgs e )ComboBox1.DataSource = myDataSet ;ComboBox1.DisplayMember = person.xm ;ComboBox1.ValueMember = person.xm ;static void Main ( ) Application.Run ( new Form1 ( ) ) ;C# WinForm 中ComboBox数据绑定的问题2009-12-29 09:24怎样让WinForm中的ComboBox显示表中的一个字段，同时又绑定另一个字段？ 在Web中的ComboBox这样写可以绑定两个值： this.ComboBox1.DataTextField=B000602;/显示中文，方便用户选择 this.ComboBox1.DataValueField=B000601;/绑定与选择对应的另一个值 this.ComboBox1.DataBind(); 但是在WinForm程序中该怎么写啊？0*DataSet ds = new DataSet();/这个DataSet是你从数据库里取出来的值 string arr = new stringds.Tables0.Rows.Count; for (int i = 0; i arr.Length; i+) arri = ds.Tables0.Rowsi2.ToString(); textBox1.AutoCompleteCustomSource.AddRange(arr); textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource; textBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;1.*假设combobox绑定的列表为DataSet2的ListTable表(含有ListID, ListName字段)，需要绑定的记录字段为DataSet1的Table1表的ListID字段 combobox.DataSource = dataset2.TablesListTable; combobox.DisplayMember = ListName; combobox.ValueMember = ListID; combobox.DataBindings.Add(SelectedValue, dataset1, Table1.ListID);2.*/dt为数据表,ID,Name为dt的两个字段： comboBox1.DataSource = dt ; comboBox1.ValueMember =ID; comboBox1.DisplayMember =Name;3.*SqlConnection con = new SqlConnection(server=98;uid=sa;pwd=sa;database=northwind); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = Select * from Customers where country=USA; SqlDataAdapter adp = new SqlDataAdapter(); adp.SelectCommand = cmd; DataSet ds = new DataSet(); adp.Fill(ds, Customers); comboBox1.DataSource = ds.TablesCustomers; comboBox1.DisplayMember = CompanyName; comboBox1.ValueMember = CompanyName; +或者+ SqlConnection con = new SqlConnection(server=98;uid=sa;pwd=sa;database=northwind); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = Select * from Customers where country=USA; SqlDataAdapter adp = new SqlDataAdapter(); adp.SelectCommand = cmd; DataSet ds = new DataSet(); adp.Fill(ds, Customers); comboBox1.DataSource = ds; comboBox1.DisplayMember = Customers.CompanyName; comboBox1.ValueMember = Customers.CompanyName; +往DataGrid里添加下拉列表+ DataGridTableStyle dgt = new DataGridTableStyle(); dgt.MappingName = test; DataGridTextBoxColumn dgtbc = new DataGridTextBoxColumn(); dgtbc.MappingName = name; dgtbc.HeaderText= name; ComboBox cmbFunctionArea = new ComboBox(); cmbFunctionArea.DataSource = DtGeneral; cmbFunctionArea.DisplayMember = name; cmbFunctionArea.ValueMember = value; cmbFunctionArea.Cursor = Cursors.Arrow; cmbFunctionArea.DropDownStyle= ComboBoxStyle.DropDownList; cmbFunctionArea.Dock = DockStyle.Fill; dgtbc.TextBox.Controls.Add(cmbFunctionArea); dgt.GridColumnStyles.Add(dgtbc); cmbFunctionArea.SelectionChangeCommitted +=new EventHandler(cmbFunctionArea_SelectionChangeCommitted); +修改+ private void cmbFunctionArea_SelectionChangeCommitted(object sender, EventArgs e) (DataTable)dataGrid1.DataSource).RowsdataGrid1.CurrentRowIndex0 = (ComboBox)sender).Text.ToString(); dataGrid1.SetDataBinding(DtGeneral,null); 4.*DataBindings是一般控件所具有的，是绑定数据源的某一个字段 combobox.DataBindings.Add(要绑定控件的属性如下拉框的SelectedValueText, 数据源如dataset1, 导航路径如Table1.ListID); 但是，DataBindings只能绑定一个字段，而绑定多个字段时典型的如列表控件Combobox、ListBox控件，需要键值对，这时就需要指定DataSource（实现IList接口就行），然后指定ValueMember、DisplayMember 。 所以，如果是下拉列表，你只想绑定一个字段，用DataBindings可以，想绑定两个字段 用combobox.DataSource = 数据源; combobox.DisplayMember = 对应显示字段名; combobox.ValueMember = 对应存储字段名; 不要同时用5.* 绑定以后就可以了，读取选中信息 ： object val = combobox.SelectedValue; string txt = combob