Hi Hristo,

This example makes is very good but my issue is that for each row the DropDown will need to contain unique values depending on the Item. Is the only way to do this to add a Unique DropDownProvider for each Row?

The following would be an example (adapted from your example and the following does not work but would love to figure out how it can) -- I need a situation where if WebDataGrid is populated by "MakeTable_2" and in MakeTable_2 if "MakeTable" is passed the Value "1" then the dropdown for that Row with have 20 values "Data 0" to "Data 19" and if "MakeTable" is passed the value "2" then that row would have a drop down with only "Data 0" to "Data 5"

Does this issue make sense? is there a way to do this programmatically/on the server side? Do I just need to make unique DropDownProviders for each row?

public partial class _Default : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {

        this.WebDataGrid1.DataSource = MakeTable_2();
    }

    private DataTable MakeTable(int x)
    {
        // Create a new DataTable.
        System.Data.DataTable table = new DataTable("Table");
        // Declare variables for DataColumn and DataRow objects.
        DataColumn column;
        DataRow row;

        // Create new DataColumn, set DataType,
        // ColumnName and add to DataTable.    
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.Int32");
        column.ColumnName = "id";
        column.ReadOnly = true;
        // Add the Column to the DataColumnCollection.
        table.Columns.Add(column);

        // Create second column.
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.Int32");
        column.ColumnName = "Item";
        column.AutoIncrement = false;
        column.Caption = "Item";
        column.ReadOnly = false;
        column.Unique = false;
        // Add the column to the table.
        table.Columns.Add(column);

        // Create third column.
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.String");
        column.ColumnName = "Data";
        column.AutoIncrement = false;
        column.Caption = "Data";
        column.ReadOnly = false;
        column.Unique = false;
        // Add the column to the table.
        table.Columns.Add(column);

        // Make the ID column the primary key column.
        DataColumn[] PrimaryKeyColumns = new DataColumn[1];
        PrimaryKeyColumns[0] = table.Columns["id"];
        table.PrimaryKey = PrimaryKeyColumns;

        if (x == 1)
        {
            for (int i = 0; i <= 20; i++)
            {
                row = table.NewRow();
                row["id"] = i;
                row["Item"] = i;
                row["Data"] = "Data " + i;
                table.Rows.Add(row);
            }
        }
        if (x == 2)
        {
            for (int i = 0; i <= 5; i++)
            {
                row = table.NewRow();
                row["id"] = i;
                row["Item"] = i;
                row["Data"] = "Data " + i;
                table.Rows.Add(row);
            }
        }
        
        return table;
    }
    private DataTable MakeTable_2()
    {
        // Create a new DataTable.
        System.Data.DataTable table = new DataTable("Table");
        // Declare variables for DataColumn and DataRow objects.
        DataColumn column;
        DataRow row;
        DataRow row2;
        // Create new DataColumn, set DataType,
        // ColumnName and add to DataTable.    
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.Int32");
        column.ColumnName = "id";
        column.ReadOnly = true;
        // Add the Column to the DataColumnCollection.
        table.Columns.Add(column);

        // Create second column.
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.String");
        column.ColumnName = "Item";
        column.AutoIncrement = false;
        column.Caption = "Item";
        column.ReadOnly = false;
        column.Unique = false;
        // Add the column to the table.
        table.Columns.Add(column);

        // Create third column.
        column = new DataColumn();
        column.DataType = System.Type.GetType("System.String");
        column.ColumnName = "Data";
        column.AutoIncrement = false;
        column.Caption = "Data";
        column.ReadOnly = false;
        column.Unique = false;
        // Add the column to the table.
        table.Columns.Add(column);

        // Make the ID column the primary key column.
        DataColumn[] PrimaryKeyColumns = new DataColumn[1];
        PrimaryKeyColumns[0] = table.Columns["id"];
        table.PrimaryKey = PrimaryKeyColumns;

        row = table.NewRow();
        row["id"] = 1;
        row["Item"] = "This is Item 1";
        row["Data"] = "Select...";

        DropDownProvider dropdownprovider = (DropDownProvider)WebDataGrid1.EditorProviders["DropDownProvider1"];
        dropdownprovider.EditorControl.DataSource = MakeTable(1);

        table.Rows.Add(row);

        row2 = table.NewRow();
        row2["id"] = 2;
        row2["Item"] = "This is Item 2";
        row2["Data"] = "Select...";

        dropdownprovider = (DropDownProvider)WebDataGrid1.EditorProviders["DropDownProvider1"];
        dropdownprovider.EditorControl.DataSource = MakeTable(2);

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

}

Thanks so much.

This is fine, I hope everything works well on your side.

This is great Hristo. I will be able to test it out sometime this week and confirm that all is resolved.

Thanks so much.

Hi Marcelo,

I have updated the sample I have initially sent to manually handle the data changes. To do this the RowUpdating event is handled ( please note that you should have AutoCRUD set to false in order to work witj the RowUpdating event). The workflow is quite mainstream, e.g.:

1) The grid data (or any other data source ) is saved into Session

2) in the RowUpdating event the data changes are manually persisted and saved into the Session again. The example is trivial with a DataSet:

    protected void WebHierarchicalDataGrid1_RowUpdating(object sender, RowUpdatingEventArgs e)
    {
        ContainerGrid containerGrid = (ContainerGrid)sender;

        if (containerGrid.Level == 0)
        {
            if (HttpContext.Current.Session["GridData"] != null)
            {
                DataSet ds = Session["GridData"] as DataSet;
                DataRow row = ds.Tables["ParentTable"].Rows.Find(e.Row.DataKey);
                row["Patient Last Name"] = e.Values["Patient Last Name"];
                row["Patient First Name"] = e.Values["Patient First Name"];
                ds.AcceptChanges();

                Session["GridData"] = ds;
            }
        }

        this.WebHierarchicalDataGrid1.DataSource = (DataSet)Session["GridData"];
        this.WebHierarchicalDataGrid1.DataBind();
    }

The same way any other data source (like the one that populates the dropdown may be handled and any changes to be persisted. The RowUpdating/RowDeleting/RowAdding server events occur at the most appropriate time in the page lifecycle and the respective data operations are recommended to be handled in those events, as demonstrated in the sample.

Hi Hristo,

When I use the dropdown the 'onrowupdating' function is not firing but am not sure why (might have to do with an unbound checkbox that I've added/need in the table?)

I think the drowdown does need at least the partial postback since the values are being set on the server side programatically.

I will look into using manual CRUD and see if I can manage it okay.

Any other info, examples or tutorials you can point me to on persisting data through user changes and then saving that to a DB would be great!

Thanks so much