combobox.Items.Clear()
dtTable = new DataTable()
strSQL = "select 栏位 from 表"
strResult = DBLink.executeQuery(strSQL, dtTable)
if (!strResult.Equals(""))
{
MessageBox.Show("查询时发生异常!")
}
else
for (int i = 0i <= dtTable.Rows.Count - 1i++)
combobox.Items.Add(dtTable.Rows[i][0].ToString())
dtTable.Dispose()
dtTable = null。
WPF中提供了数据绑定的功能, *** 作起来很方便,集合类的控件几乎都可以用数据源来进行数据的绑定,下面 *** 作一下下拉列表框控件ComboBox控件的数据绑定 *** 作。
要绑定到ComboBox控件的自定义类:
public class LocationRoad
{
public int ID { setget}
public string Code { setget}
public string Info { setget}
}
建立数据源,就将此数据集合当作数据源绑定到ComboBox:
///
/// 当ComboBox选中项更改时发生
///
private LocationRoad _selectLocation
public LocationRoad SelectLocation
{
get
{
return this._selectLocation
}
set
{
this._selectLocation = value
if (this.PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs("SelectLocation"))
}
}
private ObservableCollection _locationRoad = null
public ObservableCollection LocationSource
{
get
{
if (this._locationRoad == null)
{
this._locationRoad = new ObservableCollection() {
new LocationRoad() { ID = 1, Code = "NGQ", Info = "南岗区" },
new LocationRoad() { ID = 2, Code = "DLQ", Info = "道里区" },
new LocationRoad() { ID = 3, Code = "DWQ", Info = "道外区" },
new LocationRoad() { ID = 4, Code = "PFQ", Info = "平房区" },
new LocationRoad() { ID = 5, Code = "XFQ", Info = "香坊区" },
}
}
return this._locationRoad
}
set
{
this._locationRoad = value
if (this.PropertyChanged != null)
PropertyChanged(this, new PropertyChangedEventArgs("LocationSource"))
}
}
你把你的数据代码放在 comboBox1_SelectedIndexChanged里面是干什么啊,你这个永远都不会执行的!!把你的
connection = new SqlConnection(connString)
string cid = comboBox1.SelectedValue.ToString()
string sql = string.Format("Select item from article where article_ID=[0]", cid)
try
{
dataAdapter = new SqlDataAdapter(sql,connection)
DataSet da = new DataSet()
dataAdapter.Fill(da)
comboBox1.DataSource = da.Tables[0]
comboBox1.ValueMember = "article_ID"
comboBox1.DisplayMember = "item"
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, " *** 作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
}
finally
{
connection.Close() // 关闭数据库连接
}
这段代码放在窗体的load事件里面去
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)