I have this information but I'm sure I'm missing something.  So I'm adding this information:

In my InitializeLayout, I have this:

All of my other columns in the grid display the data.

The only thing that doesn't show is the column where the droplist should appear. This is a hierarchical grid so you have to bind 2 datatables to it.

The 2nd datatable has the datarow that contains "Status". In the datatable, it's defined as a typeof "string" (aIso tried a typeof dropdown).  The data in the value list is just a simple value, text per row in the dropdown. Show the text with an associated value.

Everything matches.

I don't see the problem.  All I know is that when I've had DropDown column problems, I eventually found a mismatch, either in the data types or the actual data.

Wild guess: Could the values you are putting in your ValueList be blank filled; e.g. CAST('ABC' AS CHAR(5)) returns "ABC   ", not "ABC"?

Have you tried, as an intermediate step, populating the valulist in markup (using the designer) and seeing if you can get that to work?

(I've noticed that the Infragistics staff have been participating more in these forums lately.  Maybe we'll hear from them.  ;-)

Is your data type for the droplist a "string" or a "dropdown" ?  The data in my droplist is a string.  But since I'm binding a datatable to the grid, the value of that column (or all the values in the droplist) is string.  Do you have a sample snipet from your .cs file and your aspx file that you can show as an example?  Infragistics examples don't explain very much.

Thanks!

The "droplist" needs needs it's ValueMembers populated with data that matches the Cell.Value and Column.DataType.  They need to match both in data type, and in actual value.

I don't have a snippet, but you need:

• Column.Type = DropDownList
• Column.DataType = System.String
• Column.ValueList.ValueListItems(n).ValueMember populated with string data
• Column.ValueList.ValueListItems(n).ValueMember populated with strings that exactly match all possible values of Column.Value (beware of trailing spacesCHAR() and NCHAR() data

 Here is where you lose me.  I want to have a grid that shows the "words", a dropdown that contains the "words" but a Value member that contains an Int.

For example, let's say we have a select statement like:

Select LastName, EmployeeStatusLabel, EmployeeStatusID From Employee

Then  we hook this up to my UltraGrid.

I want two columns:  Employee Name ||  Employee Status

When someone selects the Employee Status cell, I want a drop down that shows some coded value pairs like Active/1, Inactive/2, etc. etc.

Now, the datatype of the displayed column is string, but the value I want to save is Int.  Is this possible?

How did u resolve it?

Hi,

valuelist is bound to a column, but i want to bind for a cell based on some conditions

With Regards,

Tushar Borhade

Software Programmer

Well, I stopped being thick, and worked it out.  On to the next problem (which is getting the thing to actually update!!!)

I'm assuming your EmployeeStatusId is the INT you set in your employee table which you want to set using the dropdown.  The next thing you need is a query that returns a translation between your INT values and the text you want in the dropdown, like this:

SELECT
    [StatusId],
    [StatusName] + '/' + CAST([StatusId] AS NVARCHAR(999)) AS [DropDownText]
FROM [StatusLookupTable]

The confiture your dropdown column like this:

• Column.Type = DropDownList
• Column.DataType = System.Int32
• Column.BaseColumnName = "EmployeeStatusID"
• Column.ValueList.ValueListItems(n).ValueMember = "StatusId"
• Column.ValueList.ValueListItems(n).DisplayMember = "DropDownText"