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.

Hi Marcelo,

Thank you for your further explanations. There is no need to use a unique DropDown for each row. It is enough to have the same DropDown and populate it with differewnt data for each row. To achieve this we make use of the following workflow:

 1) Attach to the cellEditing_EnteringEditMode, this will fire when you try to edit a cell

          <CellEditingClientEvents EnteringEditMode="WebHierarchicalDataGrid1_CellEditing_EnteringEditMode" />

2) In the event handler of cellEditing_EnteringEditMode we call the loadItems method of the dropdown:

        function WebHierarchicalDataGrid1_CellEditing_EnteringEditMode(sender, eventArgs)
        {
            if (eventArgs.getCell().get_column().get_key() === "Patient First Name") {
                var dropdowneditor2 = ig_controls.ddeditor2;
                var rowIndex =  eventArgs.getCell().get_row().get_index();
                dropdowneditor2.loadItems(rowIndex, false);
            }
        }

As you see we pass a parameter to the method, in this case the rowIndex, so we can build a logic around that. You can pass any value.

3) Calling loadItems will trigger the server event ItemsRequested, that we need to attach to:

                    <EditorControl ID="ddeditor2" ClientIDMode="Static" Width="200px"
                          OnItemsRequested="ddeditor2_ItemsRequested" DropDownContainerMaxHeight="200px" EnableAnimations="False" EnableDropDownAsChild="False">
                        <ClientEvents DropDownOpening="WebHierarchicalDataGrid1_DropDown_DropDownOpening" />
                    </EditorControl>

As you see below we can make use of the rowIndex for any logic,. in this case we populate the dropdown with different date based on that.

    protected void ddeditor2_ItemsRequested(object sender, EventArgs e)
    {
        int rowIndex = Int32.Parse(((Infragistics.Web.UI.ListControls.DropDownItemsRequestedEventArgs)e).Value.ToString());
      
        // query your database using the rowIndex value, or assign datasource, or filter current dataSource, etc
        this.dd2.EditorControl.DataSource = MakeTable(rowIndex);
        this.dd2.EditorControl.ValueField = "id";
        this.dd2.EditorControl.TextField = "Data";
        this.dd2.EditorControl.DataBind();

    }
}

I am also attaching the sample for your reference. It makes use of the WebHierarchicalDataGrid, but the approach has NO different with a flat WebDataGris control. The dropdown is in the last column of the grid.

Thanks so much Hristo - I'll take a look at this today and tomorrow and see if I have any other issue that needs to be cleared up.

That's fine, you can update the thread whenever you are up to this.