How to retrieve database values to datagridcomboboxcell

Hello Pavithra L thanks for writing below links and codes i hope helpful for you ..:)

http://stackoverflow.com/questions/31568996/how-to-get-combobox-value-from-a-datagridview-cell

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];

}

Special thanks c-sharpcorner

my website

https://krishnasinghprogramming.blogspot.com

1 Reply

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

Krishna Rajput Singh10y ago
Hello Pavithra L thanks for writing below links and codes i hope helpful for you ..:)
http://stackoverflow.com/questions/31568996/how-to-get-combobox-value-from-a-datagridview-cell

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];
}
Special thanks c-sharpcorner

my website
https://krishnasinghprogramming.blogspot.com
0