DataSet根据选取的字段关联其他表格中对应的行

        private void JCK_HJQ_SelectionChanged(object sender, CellRangeEventArgs e)
        {
            C1FlexGrid grid=sender as C1FlexGrid;
            int index = grid.SelectedIndex;
             DataRow dRow= GUIHUA.Tables["JCK_HJQ"].Rows[index];
             string hjqName =(string) dRow["HJQMC"];
             string selectStr = "GSHJQ='" + hjqName + "'";

             DataView dtview = new DataView(GUIHUA.Tables["JCK_ZHYWJRQ"]);
             dtview.RowFilter = selectStr;
             JCK_ZHYWJRQ.ItemsSource = dtview; 
         
        }

其中GUIHUA为DataSet类型，包含两个DataTable，分别是JCK_HJQ和JCK_ZHYWJRQ，对应的HJQMC和GSHJQ为关联字段。