dataGrid中显示主从表（点击主表的行后显示从表）

 string constr = "server=(local);uid=sa;pwd=123456; database=信息中心科技资料管理数据库";
            SqlConnection con = new SqlConnection(constr);

            string  com1 = "select * from 资料信息表";
            string  com2 = "select * from 资料借阅表";

            SqlDataAdapter ada1 = new SqlDataAdapter(com1,con);

            SqlDataAdapter ada2 = new SqlDataAdapter(com2,con);

            DataSet ds = new DataSet();

            ada1.Fill(ds, "资料信息表");
            ada2.Fill(ds, "资料借阅表");
            ds.Relations.Add("rel", ds.Tables["资料信息表"].Columns["档号"], ds.Tables["资料借阅表"].Columns["所借阅资料的档号"]);                             //定义关系后才能显示

            
            DataGrid datagrid = new DataGrid();
        
            datagrid.Location = new System.Drawing.Point(0, 0);
            datagrid.Size = new System.Drawing.Size(1000, 1000);
            datagrid.SetDataBinding(ds, "资料信息表");
          
            this.Controls.Add(datagrid);