Strange datagrid occurance

[smithbr]

Hello all,
I have a strange question about a datagrid I created at design time in VB.net. For some reason or another, my dtagrid displays as if it is part of parent child table. When I fill the datagrid, the datagrid closes almost and I have to click on the + in the upper left hand corner adn tehn the name of the table in order to view the data in the datagrid. Every time I refresh teh datagrid it returns to this collapsed state. Why is this happening and what do I have to do to get rid of this. The table is not a parent child table. Any suggestions?
Thanks,
Brent

 

[RiverGuy]

Just set the DataMember property of your grid to your table.

 

[smithbr]

I am sorry that I did not include that in my original post. I have the data source set the my dataset and teh data member set to the table. That is why I am so confused as to why it is doing this. I even started a whole new project and created a new datagrid and adapter, connection, etc. and I still had teh same thing happen.

 

[smithbr]

I am sorry that I did not include that in my original post. I have the data source set the my dataset and teh data member set to the table. That is why I am so confused as to why it is doing this. I even started a whole new project and created a new datagrid and adapter, connection, etc. and I still had the same thing happen.

 

[PankajBanga]

are you creating DataGridTableStyle and GridColumnStyle programmatically as well??? Can you post the code you have written

 

[smithbr]

I created the datagrid and the datagridtablestyle at design time.

Here is the code i am using to fill the datagrid.

Private Sub cmdfind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdfind.Click

OleDbDataAdapter1.SelectCommand.Parameters(0).Value = txtinvnum.Text
OleDbDataAdapter1.Fill(DsInvoice1)
Try
DsInvoice1.Tables(0).Columns.Remove("Total&quot
Catch
End Try

DsInvoice1.Tables(0).Columns.Add("Total&quot
Dim dr As DataRow

If rdoyes.Checked Then
For Each dr In DsInvoice1.Tables(0).Rows
dr.Item("Total&quot = ((dr.Item("QuantityShipped&quot * dr.Item("LastUnitPrice&quot) * (1 - dr.Item("DiscountP&quot))
Next
grdComm.DataSource = Nothing
grdComm.DataSource = DsInvoice1
ElseIf rdono.Checked Then
For Each dr In DsInvoice1.Tables(0).Rows
dr.Item("Total&quot = dr.Item("QuantityShipped&quot * dr.Item("LastUnitPrice&quot

Next
grdComm.DataSource = Nothing
grdComm.DataSource = DsInvoice1
End If
End Sub

 

[PankajBanga]

you didn't specify the DataMember property when you are binding the DataGrid to a data source

grdComm.DataSource = DsInvoice1 (no DataMember specified)

Try this !!!

myDataGrid.SetDataBinding(myDataSet, "myTable&quot

 

[smithbr]

It worked...I had teh data member set at design time but did not realize taht the code was essentially overriding it. Thanks a lot.