Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFPOLEDB table name
Message
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
VFPOLEDB table name
Divers
Thread ID:
00897612
Message ID:
00897612
Vues:
56
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform