[Solved] Grdi Edit Mode with Dropdown

[pradeep k]

Hi All,

I have a grid with column 'Status', when i click edit then in status edit column i want drop down with status values(Closed,Open) and it should select which is the status.

Please help me regarding this.

[Shinu]

Hi Pradeep,

You can use a GridTemplateColumn with a label in its ItemTemplate and a dropdownlist in its EditItemTemplate:
aspx:

<telerik:GridTemplateColumn UniqueName="TemplateColumn">
  <ItemTemplate>
     <asp:Label ID="lblStatus" runat="server" Text='<%#Eval("Status") %>'>'></asp:Label>
  </ItemTemplate>
  <EditItemTemplate>
     <asp:DropDownList ID="ddlStatus" AppendDataBoundItems="true" SelectedValue='<%#Eval("Status") %>' runat="server">
         <asp:ListItem Text=""></asp:ListItem>
         <asp:ListItem Text="Closed"></asp:ListItem>
         <asp:ListItem Text="Open"></asp:ListItem>
     </asp:DropDownList>
  </EditItemTemplate>
</telerik:GridTemplateColumn>

Thanks
Shinu.

[pradeep k]

thank you.

[pradeep k]

I have one more issue here,

if i do like what you said, it is working fine with edit mode, but gives error in insert mode.

error is

'ddlStatus' has a SelectedValue which is invalid because it does notexist in the list of items.
Parameter name: value"

Please help me regarding this.

[pradeep k]

sorry,

i got the issue.

i forgot to write " <asp:ListItem Text=""></asp:ListItem> "

[Princy]

Hello Pradeep,

Rather than setting an empty ListItem in the dropdownlist, another suggestion would be to preset a value in the dropdownlist while the grid is in insert mode, inorder to avoid the error:
c#:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.InitInsertCommandName)
        {
            //Add new" button clicked
            e.Canceled = true;
            //Prepare an IDictionary with the predefined values
            System.Collections.Specialized.ListDictionary newValues = new
            System.Collections.Specialized.ListDictionary();
            newValues["Status"] = "Open";
            //Insert the item and rebind
            e.Item.OwnerTableView.InsertItem(newValues);
        }
    }

Hope this helps.
-Princy.

[pradeep k]

Thank U.

[pradeep k]

I have one more issue,

I have a dropdown column called "Year" in grid.

in edit mode i am setting readonly property to true for this column, but in insert mode i want to add the years to dropdown from database table, how can i do this in RadGrid1_ItemCommand event .

Please help me regarding this.

[Shinu]

Hi Pradeep,

To disable editing and allow only inserting for the dropdowncolumn, you have to set the ReadOnly property of the column accordingly based on the commands. Here's how you can achieve it:

c#:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
    {
        foreach (GridColumn col in RadGrid1.Columns)
        {
            if (col.ColumnType == "GridDropDownColumn" && col.UniqueName == "DropDownColumnUniqueName")
            {
                if (e.CommandName == RadGrid.EditCommandName)
                {
                    (col as GridDropDownColumn).ReadOnly = true;
                    col.Visible = false;
                }
                else
                {
                    (col as GridDropDownColumn).ReadOnly = false;
                    col.Visible = true;
                }
            }
        }
    }

And to populate the combobox in Insertmode, you can try out the following code :

c#:

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataInsertItem && e.Item.OwnerTableView.IsItemInserted)
        {
            GridDataInsertItem insertItem = (GridDataInsertItem)e.Item;
            RadComboBox combo = (RadComboBox)insertItem["Dropdown"].Controls[0];
            combo.DataSource = dt;
            combo.DataTextField = "Years";
            combo.DataValueField = "Years";
            combo.DataBind();
        }
    }

Hope this helps..

Shinu.

[pradeep k]

I did what you said,

it is not entering in to condition if (e.Item is GridDataInsertItem && e.Item.OwnerTableView.IsItemInserted)

Please let me know what to do.