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();