drop down help

hi,
i have added a colum with drop dowm cell type as.

dgSellingPrice.TableDescriptor.Columns[Constants.PRICE_VATRATE_GRIDCOLUMN].Appearance.AnyCell.ChoiceList = s;

The problem is i am able to type in any thing on the dropdown cell. I want that the user should be forced to pick up data from the drop down options only.

Please help.

Hi Dinesh,

You can try setting the DropDownStyle property to GridDropDownStyle.Exclusive.

dgSellingPrice.TableDescriptor.Columns[Constants.PRICE_VATRATE_GRIDCOLUMN].Appearance.AnyCell.DropDownStyle=GridDropDownStyle.Exclusive

Best regards,
Haneef

Thanks, it worked,

but the problem now is that when i change the value in the drop down and try to tab out or click any where else in grid, the row remains in the edit mode. so it is not commiting the changes i have done to the cell.
what can be the solution for this.

Thanks

Dinesh

>hi,
i have added a colum with drop dowm cell type as.

dgSellingPrice.TableDescriptor.Columns[Constants.PRICE_VATRATE_GRIDCOLUMN].Appearance.AnyCell.ChoiceList = s;

The problem is i am able to type in any thing on the dropdown cell. I want that the user should be forced to pick up data from the drop down options only.

Please help.

Hi Dinesh,

To push all data to underlying datasource for every cell movement, you need to call in Table.EndEdit Method(before calling this , you need to call the CurrentCell''s Edit method) in the TableControlCurrentCellMoving event of the grid. Here is a code snippet.

e.TableControl.CurrentCell.EndEdit(); //saves the currentcell
e.TableControl.Table.EndEdit();

Regards,
Haneef