我的代码是这样的
string source = "server = CCTV;"+
"Integrated Security = SSPI;"+
"database = vehicle;"+
"Connect Timeout = 10";
string select = "SELECT DISTINCT model FROM vehicle";
SqlConnection conn = new SqlConnection(source);
SqlDataAdapter da = new SqlDataAdapter(select,conn);
DataSet ds = new DataSet();
da.Fill(ds,"vehicle");
comboBox1.DataBindings.Add(new Binding("Text",ds,"vehicle.model"));但是运行结果显示了一个结果
string source = "server = CCTV;"+
"Integrated Security = SSPI;"+
"database = vehicle;"+
"Connect Timeout = 10";
string select = "SELECT DISTINCT model FROM vehicle";
SqlConnection conn = new SqlConnection(source);
SqlDataAdapter da = new SqlDataAdapter(select,conn);
DataSet ds = new DataSet();
da.Fill(ds,"vehicle");
comboBox1.DataBindings.Add(new Binding("Text",ds,"vehicle.model"));但是运行结果显示了一个结果
ComboBox1.DataSource = myDataSet ;//数据集
ComboBox1.DisplayMember = "person.userId" ;//表名加字段名
ComboBox1.ValueMember = "person.username" ;this.ComboBox1.DataSource = myDataTable;//数据表
this.ComboBox1.DisplayMember = "Name";//字段名
this.ComboBox1.ValueMember = "userId";//字段名
comboBox1.DataSource = ds.Tables[0];
comboBox1.DisplayMember = "model";
comboBox1.ValueMember = "model";如果有值字段,如model_id,那可以:
comboBox1.DataSource = ds.Tables[0];
comboBox1.DisplayMember = "model";
comboBox1.ValueMember = "model_id";