在delphi中如何用combobox实现分级读取数据库中的内容

你可以在combobox1的OnChange事件里写代码

adoquery1.Close

adoquery1.SQL.Clear

adoquery1.SQL.Add('SELECT

distinct

XXX

from

CPU

where

brand='''+combobox1.text+'''')

adoquery1.Open

combobox2.Items.Clear

while

not

adoquery1.Eof

do

begin

combobox2.Items.Add(adoquery1.fieldbyname('XXX').AsString)

adoquery1.Next

end

依次类推，在combobox2的OnChange事件再写事件啊！

//创建一个DataTable用于存储数据，有两列：Name,Value

DataTable dt = new DataTable()

dt.Columns.Add("Name")

dt.Columns.Add("Value")

dt.Rows.Add("请选择", -1)

dt.Rows.Add("张三", 1)

dt.Rows.Add("李四", 2)

dt.Rows.Add("王五", 3)

//将Combobox绑定到DataTable，Name列显示到画面上，Value列是对应的数据

comboBox1.DataSource = dt

comboBox1.DisplayMember = "Name"

comboBox1.ValueMember = "Value"

//在combobox的SelectedIndexChanged事件中添加如下方法

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{

string value = this.comboBox1.SelectedValue.ToString()

Console.WriteLine("当前选中的是 " + value)

}

两种方法：

1. 绑定数据源：

comboBox1.DataSource=ds.Tables[0]comboBox1.DisplayMenber="<a href="https://www.baidu.com/s?wd=%E5%AD%97%E6%AE%B5%E5%90%8D&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLPH-hmvckuHI9mHu-PADs0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En10LPW01PHD4" target="_blank" class="baidu-highlight">字段名</a>"comboBox1.Text="<a href="https://www.baidu.com/s?wd=%E5%88%9D%E5%A7%8B%E5%8C%96&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLPH-hmvckuHI9mHu-PADs0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En10LPW01PHD4" target="_blank" class="baidu-highlight">初始化</a>值"

2. 添加删除记录方法：

//添加for(int i=0i<list.Counti++){ comboBox1.Items.Add(list[i])} //删除comboBox1.Items.RemoveAt(Index)

---