Loading

how can make datagridcomboboxcolumn with sql data

baskaran chellasamy

Hi friends, I have a four column in datagridview. first three are textboxcell and final one is comboboxcolumn. when i insert data to sql server i can select any one of value from combobox. but updating process i just retrieve data from sql database will only give selected value. how can set all available value for combobox column and returned selected value in the current index. please help me.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

bharaneedharan babu13y ago
pls visit following link

http://www.aspdotnet-suresh.com/2012/05/bind-data-to-dropdownlist-in-gridview.html
Sudhakar Chaudhary13y ago
I you have Limited Combobox Item than Try This.

DataGridViewComboBoxCell cell = (DataGridViewComboBoxCell)dataGridView1.Rows[i].Cells[3];

                    if (Fallon == "A")

                    {

                        cell.Value = "ASSET";

                    }