How to add Items in the DatagridViewComboboxColumn of DatagridView during runtime

[SEhtesham]

Hi,

My application is in VS2008 and coded in VB.net.

I have a datagridView(DGV) on one of my form.DGV contains a column of type DatagridViewComboboxColumn.I have another column of SrNo.

Consider Table1 to be the table from where my DatagridView is filled which contains following fields SrNo,Value1,Value2.

My requirement is i want to fill the values in my DatagridViewComboboxColumn from Table1.The DatagridViewComboboxColumn's combobox should contain values of columns Value1,Value2 of Table1.

Sample data of Table1

SrNo Value1 Value2

1 2 3

2 4 5

As data in datagridView is filled from Table1 the data of SrNo column of Table1 is also populated in one of the column of DGV.

Now my DatagridViewComboboxColumn combobox should contain the values of Value1 and Value2 of Respective SrNo.

Like Row one of my DGV has SrNo 1 as first value,so the Value1 and Value2 of SrNo 1 should be added to the row's DatagridViewComboboxColumn.

Select distinct Value1,Value2 From Table1 where SrNo=DGV.items(0,DGV.currentcell.rowIndex).value.H ope this Query willl make things more clear

Please Suggest.

[kadghar]

Try creating a DataSet, fill the data set and then just use the BIND method of your DGView.

[SEhtesham]

dude i know how to fill the datagridview...
i want to fill the DatagridViewComboboxColumn.Please help how can i fill that combobox in DatagridView.DatagridViewComboboxColumn should have the values of columns Value1 and Value2 from Table1.

[1sanjeev]

How to calcuate clossing balance when opening fix in sql server: