Datagrid dispaly

[Seetal]

I have 2 comboboxes(outside of datagrid) and 1 datagrid.Based on the two combobox selections,the selected items on both should display in a single datagrid.
My problem is when i select the first combobox item,it displays properly on the datagrid.when i select the second combobox item it should append in the datagrid.instead it replaces the first column.even if i select the other columns in the first combobox it should also append not replace.
How do you display more than one column from the same combobox in a datagrid
Regs
Seetal

[Phil Weber]

I assume that the DataGrid is bound to a dataset of some kind, correct? If so, you should create a single dataset based on the selections in the two combo boxes, then bind the dataset to the grid.

[Seetal]

I have not yet connected to the database.I need the selected items from combobox to display in datagrid as a column header .

[Phil Weber]

OK. Please post the code you're using to assign the combobox values to the datagrid. Thanks!

[Seetal]

Private Sub UiCboClient_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UiCboClient.SelectedIndexChanged

Dim mytable As DataTable
myTable = New DataTable("Client_Details")
myTable.Columns.Add(New DataColumn(UiCboClient.Text, GetType(String)))
Me.GrdBusiness.SetDataBinding(myTable, "")
Me.GrdBusiness.RetrieveStructure()


End Sub

[Phil Weber]

OK. You're binding the DataGrid to a DataTable (myTable) containing the column headings, but you're creating a new DataTable each time the user selects an item from a combobox, so your DataGrid will only ever have a single column heading.

Try this: Declare myTable at the Class level, rather than inside a Sub or Function:

Dim mytable As New DataTable("Client_Details")

Then, in the SelectedIndexChanged event, do this:

myTable.Columns.Add(New DataColumn(UiCboClient.Text, GetType(String)))
Me.GrdBusiness.SetDataBinding(myTable, "")
Me.GrdBusiness.RetrieveStructure()

That will add a column to the DataTable without recreating it each time.

[Seetal]

Thanks A lot Phil.
It works Great.I Appreciate.