private void BindCategory()
{
string sql = ReportForm.Properties.Settings.Default.CEC710ConnectionString;
SqlConnection conn = new SqlConnection(sql); DataSet1 myData = new DataSet1();
SqlDataAdapter da = null;
da = new SqlDataAdapter("select b.name from BuildNumber a inner join Category b on a.BNumber = b.BNumber where a.Description = '" + comboBox1.SelectedValue + "'", conn);
da.Fill(myData, "Category"); this.comboBox3.DataSource = myData;
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;
} this.comboBox3.DataSource = myData;
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;这些地方有问题,该怎么绑定呢?我主要是要显示Category的第三列里边的值。
this.comboBox3.ValueMember = myData.Tables[0].Columns[0].ColumnName;
this.comboBox3.DisplayMember = "name";
this.comboBox3.ValueMember = "name";
this.comboBox3.DataSource = myDataTables[0];
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;
{
string sql = ReportForm.Properties.Settings.Default.CEC710ConnectionString;
SqlConnection conn = new SqlConnection(sql); DataSet1 myData = new DataSet1();
SqlDataAdapter da = null;
da = new SqlDataAdapter("select b.name as CategoryName from BuildNumber a inner join Category b on a.BNumber = b.BNumber where a.Description = '" + comboBox1.SelectedValue + "'", conn);
da.Fill(myData, "Category"); this.comboBox3.DataSource = myData;
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;
}
this.comboBox3.DataSource = myData.Tables[0];
this.comboBox3.DisplayMember = "CategoryName";
this.comboBox3.ValueMember = "CategoryName";
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.DataSource = myData;
{
string sql = ReportForm.Properties.Settings.Default.CEC710ConnectionString;
SqlConnection conn = new SqlConnection(sql); DataSet1 myData = new DataSet1();
SqlDataAdapter da = null;
da = new SqlDataAdapter("select b.name as CategoryName from BuildNumber a inner join Category b on a.BNumber = b.BNumber where a.Description = '" + comboBox1.SelectedValue + "'", conn);
da.Fill(myData, "Category"); this.comboBox3.DataSource = myData;
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;
}
this.comboBox3.DataSource = myData.Tables[0];
this.comboBox3.DisplayMember = "CategoryName";
this.comboBox3.ValueMember = "CategoryName";
只输出了一列
DataTable dt = new DataTable();cmbox.DataSource = dt ;
cmbox.DisplayMember ="下拉框显示的TEXT";
cmbox.ValueMember="隐藏的值";
{
string sql = ReportForm.Properties.Settings.Default.CEC710ConnectionString;
SqlConnection conn = new SqlConnection(sql); DataSet1 myData = new DataSet1();
SqlDataAdapter da = null;
da = new SqlDataAdapter("select b.name as CategoryName from BuildNumber a inner join Category b on a.BNumber = b.BNumber where a.Description = '" + comboBox1.SelectedValue + "'", conn);
da.Fill(myData, "Category"); this.comboBox3.DataSource = myData;
this.comboBox3.DisplayMember = "+myData.Tables[0].Columns[2].ColumnName+";
this.comboBox3.ValueMember = "+myData.Tables[0].Columns[2].ColumnName+";
}
/*"DataSource"是要显示的数据集,
"DisplayMember"是ComboBox组件显示的字段,
"ValueMember"是实际使用值。
*/
[
this.comboBox3.DataSource = myData.Tables[0];
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;
这行代码没必要写,注视掉就可以解决我的问题了。完毕。
this.comboBox3.DisplayMember = myData.Tables[0].Columns[2].ColumnName;
this.comboBox3.ValueMember = myData.Tables[0].Columns[2].ColumnName;
和silverlight版本有关系吗?