日期:2014-05-18 浏览次数:21167 次
private void RegisterForm_Load(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection("server=root_db;database=users;uid=sa;password=");
    SqlDataAdapter da = new SqlDataAdapter("select group_id, group_name from mygroup", con);
    DataSet ds = new DataSet();
    da.Fill(ds, "group");
    DataTable dtGroup = ds.Tables["group"];
    comboBox1.DataSource = dtGroup;
    comboBox1.DisplayMember = "group_name";
    comboBox1.ValueMember = "group_id";
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    if (comboBox1.SelectedIndex > -1)
    {
        //注意以下两行代码,估计人的错误就在这里
        DataRowView drv = (DataRowView)comboBox1.SelectedItem;
        string gId = drv.Row["group_id"].ToString();
        SqlConnection con = new SqlConnection("server=root_db;database=users;uid=sa;password=");
        SqlDataAdapter da = new SqlDataAdapter("select user_id, user_name from myuser where group_id='" + gId + "'", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "user");
        DataTable dtUser = ds.Tables["user"];
        comboBox2.DataSource = dtUser;
        comboBox2.DisplayMember = "user_name";
        comboBox2.ValueMember = "user_id";
    }
}