datagridviewcombobox not populating.

[taranpreet]

there is a data grid view with columns item ,quantityleft,quantity,unit,price per unit,discount

from these "item" is combobox which must be defined from a table "stock" having columns iname,iid,etc
iname should come in the combobox.
how should i do it have tried both combobox column and combobox cell.

private void sell_Load(object sender, EventArgs e)
{

//dataGridView1.SelectedColumns.
SqlDataAdapter adapter1 = new SqlDataAdapter("select * from [stock] where uid =" + id+"and compid="+cid, con);
DataSet ds2 = new DataSet();
SqlCommandBuilder cmd1 = new SqlCommandBuilder(adapter1);
adapter.Fill(ds2, "[stock]");
//DataGridViewComboBoxColumn i = new DataGridViewComboBoxColumn();

/////DataGridViewComboBoxColumn dd = dataGridView1.Columns[0];
//i.DataSource = ds2;
//DataGridViewComboBoxCell dd = (DataGridViewComboBoxCell)dataGridView1.Rows[0].Cells[0];
DataGridViewComboBoxColumn dd = (DataGridViewComboBoxColumn)dataGridView1.Columns["item"];
dd.DataSource = ds2;
//dd.
//dd.DisplayMember = "iname";
//dd.ValueMember="iname";
}

[Aimee Bailey]

ComboBox cell's only populate when the data from the data source corrosponds with an item in the cell template. Id suggest making sure your cell knows how to handle the data first.

good luck :)