D'oh

thanks bonnie


>Jim,
>

>oDataAdp.Fill(oDataSet, "Title")
>

>
>~~Bonnie
>
>
>
>>I'm using the VFPOLEDB and after I fill my dataSet the Table name is not correct. Its defaulting to a generic name "TABLE
>>
>>oDataSet.tables("TABLE").rows(0).item("TitleID").tostring() ' works OK
>>oDataSet.tables("TITLE").rows(0).item("TitleID").tostring() ' nothing
>>
>>Here is the code.
>>thanks
>>
>>

Dim VFPDBCPath As String = ConfigurationSettings.AppSettings("VFPDBCPath")
>>Dim oConnect As New OleDbConnection("Provider=VFPOLEDB.1;Data Source=" & VFPDBCPath & ";")
>>sSelect = "SELECT TitleID FROM Title"
>>Dim cSelect As New OleDbCommand(sSelect, oConnect)
>>Dim oDataAdp As New OleDbDataAdapter(cSelect)
>>Dim oDataSet As New DataSet, oDataRow As DataRow
>>
>>oDataAdp.Fill(oDataSet)