COmboBox in datagrid

Question

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.

Ahmed JS · Answer

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();

Manish Kumar Choudhary · Answer

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/ I f you r using WPF the read following link http://www.c-sharpcorner.com/uploadfile/dpatra/combobox-in-datagrid-in-wpf/