Add data in gridview from multiple tables and combobox [modified]

[haroon1980]

Hi, Basically i am trying to make a combobox in 2nd row of gridview... two issues in below function: Two things: 1. Now adapter2 is populated in gridview and i do not see any combobox instead i see only columns from adapter2 2. I do not see the adapter1 filled at all???

void fillData()
{
database = new OleDbConnection(connectionString);
database.Open();
OleDbDataAdapter adapter1 = new OleDbDataAdapter("select BillD.ProductName,BillD.ProductID,BillD.Saletype,BillD.InQty,BillD.SBtype,BillD.Dis1,BillD.Type,BillD.InPrice from BillDetails BillD", database);
OleDbDataAdapter adapter2 = new OleDbDataAdapter("Select Products.ProdID,Products.ProductName,Packing.PackingName from Packing INNER JOIN Products ON Packing.PackingID=Products.Packing", database);

{
DataGridViewComboBoxColumn dgridcolumn = new DataGridViewComboBoxColumn();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataTable packDT = new DataTable();
adapter1.Fill(dt);
dataGridView1.DataSource = dt;
adapter2.Fill(packDT);
ds.Tables.Add(packDT);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = ds.Tables[0].TableName;
dgridcolumn.DataSource = ds.Tables[0];
dgridcolumn.ValueMember = ds.Tables[0].Columns[1].ColumnName.ToString();
}
}

Thanks, Please help

modified on Friday, March 13, 2009 4:51 AM

[haroon1980]

Any help pls