assign multiple combobox to grid

Question

i want to assign two combobox to grid

i am trying and trying assign multiple combobox to grid

i want to assign item_name and item_category combobox to grid

please help

Code

public Form1()
{
InitializeComponent();

using (SqlConnection conn = new SqlConnection("Data Source=0000;Initial Catalog=test;User Id = 0;Password = 0;Integrated Security=false;"))
{
SqlCommand sqlComm = new SqlCommand("get_ItemDataFill", conn);
sqlComm.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = sqlComm;
DataTable result = new DataTable();
da.Fill(result);

cmbItemName.DataSource = result;
cmbItemName.ValueMember = "ITEM_CODE";
cmbItemName.DisplayMember = "ITEM_NAME";

cmbItemCategory.DataSource = result;
cmbItemCategory.ValueMember = "ITEM_CATEGORY";
cmbItemCategory.DisplayMember = "ITEM_CATEGORY";

//dataGridView1.
//DataGridViewComboBoxColumn dgvChb = new DataGridViewComboBoxColumn();
//dgvChb.HeaderText = "ITEM_CODE";
//dgvChb.Items.Add(result);
//dataGridView1.Columns.Add(dgvChb);

}
}

store procedure

CREATE PROCEDURE get_ItemDataFill
AS
BEGIN
   select   ITEM_CODE,
           ITEM_NAME,
           ITEM_CATEGORY
   from ITEM_MASTER
END
GO

output

ITEM_CODE ITEM_NAME ITEM_CATEGORY
1 AAA A
2 BBBB B
3 CCC C

Ashutosh Singh · Answer

To assign multiple ComboBox controls to a DataGridView, you can use DataGridViewComboBoxColumn for each ComboBox you want to add. Here's how you can modify your code to achieve this: public Form1() { InitializeComponent(); using (SqlConnection conn = new SqlConnection("Data Source=0000;Initial Catalog=test;User Id = 0;Password = 0;Integrated Security=false;")) { SqlCommand sqlComm = new SqlCommand("get_ItemDataFill", conn); sqlComm.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = sqlComm; DataTable result = new DataTable(); da.Fill(result); // Assigning the data source to the DataGridViewComboBoxColumn DataGridViewComboBoxColumn itemNameColumn = new DataGridViewComboBoxColumn(); itemNameColumn.HeaderText = "Item Name"; itemNameColumn.DataSource = result; itemNameColumn.ValueMember = "ITEM_CODE"; itemNameColumn.DisplayMember = "ITEM_NAME"; itemNameColumn.DataPropertyName = "ITEM_CODE"; // This should be bound to the respective data column in your DataGridView's DataSource DataGridViewComboBoxColumn itemCategoryColumn = new DataGridViewComboBoxColumn(); itemCategoryColumn.HeaderText = "Item Category"; itemCategoryColumn.DataSource = result; itemCategoryColumn.ValueMember = "ITEM_CATEGORY"; itemCategoryColumn.DisplayMember = "ITEM_CATEGORY"; itemCategoryColumn.DataPropertyName = "ITEM_CATEGORY"; // This should be bound to the respective data column in your DataGridView's DataSource dataGridView1.Columns.Add(itemNameColumn); dataGridView1.Columns.Add(itemCategoryColumn); } } This code will create two DataGridViewComboBoxColumns ( itemNameColumn and itemCategoryColumn ) and bind them to the same DataTable result . Ensure that ITEM_CODE and ITEM_CATEGORY columns are bound correctly in the DataGridView's DataSource. Adjust the DataPropertyName properties accordingly if the column names in the DataGridView's DataSource are different.