Hello,
Please excuse my so bad english.
Actually I dont know what to do anymore, after having searched for a long
time on the internet. about my problem. I wrote some ASP.net pages, last
year, which were accessing to an access datafile (.mdb). I used this code (I
think the OleDBDataAdapter is very convenient), which is cleaned up below :
<%dim dr as datarow
Dim mAdapRapide As New OleDBDataAdapter("SELECT * FROM clients;",
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\ftproot\bases\base.mdb")
Dim mDs As New DataSet()
mAdapRapide.Fill(mDs, "clients")
for each dr in mDs.Tables("clients").rows%>
...... (my html code)
...... with stuff like <%=dr("clientname").tostring%>
<% next
mDs.Dispose():mAdapRapide.Dispose()%>
Now, I really need to do the exact same thing, but with a dbase file
("base2.dbf") instead of my access file ("base.mdb").
I tried several times, that doesn't work. Probably because of my connexion
string "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\ftproot\bases\base.mdb", but I really dont know how to modify it
in order to make my pages work correctly.
If somebody can help me, that would be very kind...
Thanks,
Isabelle
|