我是从数据库里直接读的表出来,然后绑定到listbox里的, 建个映射后该怎么做呢? SqlConnection con = new SqlConnection("server=localhost;user id=sa;pwd=;DataBase=cbs"); SqlCommand com = new SqlCommand("select name from sysobjects where xtype='U'", con); con.Open(); SqlDataReader dr = com.ExecuteReader(); biaoListBox.DataTextField = "name"; biaoListBox.DataSource = dr; //ListBox1.DataValueField = "id"; biaoListBox.DataBind(); dr.Close(); con.Close();
Table1====员工表然后绑定的时候设置
ListBox1.DataTextField;
ListBox1.DataValueField;
SqlConnection con = new SqlConnection("server=localhost;user id=sa;pwd=;DataBase=cbs");
SqlCommand com = new SqlCommand("select name from sysobjects where xtype='U'", con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
biaoListBox.DataTextField = "name";
biaoListBox.DataSource = dr;
//ListBox1.DataValueField = "id";
biaoListBox.DataBind();
dr.Close();
con.Close();