code add database column to datagridview combobox column

Question

Hi friends I have one combobox column in my datagridview now i want database column data inside combobox

Kirtan Patel · Answer

Friend, Here is Code How you can Perform this king of task if my answer helps you then please check Do you like this check box :) By GUI way Or By Codding Below Way foreach ( DataGridViewRow r in dataGridView1.Rows) { (( DataGridViewComboBoxCell )r.Cells[r.Index]).DataSource = "DataTable/ DataSet Here" ; (( DataGridViewComboBoxCell )r.Cells[r.Index]).DisplayMember = "ColumnNameto Display " ; } if still having problem with my code let me know i will help you :)

faizan ahmad · Answer

plz help me kirtan brother how to write this cod with procedure

sangmesh sangulage · Answer

Thanks Kirtan. Now i want to fire a query on Datagridview ComboBox Column.Write now iam getting all the items in a combobox that are present in the table column.i want only limited items inside the combobox not all values in the table

Nilanka Dharmadasa · Answer

If you just want to show the value in the combobox text, then assigning the corresponding column name in the datatable to 'DataPropertyName' property would be sufficient. dataGridViewComboBoxColumn1.DataPropertyName = "columnname"; But if you want to populate dropdown with a list of values, then get a dataset from database and set it to DataSource. Set 'ValueMemebr' and DisplayMemebr properties if required. You can a list of values using q query like below. It will only return a distinct set of values. Select distinct columnname from TableName Then set the datatable. comboboxColumn.DataSource = datatable comboboxColumn.DisplayMember = " columnname " If you find this answer useful, please mark this as accepted.

Lalit M · Answer

Try this code In VB.NET ' Set datagrid column styles ' Define comboCountry variable as a ComboBoxColumn column style object of DataGridComboBoxColumn class Private WithEvents comboCountry As DataGridComboBoxColumn ' Define comboCapital variable as a ComboBoxColumn column style object of DataGridComboBoxColumn class Private WithEvents comboCapital As DataGridComboBoxColumn ........... ' Set column styles With .GridColumnStyles ' Set datagrid ComboBox Column Style for Country field comboCountry = New DataGridComboBoxColumn(Dictionary, 0, 0, , , False) .Add (comboCountry) With .Item(0) .MappingName = "Country" .HeaderText = "Country" .Width = 165 .NullText = String.Empty End With ' Set datagrid ComboBox Column Style for Capital field comboCapital = New DataGridComboBoxColumn(Dictionary, 1, 1, , , False) .Add (comboCapital) With .Item(1) .MappingName = "Capital" .HeaderText = "Capital" .Width = 165 .NullText = String.Empty End With End With ........... ' "Country" datagrid cell has been left. Update corresponding "Capital" cell value in the current datagrid row Private Sub comboCountry_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles comboCountry.Leave Dim Capital As DataRow() = Dictionary.Select("Country='" + comboCountry.combo.Text + "'") DataGrid1.Item(DataGrid1.CurrentRowIndex, 1) = Capital(0)(1) End Sub ' "Capital" datagrid cell has been left. Update corresponding "Country" cell value in the current datagrid row Private Sub comboCapital_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles comboCapital.Leave Dim Country As DataRow() = Dictionary.Select("Capital='" + comboCapital.combo.Text + "'") DataGrid1.Item(DataGrid1.CurrentRowIndex, 0) = Country(0)(0) End Sub In C# // Set column styles // Define comboCountry variable as a ComboBoxColumn column style object of DataGridComboBoxColumn class internal DataGridComboBoxColumn comboCountry; // Define comboCapital variable as a ComboBoxColumn column style object of DataGridComboBoxColumn class internal DataGridComboBoxColumn comboCapital; ........... // Set column styles // Set datagrid ComboBox ColumnStyle for Country field comboCountry = (DataGridComboBoxColumn) new DataGridComboBoxColumn(ref Dictionary, 0, 0, true, false, false, DataGridComboBoxColumn.DisplayModes.ShowDisplayMember, 0); comboCountry.Leave += new DataGridComboBoxColumn.LeaveEventHandler(this.comboCountry_Leave); TblStyle.GridColumnStyles.Add(comboCountry); TblStyle.GridColumnStyles[0].MappingName = "Country"; TblStyle.GridColumnStyles[0].HeaderText = "Country"; TblStyle.GridColumnStyles[0].Width = 165; TblStyle.GridColumnStyles[0].NullText = string.Empty; // Set datagrid ComboBox ColumnStyle for Capital field comboCapital = (DataGridComboBoxColumn) new DataGridComboBoxColumn(ref Dictionary, 1, 1, true, false, false, DataGridComboBoxColumn.DisplayModes.ShowDisplayMember, 0); comboCapital.Leave += new DataGridComboBoxColumn.LeaveEventHandler(this.comboCapital_Leave); TblStyle.GridColumnStyles.Add(comboCapital); TblStyle.GridColumnStyles[1].MappingName = "Capital"; TblStyle.GridColumnStyles[1].HeaderText = "Capital"; TblStyle.GridColumnStyles[1].Width = 165; TblStyle.GridColumnStyles[1].NullText = string.Empty; ........... // "Country" datagrid cell has been left. Update corresponding "Capital" cell value in the current datagrid row private void comboCountry_Leave(object sender, System.EventArgs e) { System.Data.DataRow[] Capital = Dictionary.Select("Country='" + comboCountry.combo.Text + "'"); DataGrid1[DataGrid1.CurrentRowIndex, 1] = Capital[0][1]; } // "Capital" datagrid cell has been left. Update corresponding "Country" cell value in the current datagrid row private void comboCapital_Leave(object sender, System.EventArgs e) { System.Data.DataRow[] Country = Dictionary.Select("Capital='" + comboCapital.combo.Text + "'"); DataGrid1[DataGrid1.CurrentRowIndex, 0] = Country[0][0]; }