ComboBox控件动态绑定的数据,如何从代码里实现某个字段的显示 ComboBox控件动态绑定的数据,如何从代码里实现某个字段的显示啊!要显示的字段也是从数据库中得来的一条记录。 也就是说绑定的是动态的数据,显示的也是动态的数据! 两边都是动态的!有方法吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 绑定到ComboBox的下拉列表ComboBox.dataSource = dataTable2ComboBox.displaymember = dataTable2.column1ComboBox.valuemember= dataTable2.column2绑定到bindingSourse1ComboBox.DataBindings.Add("SelectedValue", bindingSourse1, "绑定的列名", true); 假设要显示表BindData中的DataValue字段//建立Sql连接SqlConnection conn = new SqlConnection("xxxxxxxxxxx");SqlCommand cmd = new SqlCommand("SELECT * FROM BindData", conn);SqlDataAdapter adapter = new SqlDataAdapter(cmd);DataSet dataSet = new DataSet();try{ adapter.Fill(dataSet, "BindData"); ComboBox cmbData = new ComboBox(); //将ComboBox绑定到DataSet cmbData.DataSource = dataSet; //设定要显示的字段 cmbData.DisplayMember = "DataValue";}catch(Exception ex){ MessageBox.Show(ex.Message);}finally{ conn.Close();} 绑定到ComboBox的下拉列表 ComboBox.dataSource = dataTable2 ComboBox.displaymember = dataTable2.column1 ComboBox.valuemember= dataTable2.column2 绑定到bindingSourse1 ComboBox.DataBindings.Add("SelectedValue", bindingSourse1, "绑定的列名", true); 示例代码:private void ListUser() { //初始化DataSet System.Data.DataSet DS = new System.Data.DataSet(); //初始化XML架构文件操作流 //FileStream FsXSD = new FileStream(@"c:\User.xsd", FileMode.Open); //初始化XML架构读取设备 //XmlTextReader xtrXSD = new XmlTextReader(FsXSD); //载入XML架构到DS中 DS.ReadXmlSchema(@"c:\User.xsd"); //关闭XML架构读取设备 //xtrXSD.Close(); //关闭XML架构文件操作流 //FsXSD.Close(); //按照装载了的XML架构载入XML数据到DS DS.ReadXml(@"c:\User.XML", XmlReadMode.InferSchema); UserNameCBox.DataSource = DS.Tables[0]; UserNameCBox.DisplayMember = "UserName"; UserNameCBox.ValueMember = "UserName"; UserNameCBox.DataBindings.Add("SelectedValue", DS.Tables[0], "UserName"); label1.Text = DS.Tables[0].Rows.Count.ToString(); } ComboBox1.DataSource = myDataSet ;//数据集ComboBox1.DisplayMember = "person.userId" ;//表名加字段名ComboBox1.ValueMember = "person.username" ;this.ComboBox1.DataSource = myDataTable;//数据表this.ComboBox1.DisplayMember = "Name";//字段名this.ComboBox1.ValueMember = "userId";//字段名 串口猫收发短信的问题! c#中除法怎么写? C# 跨线程控件取值问题 DateTime.Parse(dateTimePicker1.Text)去掉0:00:00 ConnectionString 属性尚未初始化 DateTime转换问题??? 急!打开一个指定的目录 怎么样用一个指定的Rectangle 来限制 MDI父窗体的工作区 在.net下如何设置excel的行高,我说的是c#,网上好象没有!!! VS.NET2003 ENTERPRISE ARCHITECT有设计工具吗?就像VS.NET的VISIO一样的? Combobox数据绑定的问题 这个控件的属性真奇怪
ComboBox.dataSource = dataTable2
ComboBox.displaymember = dataTable2.column1
ComboBox.valuemember= dataTable2.column2
绑定到bindingSourse1
ComboBox.DataBindings.Add("SelectedValue", bindingSourse1, "绑定的列名", true);
SqlConnection conn = new SqlConnection("xxxxxxxxxxx");
SqlCommand cmd = new SqlCommand("SELECT * FROM BindData", conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);DataSet dataSet = new DataSet();try
{
adapter.Fill(dataSet, "BindData");
ComboBox cmbData = new ComboBox();
//将ComboBox绑定到DataSet
cmbData.DataSource = dataSet;
//设定要显示的字段
cmbData.DisplayMember = "DataValue";
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
ComboBox.dataSource = dataTable2
ComboBox.displaymember = dataTable2.column1
ComboBox.valuemember= dataTable2.column2
绑定到bindingSourse1
ComboBox.DataBindings.Add("SelectedValue", bindingSourse1, "绑定的列名", true);
{
//初始化DataSet
System.Data.DataSet DS = new System.Data.DataSet();
//初始化XML架构文件操作流
//FileStream FsXSD = new FileStream(@"c:\User.xsd", FileMode.Open);
//初始化XML架构读取设备
//XmlTextReader xtrXSD = new XmlTextReader(FsXSD);
//载入XML架构到DS中
DS.ReadXmlSchema(@"c:\User.xsd");
//关闭XML架构读取设备
//xtrXSD.Close();
//关闭XML架构文件操作流
//FsXSD.Close();
//按照装载了的XML架构载入XML数据到DS
DS.ReadXml(@"c:\User.XML", XmlReadMode.InferSchema);
UserNameCBox.DataSource = DS.Tables[0];
UserNameCBox.DisplayMember = "UserName";
UserNameCBox.ValueMember = "UserName";
UserNameCBox.DataBindings.Add("SelectedValue", DS.Tables[0], "UserName");
label1.Text = DS.Tables[0].Rows.Count.ToString();
}
ComboBox1.DisplayMember = "person.userId" ;//表名加字段名
ComboBox1.ValueMember = "person.username" ;this.ComboBox1.DataSource = myDataTable;//数据表
this.ComboBox1.DisplayMember = "Name";//字段名
this.ComboBox1.ValueMember = "userId";//字段名