如何combobox 数据绑定??

如何combobox 数据绑定??,第1张

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事件里面去


欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/sjk/9885159.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-05-03
下一篇 2023-05-03

发表评论

登录后才能评论

评论列表(0条)

保存