Help with GridDropDownColumn

[Ed Bassin]

 The code I use to populate the grid is:

   protected void users_grid_needData(object source, GridNeedDataSourceEventArgs e)
    {
        DataTable dt = MasterPage.executeSQLQuery("SELECT ps_userid, first_name, last_name, ps_usertype FROM ps_users");
        users_grid.DataSource = dt;
    }

This works fine when all the elements are of type "GridBoundColumn" but when I try to make the usertype into a GridDropDown column, it does not render anything.

I read http://www.telerik.com/help/aspnet-ajax/grdcustomizeconfiguregriddropdowncolumn.html

but I am still unclear about what dataField, listValueField, listTextField, and listDataMember should be set to.

Right now I have it as:

 <radG:GridDropDownColumn ListTextField="ps_usertype" DataField="ps_usertype"
                     ListValueField="ps_usertype" HeaderText="Group" UniqueName="Group">
                    </radG:GridDropDownColumn>

Thanks

Edit: I took out the code formatting because it displayed badly.

[Yavor]

Hi Ed,

For your convenience, I have prepared a small application, which demonstrates the functionality in question.
You will find it attached to this message.
I hope it helps.

Best wishes,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Ed Bassin]

Thanks Yavor, that worked great!

[Ahmad]

Yavor,

I tried your test code...it demonstrates the functionality, but it doesn't resolve the issue of properly rendering updated values in a GridDropDownColumn. If I edit then update the value of a row, then the GridDropDownColumn still renders the "old" value (e.g. updating from 'Ana Trujillo' to 'Antonio Moreno' and it will still show as 'Ana Trujillo' ).

Is there a way to get around this?

[Yavor]

Hello Ahmad,

There is no code to actually update the underlying datasource.

Regards,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.