public void Add2(string tableName) { //TabPage tPage = new TabPage() { Text = pageCaption }; //this.Controls.Add(tPage); DataGridView newGrid = new DataGridView() { Dock = DockStyle.Fill, DataSource = new DataView(_cDataset.Tables[tableName]) }; newGrid.AllowUserToAddRows = false; //tPage.Controls.Add(newGrid); this.Controls.Add(newGrid); CellStyle.applyGridTheme(newGrid); CellStyle.setGridRowHeader(newGrid); newGrid.RowPostPaint += CellStyle.rowPostPaint_HeaderCount; childGrid.Add(newGrid); }
/// <summary> /// 设置表之间的主外键关联 /// </summary> /// <param name="tableName">DataTable的表名称</param> /// <param name="foreignKey">外键</param> public void setParentSource(string tableName, string primarykey, string foreignKey) { this.DataSource = new DataView(_cDataset.Tables[tableName]); CellStyle.setGridRowHeader(this); _foreignKey = foreignKey; _primaryKey = primarykey; if (_cDataset.Tables[tableName].Columns[primarykey].GetType().ToString() == typeof(int).ToString() || _cDataset.Tables[tableName].Columns[primarykey].GetType().ToString() == typeof(double).ToString() || _cDataset.Tables[tableName].Columns[primarykey].GetType().ToString() == typeof(decimal).ToString()) { _filterFormat = foreignKey + "={0}"; } else { _filterFormat = foreignKey + "=\'{0}\'"; } }
public void Add(string tableName, string strPrimaryKey, string strForeignKey) { //TabPage tPage = new TabPage() { Text = pageCaption }; //this.Controls.Add(tPage); var newGrid = new MasterControl(_cDataset, controlType.middle) { Dock = DockStyle.Fill, DataSource = new DataView(_cDataset.Tables[tableName]) }; newGrid.setParentSource(tableName, strPrimaryKey, strForeignKey);//设置主外键 //newGrid.Name = "ChildrenMaster"; //tPage.Controls.Add(newGrid); this.Controls.Add(newGrid); //this.BorderStyle = BorderStyle.FixedSingle; CellStyle.applyGridTheme(newGrid); CellStyle.setGridRowHeader(newGrid); newGrid.RowPostPaint += CellStyle.rowPostPaint_HeaderCount; childGrid.Add(newGrid); }