清楚原有项目,然后更新ComboBox:
ComboBox1.Items.Clear();
DataTable dt = new DataTable();
dt = PubClass.Executesql_Select("select classname from class_v2 where scid='" + scid + "'");
if (dt.Rows.Count > 0) {
int i;
for (i = 0; i < dt.Rows.Count; i++) {
ComboBox1.Items.Add(dt.Rows[i][0]);
}
}
简单的ComboBox 的运用:
DataTable dt = PubClass.Executesql_Select("select classname from class_v2 where scid='"+scid+"'");
string[] array = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++) {
array[i] = dt.Rows[i][0].ToString();
}
bj.DataSource = array;