DatagridviewComboboxColumns problem ...

Question

Hello all my senior ,

 

select * from tblPremiseFacility where PremiseID = 'P-00001'

id code facility
1 P-00001 Play background
2 P-00001 Video Games 

 

that to value i want to show in datagridview combobox....

 

note : value should be direcotly  show in datagridview. no need to click and select..

 

i have written this code : only one value show but other one not  so kindly help 

 

DataSet ds = new DataSet();

string str = "P-00001";
cmd = new SqlCommand("select * from tblPremiseFacility where PremiseID ='" + str+"'", con);
da.SelectCommand = cmd;
da.Fill(ds);
//dataGridView3.DataSource = ds.Tables[0];

foreach (DataRow dr in ds.Tables[0].Rows)
{
for (int i = 0; i <= dataGridView3.Rows.Count - 1; i++)
{
if (dataGridView3.Rows != null)
{
this.dataGridView3.Rows[i].Cells["b"].Value = dr["facilities"].ToString();
this.dataGridView3.Rows[i].Cells["a"].Value = dr["PremiseID"].ToString();
b.DisplayStyleForCurrentCellOnly = true;

}
}

}

 

other code for retrieve the value in dgrcombobox ..i working

 

private void dis()
{
DataSet ds = new DataSet();

string str = "P-00001";
cmd = new SqlCommand("select PremiseID, facilities from tblPremiseFacility where PremiseID ='" + str + "'", con);
da.SelectCommand = cmd;
da.Fill(ds);

b.DataSource = ds.Tables[0];
b.DisplayMember = "facilities";
b.ValueMember = "facilities";
b.DefaultCellStyle.NullValue = "Choose a value";

}

 

thank to all