combox绑定问题,现在提示我用户代码未处理 System.ArgumentException,无法创建字段 car_park_fee_card 的子列表。"
private void park_fee_out_Load(object sender, EventArgs e)
{
string card_class_sql = "select * from car_park_fee_card order by card_id asc";
SqlConnection class_conn = new SqlConnection(fee_conn.sql_conn());
DataSet combox = new DataSet();
class_conn.Open();
SqlDataAdapter mycmd = new SqlDataAdapter(card_class_sql,class_conn);
mycmd.Fill(combox,"ds");
class_conn.Close();
dl_card_class.DataSource = combox;
dl_card_class.DisplayMember = "car_park_fee_card.card_name";
dl_card_class.ValueMember = "car_park_fee_card.card_id";
}
private void park_fee_out_Load(object sender, EventArgs e)
{
string card_class_sql = "select * from car_park_fee_card order by card_id asc";
SqlConnection class_conn = new SqlConnection(fee_conn.sql_conn());
DataSet combox = new DataSet();
class_conn.Open();
SqlDataAdapter mycmd = new SqlDataAdapter(card_class_sql,class_conn);
mycmd.Fill(combox,"ds");
class_conn.Close();
dl_card_class.DataSource = combox;
dl_card_class.DisplayMember = "car_park_fee_card.card_name";
dl_card_class.ValueMember = "car_park_fee_card.card_id";
}
{
string card_class_sql = "select card_id,card_name from car_park_fee_card order by card_id asc";
SqlConnection class_conn = new SqlConnection(fee_conn.sql_conn());
DataSet combox = new DataSet();
class_conn.Open();
SqlDataAdapter mycmd = new SqlDataAdapter(card_class_sql,class_conn);
mycmd.Fill(combox,"ds");
class_conn.Close();
dl_card_class.DataSource = combox;
dl_card_class.DisplayMember = "card_name";
dl_card_class.ValueMember = "card_id";
}
-----------
dl_card_class.DataSource = combox.tables["ds"];
dl_card_class.DisplayMember = "
car_park_fee_card.card_name";dl_card_class.ValueMember = "
car_park_fee_card.card_id";dl_card_class.DisplayMember = "car_park_fee_card.card_name";
dl_card_class.ValueMember = "car_park_fee_card.card_id";
dl_card_class.DataSource=combox.Tables[0];
dl_card_class.DisplayMember = "card_name";
dl_card_class.ValueMember = "card_id";
指定列明就行,不应该带表名
dl_card_class.DisplayMember = "card_name";
dl_card_class.ValueMember = "card_id";
这样就可以