Hi Nadia,

Thank you for your help.  Number 1 is resolved.   I still can't find an example of how to enable the cell editing feature for the unbound checkbox in c# code.  Can you help?

Steve

Hi Nadia,

The example code you sent was very helpful, thank you!  I was able to create the grid with parent and child tables and the submit button executes correctly without an error.

Now I am having a different issue.  The checkbox is visible on each child row, but only the first row's checkbox is editable.  My code is included below.

Please let me know what I am doing wrong.

Thanks,
Steve 

private DataSet GetDataSource()
{
DataSet ds = new DataSet();
ds.Tables.Add(BuildParentTable());
ds.Tables.Add(BuildChildTable());
ds.Relations.Add(ds.Tables[0].Columns["PartNo"], ds.Tables[1].Columns["PartNo"]);
return ds;
}

private void LoadConsignmentParts()
{
InventoryGrid.Columns.Clear();
InventoryGrid.GridView.Columns.Clear();
InventoryGrid.GridView.Band.Bands.Clear();
InventoryGrid.GridView.ClearDataSource();
InventoryGrid.Visible = true;

//InventoryGrid.DataSource = ftsRepository.GetConsignmentInventory(OverrideCompany, txtSearch.Text);
InventoryGrid.DataSource = GetDataSource();

BoundDataField bdf = new BoundDataField();
bdf.DataFieldName = "PartNo";
bdf.Key = "PartNo";
bdf.Header.Text = "PartNo";
bdf.Width = 186;
InventoryGrid.GridView.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.DataFieldName = "CustomerPartNo";
bdf.Key = "CustomerPartNo";
bdf.Header.Text = "CustomerPartNo";
bdf.Width = 186;
InventoryGrid.GridView.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.DataFieldName = "TotalQty";
bdf.Key = "TotalQty";
bdf.Header.Text = "Quantity";
bdf.Width = 56;
InventoryGrid.GridView.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.DataFieldName = "PartDesc";
bdf.Key = "PartDesc";
bdf.Header.Text = "PartDesc";
bdf.Width = 256;
InventoryGrid.GridView.Columns.Add(bdf);

Band childBand = new Band();
childBand.DataKeyFields = "PartNo";
childBand.DataMember = "ConsignmentCases";

childBand.Key = "CaseNo";

InventoryGrid.Bands.Add(childBand);
//add editing behaviors to allow the checkbox to be checked/unchecked
EditingCore editingCoreBehavior = InventoryGrid.Bands[0].Behaviors.CreateBehavior<EditingCore>();
InventoryGrid.GridView.Behaviors.Add(editingCoreBehavior);

CellEditing cellEditingBehavior = editingCoreBehavior.Behaviors.CreateBehavior<CellEditing>();
InventoryGrid.GridView.Behaviors.EditingCore.Behaviors.Add(cellEditingBehavior);

cellEditingBehavior.Enabled = true;

UnboundCheckBoxField cbf = new UnboundCheckBoxField();
cbf.Key = "ID1";
cbf.Width = 25;
childBand.Columns.Add(cbf);

childBand.AutoGenerateColumns = false;

bdf = new BoundDataField();
bdf.Key = "PartNo";
bdf.Header.Text = "PartNo";
bdf.Width = 150;
childBand.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.Key = "CaseNo";
bdf.Header.Text = "CaseNo";
bdf.Width = 120;
childBand.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.Key = "MfgDate";
bdf.Header.Text = "Mfg.Date";
bdf.Width = 82;
childBand.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.Key = "ExpDate";
bdf.Header.Text = "Exp.Date";
bdf.Width = 82;
childBand.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.Key = "Qty";
bdf.Header.Text = "Case Qty.";
bdf.Width = 72;
childBand.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.Key = "CustomerPO";
bdf.Header.Text = "Customer PO#";
bdf.Width = 130;
childBand.Columns.Add(bdf);

bdf = new BoundDataField();
bdf.Key = "MfpTrackNo";
bdf.Header.Text = "MFP Track#";
bdf.Width = 100;
childBand.Columns.Add(bdf);

// do the databind
InventoryGrid.DataBind();

if (InventoryGrid.Rows.Count < 1)
{
InventoryGrid.Visible = false;
}
}

