Unfortunately, there is a Intellectual Property issue preventing me from posting the entire code, well, at least at the public forum level and also, there is SQL data driving the grid now.

Is there a blog or sample that could show case the order? Do you need a functioning solution or you just need to look at the code?

Paul

Next steps?

So, this is my grid definition:

<ig:WebDataGrid ID="myGrid" runat="server" Width="100%" StyleSetName="LucidDream" OnPreRender="myGrid_PreRender">
<EditorProviders>
<ig:DropDownProvider ID="ddlCompatibilityValues">
<EditorControl runat="server" ID="CompatibilityDropDown" ClientIDMode="Predictable" DropDownContainerMaxHeight="200px" EnableAnimations="False" EnableDropDownAsChild="False" DisplayMode="DropDownList" TextField="Compatibility">
<Items>
<ig:DropDownItem Selected="False" Text="V" Value="V">
</ig:DropDownItem>
<ig:DropDownItem Selected="False" Text="C" Value="C">
</ig:DropDownItem>
<ig:DropDownItem Selected="False" Text="L" Value="L">
</ig:DropDownItem>
<ig:DropDownItem Selected="False" Text="X" Value="X">
</ig:DropDownItem>
<ig:DropDownItem Selected="False" Text="W" Value="W">
</ig:DropDownItem>
<ig:DropDownItem Selected="False" Text="-" Value="-">
</ig:DropDownItem>
</Items>
<DropDownItemBinding ValueField="Compatibility" TextField="Compatibility" />
</EditorControl>
</ig:DropDownProvider>
</EditorProviders>
</ig:WebDataGrid>

and the various methods that you are requesting. These sequence of events display the table headers. There is a method we call that merges data into an existing datatable and then we databind. Actual data shows up on a secondary databind after merging in existing data. I have no problem uploading solution, just can't do it to this post in its entirety.

protected void Page_Load(object sender, EventArgs e)
{
//initialize fields and the UI when it is initially rendered and not during a postback.
if (!IsPostBack)
{

   //initialize some data and session variables based on loading a page.

}

//rebind data after AJAX postback
if (Session["gridData"] != null)
{
dgCompatibilityViewData.DataSource = (DataTable)Session["MatrixData"];
dgCompatibilityViewData.DataBind();
}
}

and after selecting a specific event after a drop_down selection change, I perform the following:

protected void cbx_SelectionChanged(object sender, DropDownSelectionChangedEventArgs e)
{
DataTable table = Controllers.DataAccess.getInstance().getEditMode(cbx.SelectedValue);

//we are re-generating column types, so clear up the datasource and columns, and rebind.
myGrid.ClearDataSource();
myGrid.Columns.Clear();
myGrid.AutoGenerateColumns = false;
GenerateEditModeColumns(cbx.SelectedValue);

myGrid.DataSource = table;

myGrid.DataBind();

if (Session["MatrixData"] == null)
Session.Add("MatrixData", table);
else
Session["MatrixData"] = table;

Session["EditMode"] = true;

}

private void GenerateEditModeColumns(string somedata)
{
string productName = Controllers.DataAccess.getInstance().getProductName(somedata);

//ID Column

BoundDataField idField = new BoundDataField(true);
idField.Key = "id";
idField.Header.Text = "ID";
idField.Hidden = true;
idField.DataFieldName = "id";

//Product Column
BoundDataField productField = new BoundDataField(true);
productField.Key = "Product";
productField.Header.Text = "Product";
productField.DataFieldName = "Product";

//Compatibility Column
BoundDataField compatibilityField = new BoundDataField(true);
compatibilityField.Key = "Compatibility";
compatibilityField.Header.Text = productName;

EditingCore core = new EditingCore();
core.Enabled = true;
core.AutoCRUD = false;
CellEditing editing = new CellEditing();
core.Behaviors.Add(editing);

EditingColumnSetting setting = new EditingColumnSetting();
setting.ColumnKey = "Compatibility";
setting.EditorID = dgCompatibilityViewData.EditorProviders[0].ID;
editing.ColumnSettings.Add(setting);

//Is Published Column
BoundCheckBoxField isPublishedField = new BoundCheckBoxField(true);
isPublishedField.Key = "IsPublished";
isPublishedField.Header.Text = "Is Published";

//Notes Column
BoundDataField notesField = new BoundDataField(true);
notesField.Key = "Notes";
notesField.Header.Text = "Notes";

//Set up the columns in the data grid.
dgCompatibilityViewData.Columns.Add(idField);
dgCompatibilityViewData.Columns.Add(productField);
dgCompatibilityViewData.Columns.Add(compatibilityField);
dgCompatibilityViewData.Columns.Add(isPublishedField);
dgCompatibilityViewData.Columns.Add(notesField);

dgCompatibilityViewData.Behaviors.Add(core);
}

ok, I have a sample. Seems like the problem occurs after a table merge. The original table (when loaded) contains the proper drop-down behavior on a double-click, but when I add more data to the grid via the button, and merge. I am now unable to enter edit state on the table.

The only minor difference is that when I create the edit behavior, there is no actual data, but just column definitions. And then another user action adds data to the table and I call the table.merge method, so I can combine data, and refresh the grid. I would have assumed table behavior would remain intact???

Sample attached.

Paul

Hello Pavel,

When defining behaviors in code behind this needs to be done in the Init event, so that they are build every time the page reinitializes itself. This was the issue with your sample - after binding grid to the new data behaviors were not created. Here is the Init event with the sample code you need to move in there:

        protected void WebDataGrid1_Init(object sender, EventArgs e)
        {
            EditingCore core = new EditingCore();
            core.Enabled = true;
            core.AutoCRUD = false;
            CellEditing editing = new CellEditing();
            core.Behaviors.Add(editing);

            EditingColumnSetting setting = new EditingColumnSetting();
            setting.ColumnKey = "field2";
            setting.EditorID = WebDataGrid1.EditorProviders[0].ID;
            editing.ColumnSettings.Add(setting);

            WebDataGrid1.Behaviors.Add(core);
        }

Please let me know if you would need the modified sample so that I can attach it here too.