Gridview ComboBox Column

[Edson]

Hi,

I have a gridview with one combobox column that its populated depending of the value entered in column 1. The combobox column is populated as expected, but, if I save the values and open the record and click inside the combobox column the selected value in that row its not the value that comes from the db, it always select the first value of the combobox. And I need to get the saved selected value when I enter into edit mode.

 

My code

 

private void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)
        {
            RadDropDownListEditor listEditor = this.radGridView1.ActiveEditor as RadDropDownListEditor;

            if (listEditor == null)
            {
                return;
            }

            RadDropDownListEditorElement editorElement = listEditor.EditorElement as RadDropDownListEditorElement;
            editorElement.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
            editorElement.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;


            string item = radGridView1.CurrentRow.Cells[0].Value == null ? "" : radGridView1.CurrentRow.Cells[0].Value.ToString();

            var result = SqlClass.GetUOMByItem(item);
            editorElement.DataSource = null;
            editorElement.Items.Clear();
            editorElement.DataSource = result;
            editorElement.DisplayMember = "UOFM";
            editorElement.ValueMember = "UOFM";


            if (editorElement.Items.Count > 0)
            {
                editorElement.SelectedValue = null;
                editorElement.SelectedValue = this.radGridView1.CurrentCell.Value;

            }

        }

 

thanks for your help!!

[Hristo]

Hello Edson,

Thank you for writing.

Since you are rebinding the column every time you open the editor, it is expected that the selection in the popup will be lost. Your solution with saving the selected value and setting it after rebinding the grid is valid. I extended the code snippet you sent me to create an example: 

public partial class Form1 : Form
{
    private BindingSource bs;

    public Form1()
    {
        InitializeComponent();

        this.radGridView1.DataSource = this.GetData();

        GridViewComboBoxColumn combolCol = new GridViewComboBoxColumn();
        combolCol.Name = "Phone";
        combolCol.Width = 200;
        this.radGridView1.Columns.Add(combolCol);

        this.radGridView1.CellEditorInitialized += radGridView1_CellEditorInitialized;
    }

    private void radGridView1_CellEditorInitialized(object sender, GridViewCellEventArgs e)
    {
        RadDropDownListEditor listEditor = this.radGridView1.ActiveEditor as RadDropDownListEditor;
        if (listEditor == null)
        {
            return;
        }

        RadDropDownListEditorElement editorElement = listEditor.EditorElement as RadDropDownListEditorElement;
        editorElement.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
        editorElement.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

        bool isEven = (int)this.radGridView1.CurrentRow.Cells[1].Value % 2 == 0;
        IList<string> res = this.GetComboData(isEven);
        editorElement.DataSource = res;

        if (editorElement.Items.Count > 0)
        {
            editorElement.SelectedValue = null;
            editorElement.SelectedValue = this.radGridView1.CurrentCell.Value;

        }
    }

    private DataTable GetData()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("Name", typeof(string));
        dt.Columns.Add("Age", typeof(int));
        dt.Columns.Add("Date", typeof(DateTime));
        dt.Columns.Add("Bool", typeof(bool));
        for (int i = 0; i < 100; i++)
        {
            dt.Rows.Add("Name " + i, i, DateTime.Now.AddMinutes(i), i % 2 == 0 ? true : false);
        }

        return dt;
    }

    private IList<string> GetComboData(bool flag)
    {
        IList<string> data = new List<string>();
        if (flag)
        {
            data.Add("Mobile1");
            data.Add("Mobile2");
            data.Add("Mobile3");
            data.Add("Mobile4");
        }
        else
        {
            data.Add("Fax1");
            data.Add("Fax2");
            data.Add("Fax3");
            data.Add("Fax4");
        }

        return data;
    }
}

I am also sending you a gif file showing the result on my end.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo Merdjanov
Telerik

[keerthi]

Hi histro, 

i am using same sample code as given by you,when  I am selecting one value  from the combo column in gridview , getting issue as object of type system.string cannot be  convert totype system.collections.generic.list(system.string).please help to resolve the issue.  

Thanks for your help!!

 

 

[Hristo]

Hi Keerthi,

I am not sure how to reproduce the experienced on your end behavior. Can you please open up a support ticket and send us your project so that we can investigate it on our end?

Regards,
Hristo
Progress Telerik