Disabling GridDropDownColumn items

[VS]

Hi,

I am using GridDropDownColumn inside RadGrid.

1) How can i populate the dropdowncolumn with data during editmode and during insertmode?
2) After populating with data, how can i make certain items in the dropdown as disabled and certain as enabled?

Regards

Sujith

[Princy]

Hello Sujith,

1.You can populate a GridDropDownColumn during Edit/Insert Mode as shown in the code below.
aspx:

 <telerik:GridDropDownColumn UniqueName="ComboBox" DropDownControlType="RadComboBox" >
 </telerik:GridDropDownColumn>

cs:

 protected void RadGrid2_ItemDataBound(object sender, GridItemEventArgs e)
    {
       if (e.Item is GridEditableItem && e.Item.IsInEditMode)
        {
            GridEditableItem item = (GridEditableItem)e.Item;
            GridEditManager editMan = item.EditManager;
            GridDropDownListColumnEditor editor = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ComboBox"));

            string ConnectionString1 = "Data Source=INC135; Initial Catalog=MyDataBase;User ID=sa; Password=softinc";
            SqlConnection conn1 = new SqlConnection(ConnectionString1);
            SqlCommand cmdCustomers1 = new SqlCommand("SELECT Age FROM Reservation", conn1);
            cmdCustomers1.CommandType = CommandType.Text;
            conn1.Open();
            SqlDataReader reader1 = cmdCustomers1.ExecuteReader();
            editor.DataSource = reader1;
            editor.DataTextField = "Age";
            editor.DataBind();
            conn1.Close();
        }
    }

2.Also if you want to disable certain items  in the dropdown you can try the following approach.

CS:

protected void RadGrid2_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if ((e.Item is GridEditableItem) && (e.Item.IsInEditMode))
        {
            GridEditableItem item = (GridEditableItem)e.Item;
            RadComboBox combo = (RadComboBox)item["columnUniqueName"].Controls[0];
            combo.Items[3].Enabled = false;
        }
   }

Princy.