private DataTable BuildParentTable()
{
System.Data.DataTable table = new DataTable("ConsignmentParts");
DataColumn column;
DataRow row;

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "PartNo";
column.AutoIncrement = false;
column.Caption = "PartNo";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "CustomerPartNo";
column.AutoIncrement = false;
column.Caption = "CustomerPartNo";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "TotalQty";
column.AutoIncrement = false;
column.Caption = "TotalQty";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "PartDesc";
column.AutoIncrement = false;
column.Caption = "PartDesc";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

DataColumn[] PrimaryKeyColumns = new DataColumn[1];
PrimaryKeyColumns[0] = table.Columns["PartNo"];
table.PrimaryKey = PrimaryKeyColumns;

List<ConsignmentPart> parts = ftsRepository.GetConsignmentParts(OverrideCompany, txtSearch.Text);
foreach (var part in parts)
{
row = table.NewRow();

row["PartNo"] = part.PartNo;
row["CustomerPartNo"] = part.CustomerPartNo;
row["TotalQty"] = part.TotalQty;
row["PartDesc"] = part.PartDesc;

table.Rows.Add(row);
}
return table;

}

private DataTable BuildChildTable()
{
System.Data.DataTable table = new DataTable("ConsignmentCases");
DataColumn column;
DataRow row;

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "PartNo";
column.AutoIncrement = false;
column.Caption = "PartNo";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "CaseNo";
column.AutoIncrement = false;
column.Caption = "CaseNo";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.DateTime");
column.ColumnName = "MfgDate";
column.AutoIncrement = false;
column.Caption = "MfgDate";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.DateTime");
column.ColumnName = "ExpDate";
column.AutoIncrement = false;
column.Caption = "ExpDate";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "Qty";
column.AutoIncrement = false;
column.Caption = "Qty";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "CustomerPO";
column.AutoIncrement = false;
column.Caption = "CustomerPO";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "MfpTrackNo";
column.AutoIncrement = false;
column.Caption = "MfpTrackNo";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

DataColumn[] PrimaryKeyColumns = new DataColumn[1];
PrimaryKeyColumns[0] = table.Columns["CaseNo"];
table.PrimaryKey = PrimaryKeyColumns;

List<ConsignmentCase> cases = ftsRepository.GetConsignmentCases(OverrideCompany, txtSearch.Text);
foreach (var cs in cases)
{
row = table.NewRow();

row["PartNo"] = cs.PartNo;
row["CaseNo"] = cs.CaseNo;
row["Qty"] = cs.Qty;
row["MfgDate"] = cs.MfgDate;
row["ExpDate"] = cs.ExpDate;
row["CustomerPO"] = cs.CustomerPO;
row["MfpTrackNo"] = cs.MfpTrackNo;

table.Rows.Add(row);
}
return table;

}

Hi Steve,

I cannot reproduce the issue that you are seeing.

Can you reproduce this in the sample which I send to you?

If you wand just to be able to check the checkbox in the child band you do not need to add the editing behavior in the GridView, you can add it in the childBand and then the editing will be enabled only in the child.

You can use:

childBand.Behaviors.Add(editingCoreBehavior);

childBand.Behaviors.EditingCore.Behaviors.Add(cellEditingBehavior);

Instead of:

InventoryGrid.GridView.Behaviors.Add(editingCoreBehavior);

InventoryGrid.GridView.Behaviors.EditingCore.Behaviors.Add(cellEditingBehavior);

If you want the editing behavior to be enabled in both child and parent you have to set EnableInheritance to true for editingCoreBehavior and cellEditingBehavior.

Please let me know if I can provide any further assistance.

Thank you Nadia,  your sample program is working correctly.  I need to go through and compare both and figure out what are the differences.  I will keep you posted.

Steve

Hi Nadia,

I have this working now.  I had set the incorrect column name on the child table as the DataKeyField.

Thank you very much for all your help.

Steve

Hi Steve,

Thank you for your replies. Glad you were able to resolve the issue.