Help! When I clear and fill a dataset, it loads new data in tables(1)

[scottin]

I setup the dataset, which is the datasource for a datagrid.

When I originally fill the dataset, the data is loaded into
dataset.tables( 0). (dataset.tables (0).rows.count = 8)

Then, if a row gets added to the table, I want to refresh the dataset.
When I do so, the data is loaded into dataset.tables( 1).
(dataset.tables (0).rows.count = 0, dataset.tables( 1).rows.count = 8)
(We can go into why the record isn't added later)

Here is the relevant code:
Sub Setup_Datagrid( )
command = "SELECT columns, calculated column"
command &= " FROM table1, table2"
command &= " WHERE table1.id = '" & ID & "'"
command &= " AND table1.foreign_ id = table2.id"
command &= " ORDER BY table1.id"

daMatItem.Selec tCommand = New SqlClient.SqlCo mmand(command)
command = Nothing
daMatItem.Selec tCommand.Connec tion = DBConnection
dsMatItem.Clear ()
daMatItem.Fill( dsMatItem)
End Sub

Private Sub cmdAddRow_Click (ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles cmdAddRow.Click
' This code inserted just to test.
Dim Idx As Integer = 0
Dim TotCost As Decimal = 0

dsMatItem.Clear ()
daMatItem.Fill( dsMatItem)

For Idx = 0 To (dsMatItem.Tabl es.Count - 1)
MessageBox.Show (CStr(Idx) & ", " &
CStr(dsMatItem. Tables(Idx).Row s.Count))
Next
End Sub

After running Setup_Datagrid( ), there is only 1 table with 8 rows
After clicking cmdAddRow, there are now 2 tables with 0 & 8 rows
respectively.

I have another window, doing almost the exact same thing, that works
correctly. The only difference is that I am using a dataset generated
with the data adapter wizard.
Can anyone explain what I am doing wrong?

Thanx

[Rulin Hong]

Try use DataSet.Tables. Clear() method.