Connect dataset with comboboxdatagridview

namespace NewDGV

{

public partial class Form33 : Form

{

public Form33()

{

InitializeComponent();

}

DataTable pdt = new DataTable();

DataTable cdt = new DataTable();

private void Form33_Load(object sender, EventArgs e)

{

pdt.Columns.Add("order");

pdt.Columns.Add("productid");

pdt.Rows.Add("01","004");

pdt.Rows.Add("02","001");

pdt.Rows.Add("03","001");

pdt.Rows.Add("04","003");

pdt.Rows.Add("05","002");

cdt.Columns.Add("productid");

cdt.Columns.Add("name");

cdt.Rows.Add("001", "aaa");

cdt.Rows.Add("002", "bbb");

cdt.Rows.Add("003", "ccc");

cdt.Rows.Add("004", "ddd");

this.dataGridView1.DataSource = pdt;

this.dataGridView1.Columns.RemoveAt(1);

DataGridViewComboBoxColumn dgvcob = new DataGridViewComboBoxColumn();

dgvcob.HeaderText = "Product";

dgvcob.DataPropertyName = "productid";

dgvcob.DisplayMember = "name";

dgvcob.ValueMember = "productid";

dgvcob.DataSource = cdt;

dgvcob.DefaultCellStyle.NullValue = "Choose a value";

this.dataGridView1.Columns.Add(dgvcob);

}

}

}