第一,你在 Page_Load 把数据都绑定到 comboBox1 后 还应加 comboBox1.DataBind(); 才能显示。
第二,你绑定的语句好像有问题,应该是
comboBox1 .DataTextField = "au_id";
comboBox1 .DataValueField = "au_fname";仅供参考!!
第二,你绑定的语句好像有问题,应该是
comboBox1 .DataTextField = "au_id";
comboBox1 .DataValueField = "au_fname";仅供参考!!
drconn.Open();
SqlCommand cmd = new SqlCommand("strcmd",drconn);
SqlDataReader myReader = cmd.ExecuteReader();
while(myReader.Read())
{
DropDownList1.Items.Add(myReader.GetString(0));
}
我是要在winform中實現這個功能
{
string sql="select * from authors";
SqlConnection conn=new SqlConnection ("server=qiqi;database=pubs;uid=sa;pwd=sa;");
SqlDataAdapter adapter=new SqlDataAdapter(sql,conn);
DataTable dt=new DataTable();
adapter.Fill(dt);
comboBox1.DataSource=dt;
comboBox1.DisplayMember="au_id";
comboBox1.ValueMember="au_fname";
}
//添加一个数据
private void button1_Click(object sender, System.EventArgs e)
{
DataTable table = this.comboBox1.DataSource as DataTable;
DataRow row = table.NewRow();
row["au_id"]=-1;
row["au_fname"]="xxx";
table.Rows.Add(row);
}