GridControl主从表的数据绑定以及从表事件

来源：互联网发布：最新免费手机电影软件编辑：程序博客网时间：2024/06/06 18:49

主从表的数据绑定：

DataSet ds = new DataSet();

//主表
DataTable dtMaster = new DataTable("dtMaster");

//从表
DataTable dtDetail = new DataTable("dtDetail");

//加入DataSet

ds.Tables.Add(dtMaster);
ds.Tables.Add(dtDetail);

//设置主从键关系

DataColumn keyColumn = myDs.Tables["dtMaster"].Columns["masterId"]; //主键

DataColumn foreignColumn = myDs.Tables["dtDetail"].Columns["detailId"]; //外键

ds.Relations.Add("关联", keyColumn, foreignColumn); //从表的层次名

gridControl1.DataSource = ds.Tables["dtMaster"].DefaultView;

编辑从表事件：

       private void gridControl1_Click(object sender, EventArgs e)
        {
            int i = gridControl1.FocusedRowHandle;

            DevExpress.XtraGrid.Views.Grid.GridView detailView = gridControl1.GetVisibleDetailView(i) as DevExpress.XtraGrid.Views.Grid.GridView;

            if (detailView != null)
            {

detailView.Click += new EventHandler(gdDetail_Click);

}
}

        /// <summary>
        /// 从表点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gdDetail_Click(object sender, EventArgs e)
        {
            DevExpress.XtraGrid.Views.Grid.GridView gv = sender as DevExpress.XtraGrid.Views.Grid.GridView;
            string sText=gv.GetDataRow(gv.FocusedRowHandle)["字段名"].ToString();
        }