ACCESS数据库的 城市级联 怎么在下拉的控件显示

[「已注销」]

省显示出来了 ，下面的是市，要怎么显示出来

public void bindCityName()
        {
            string sql = "select * from TB_Area where parentId=0";
            DataSet ds = DBHelp.GetDataSet(sql);
            comsheng.DisplayMember = "Name";
            comsheng.ValueMember = "Id";
            comsheng.DropDownStyle = ComboBoxStyle.DropDownList;
            comsheng.DataSource = ds.Tables[0];

        }

        private void comsheng_SelectedIndexChanged(object sender, EventArgs e)
        {
            
            if (comsheng.SelectedItem != null)
            {
                comshi.Enabled = true;
                string sql = " select*from TB_Area where parentId=comsheng.SelectedItem.value";
                DataSet ds=DBHelp.GetDataSet(sql);
                comshi.DisplayMember = "Name";
                comshi.ValueMember = "Id";
                comshi.DropDownStyle = ComboBoxStyle.DropDownList;
                comshi.DataSource=ds.Tables[0];
            }

        }

[孟子E章]

string sql = " select * from TB_Area where parentId=" + comsheng.SelectedItem.value;

[「已注销」]

[Quote=引用 1 楼 net_lover 的回复:]
string sql = " select * from TB_Area where parentId=" + comsheng.SelectedItem.value;
[/Quote]

这样写 后面的VALUE 用不了 新手求教

[「已注销」]

弄好了，谢谢大神指教.....