Hi
Have two Datagrids in a Master Detail relationship, used the example from
syncfusion to bind to a currency manager and set the allowNew to false, but
it does not work for my child datagrid.
Any help would be great.
thanks dave.
here is some code
// Connection Adapters
CBAdapter = new OleDbDataAdapter("Select * From tblCashBook", CBConnect) ;
CBAdapterSplit = new OleDbDataAdapter("Select * From tblCashBookSplit",
CBConnect) ;
CBDataset = new DataSet();
CBConnect.Open() ;
CBAdapter.Fill(CBDataset, "tblCashBook") ;
CBAdapterSplit.Fill(CBDataset, "tblCashBookSplit") ;
// Setting up datagrid columnstyles
DGCashBook_SetupColumnStyles();
DGCashBookSplit_SetupColumnStyles();
CBDataset.Relations.Add("CashBookToSplit", CBDataset.Tables
["tblCashBook"].Columns["SplitNumber"],
CBDataset.Tables["tblCashBookSplit"].Columns["SplitNumber"]);
this.DGCashBook.DataSource = CBDataset.Tables["tblCashBook"];
this.DGCashBookSplit.DataSource = CBDataset.Tables["tblCashBook"];
this.DGCashBookSplit.DataMember = "CashBookToSplit";
this.DGCashBook.AllowNavigation = false;
CBCmdBuilder = new OleDbCommandBuilder(CBAdapter);
CBCmdBuilderSplit = new OleDbCommandBuilder(CBAdapterSplit);
// Bind CM to Parent Datagrid
cm = (CurrencyManager)this.BindingContext[DGCashBook.DataSource];
((DataView)cm.List).AllowNew = false;
// Bind CM2 to Child Datagrid
cm2 = (CurrencyManager)this.BindingContext[this.DGCashBookSplit.DataSource,
this.DGCashBookSplit.DataMember];
((DataView)cm2.List).AllowNew = false;
// tried navigate navigate handler for both datagrids but still does not work
this.DGCashBook.Navigate += new NavigateEventHandler(DGCashBook_Navigate);
CBConnect.Close();