In a DropDownEdit column, how to display text instead of value

[Rajkishan Rajappan]

Hi,

I'm new to Syncfusion, and in the process of trying out a few different things to try to figure out how everything works. I'm using ASP.NET Web Forms, and I have a question about how to display text instead of value in a dropdownedit column.

I used the example from this link to populate the dropdown values, and it does work fine when I try to add a new row. It shows the text instead of the value in the dropdown from the datasource I provided. But as far as the grid itself is concerned, it only shows the values, and not the text itself.

This is my grid:

<ej:Grid ID="buildingsGrid" runat='server' AllowPaging="true" AllowSorting="true" AllowFiltering="true" OnServerAddRow="buildingsGrid_ServerAddRow" OnServerDeleteRow="buildingsGrid_ServerDeleteRow">

    <Columns>

        <ej:Column Field="UserBuildingID" IsPrimaryKey="true" Visible="false"></ej:Column>

        <ej:Column Field="buildingid" HeaderText="Building" EditType="DropdownEdit"></ej:Column>

    </Columns>

    <EditSettings AllowAdding="true" AllowEditing="false" AllowDeleting="true" />

    <ToolbarSettings ShowToolbar="true" ToolbarItems="add,delete,update,cancel"></ToolbarSettings>

</ej:Grid>

I databind it at PageLoad, and databind the dropdown as well. The datatable that's used as the datasource for the grid returns three columns: UserBuildingID, buildingid and Name. Here the buildingid and Name are connected, and I want to display the Name instead of buildingid, but the value should still be buildingid.

For databinding the dropdown column, this is what I use:

List<object> dropObj = new List<object>(); 

//read data from the SQL table 

using (SqlDataReader dr = cmd.ExecuteReader()) 

{ 

    while (dr.Read()) 

    { 

         //Convert Table rows to text/value pair 

         dropObj.Add(new { text = dr.GetValue(0).ToString(), value = dr.GetValue(0) }); 

    } 

} 

this.buildingsGrid.Columns[1].DataSource = dropObj;

How do I make sure that the text is displayed instead of the value in such a scenario?

Thanks,

Rajkishan

[Rajkishan Rajappan]

To add to this, I've tried setting the ForeignKeyField as buildingid and ForeignKeyValue as Name for the dropdownedit column, but doing that just makes the columns blank and not display anything at all.

[Rajkishan Rajappan]

Never mind! I figured it out. I just had to specify the ForeignKeyValue and ForeignKeyField as "text" and "value" respectively. Now it displays correctly!

[Manivannan Padmanaban]

Hi Rajkishan, 

We are pleased to hear that the reported issue has been resolved. 

If you need further assistance please get back to us. We will be happy to assist you. 

Regards, 

Manivannan Padmanaban. 

[Jan Streblow]

Hi,

I have a similar issue and tried to adopt the solution in this post, but for me it does not work. Got this grid in aspx:

with this SQL data source:

and this c# code:

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                List

[Farveen Sulthana Thameeztheen Basha]

Hi Jan, 

Thanks for using Syncfusion products. 

Query#:- But when I edit it displays "Details of undefined" with wierd fields and values or in case of EditMode="Normal" an empty field, though the dropdown list displays and works correctly: 

From analyzing your code example, you have not enabled IsPrimaryKey property in anyone of the columns which is necessary to perform Editing operations in Grid. Also IsPrimaryKey field must contains unique values. So we suggest to enable IsPrimaryKey property  

Refer to the code below:- 

<ej:Grid ID="FlatGrid" runat="server" IsResponsive="true” AllowPaging="True"> 

           .    .   . 

               

          <Columns> 

                <ej:Column Field="OrderID" HeaderText="Order ID" IsPrimaryKey="True" TextAlign="Right" Width="75" /> 

                  .    . 

            </Columns> 

            

</ej:Grid>   

Refer to the KB link:- 

https://www.syncfusion.com/kb/2675/cant-edit-any-row-except-the-first-row-in-grid 

Also in your screenshot you have shown like “Details of undefined” in Dialog. But you have used “Normal” mode in code example. So share us the clear Explanation about the Issue you have faced about details of undefined. 

Regards, 

Farveen sulthana T