namespace TwoComboBoxs
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        NorthwindDataSet.ProductsDataTable productTable = new NorthwindDataSet.ProductsDataTable();
        NorthwindDataSet.CategoriesDataTable categoryTable = new NorthwindDataSet.CategoriesDataTable();
        
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            
            DataRowView rowView = comboBox1.SelectedItem as DataRowView;
         
           

             NorthwindDataSet.CategoriesRow row = rowView.Row as NorthwindDataSet.CategoriesRow;
         
            int id = row.CategoryID;
            productTable.DefaultView.RowFilter = string.Format("CategoryID = {0}", id);
            
        }
      

        private void Form1_Load(object sender, EventArgs e)
        {
            
            NorthwindDataSetTableAdapters.CategoriesTableAdapter categoryAdapter = new TwoComboBoxs.NorthwindDataSetTableAdapters.CategoriesTableAdapter();
            categoryAdapter.Fill(categoryTable);
             = categoryTable.DefaultView;
            comboBox1.DisplayMember = categoryTable.CategoryNameColumn.ColumnName;
            

            NorthwindDataSetTableAdapters.ProductsTableAdapter productAdapter = new NorthwindDataSetTableAdapters.ProductsTableAdapter();
            productAdapter.Fill(productTable);
             = productTable.DefaultView;
            comboBox2.DisplayMember = productTable.ProductNameColumn.ColumnName;
           
           


        }

    }
}
这里面用的是northwind,看不太懂，有没有sql server 相关的语句可以替换一下的

千万别沉呀！！！ 有没有神呀！！！

那换个问题吧
  DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter("select G_number from 商品表", conn);
            da.Fill(ds, "G_number");
            DataTable dt = ds.Tables[0];
            comboBox2.DataSource = dt;
            comboBox2.DisplayMember = "G_number";
            comboBox2.SelectedIndex = -1;    是form_load 中对combobox2的出定义，连接商品表中的G_number

  DataSet ds1 = new DataSet();
            SqlDataAdapter da1 = new SqlDataAdapter("select G_name from 商品表", conn);
            DataTable dt1 = ds.Tables[0];
            comboBox3.DataSource = dt1;
            comboBox3.DisplayMember = "G_name";
            comboBox3.ValueMember = "G_name";
            comboBox3.SelectedIndex = -1;  是form_load 中对combobox3的出定义，连接商品表中的G_name
 想选定combobox2中的下拉项时，combobox3中的值跟着改变


 private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            string strSQL1 = "Select G_name from 商品表 where G_number=";
            strSQL1 += comboBox2.Text;
            DataSet ds1 = new DataSet();
            SqlDataAdapter da1 = new SqlDataAdapter(strSQL1, conn);
            da1.Fill(ds1, "商品表");
            DataTable dt1 = ds1.Tables["商品表"];
            comboBox3.DataSource = dt1;
            comboBox3.DisplayMember = "G_name";
            comboBox3.SelectedIndex = -1;

            

        }

现在提示错误无法绑定由多个部分组成的标识符 "System.Data.DataRowView"。
为什么

那句没有问题可以通过