Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOLEDB table name
Message
 
 
To
All
General information
Forum:
ASP.NET
Category:
Databases
Title:
VFPOLEDB table name
Miscellaneous
Thread ID:
00897612
Message ID:
00897612
Views:
55
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)
- jim durkin

"The universe is a big place, perhaps the biggest." Kurt Vonnegut
Next
Reply
Map
View

Click here to load this message in the networking platform