COmboBox in datagrid

santhosh kumar

HAi,
I need a help from you all, i need to place a combo box in datagridview in c# windows application and have to load the combo box with the data from the database. and store the same to different data table.
thanks in advance.

2 Replies

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

Ahmed JS12y ago
Hello friend

Below link

http://sqlneed.blogspot.com/2014/04/add-combobox-in-datagridview-using-csharp.html
load the combobox with the data from database then use below code.

string sql = "Select distinct country from Employees";

            SqlConnection cnn = new SqlConnection(con);

            SqlDataReader rd;

            cnn.Open();

            SqlCommand cmd = new SqlCommand(sql, cnn);

            rd = cmd.ExecuteReader();

            chkbtn.Items.Clear();

            while (rd.Read())

            {

                chkbtn.Items.Add(rd["country"].ToString());

            }

            cnn.Close();

0
Manish Kumar Choudhary12y ago
Hi santhosh kumar

If You are using windows application then read following link
http://www.c-sharpcorner.com/UploadFile/9a3ae2/working-with-datagridview-checkboxcombobox-and-button-colum/

If you r using WPF the read following link
http://www.c-sharpcorner.com/uploadfile/dpatra/combobox-in-datagrid-in-wpf/
0