473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Data Connections into dBase files

Hi,
Please help me with Data Connections into dBase files.
I have catalog with lot of files like *.dbf and *.mdx . Every file contains
one table (I can see it in MS Access).
How can I make connections into this/that folder/files in VB.NET project?
Tomek
Nov 20 '05 #1
6 4106
* "Tomek" <tn******@bcdplus.pl> scripsit:
Please help me with Data Connections into dBase files.
I have catalog with lot of files like *.dbf and *.mdx . Every file contains
one table (I can see it in MS Access).


Just FYI:

There is a separate group for .NET + database related questions
available:

<URL:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<URL:http://msdn.microsoft.com/newsgroups/?dg=microsoft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 20 '05 #2
Hi Tomek,

Made on the fly
\\\
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\MyFile.mdb;"
Dim Conn As New OleDb.OleDbConnection(connString)
Dim oledbStr as String = "Select * from Mytable"
Dim ds as New DataSet
Try
Dim da As New OleDb.OleDbDataAdapter(oledbStr, Conn)
da.Fill(ds)
Catch oledbExc As OleDb.OleDbException
MessageBox.Show(oledbExc.ToString)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
///
Ma nadzieje ze to pomoze?

Cor
Nov 20 '05 #3
Hi,

It has been a while since I opened a dbase file. You do it the same
as with access but use this as the connection string
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= directory with dbase files;
Extended Properties=DBase III;". To open sample.dpf use this as your sql
statement. Select * from sample. Hope this helps.

Ken
-------------------
"Tomek" <tn******@bcdplus.pl> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...
Hi,
Please help me with Data Connections into dBase files.
I have catalog with lot of files like *.dbf and *.mdx . Every file
contains
one table (I can see it in MS Access).
How can I make connections into this/that folder/files in VB.NET project?
Tomek

Nov 20 '05 #4
check out http://www.able-consulting.com/ADO_Conn.htm

He has every connection string you can think of.

--
Frank Hoover
"Tomek" <tn******@bcdplus.pl> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...
Hi,
Please help me with Data Connections into dBase files.
I have catalog with lot of files like *.dbf and *.mdx . Every file contains one table (I can see it in MS Access).
How can I make connections into this/that folder/files in VB.NET project?
Tomek

Nov 20 '05 #5
Ken,

Thanks I mistreaded it.

Cor
Nov 20 '05 #6
Hi,
Thanks for help.
I'm using connection string:
MyConnectionString="Driver={Microsoft dBASE Driver
(*.dbf)};DriverID=277;Dbq=my_dbf_folder_path"

The problem is:
How can I use it in DataGrid or other ways to edit\add data?

I have following code:
connODBC = New OdbcConnection(MyConnectionString)
connODBC.Open()
commODBC = New OdbcCommand("Select * from NAMES.DBF", connODBC)
daODBC = New OdbcDataAdapter(commODBC)
cbODBC = New OdbcCommandBuilder(daODBC)
dsODBC = New DataSet("X")
'daODBC.Fill(dsODBC, "XX")
dg.SetDataBinding(dsODBC, "XX")
It correctly displays table Names.DBF in my DataGrid (dg). What should I add
to this code to make available edit/add?

Tomek
Nov 20 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ivan | last post by:
Hi, SQL Server 2000 SP3 Windos 2000 Server SP4 I have a DTS package that imports data from a dBase IV databse with files located in two folders (dBF1 and dBF2). I use a transform data task...
1
by: TY | last post by:
Any tips on exporting my existing Q&A 4(DOS) to access 2002. I have the following options in Q&A, DIF Standard ASCII Fixed ASCII dBase II " III " IV Paradox 2.0/3.0
1
by: Durumdara | last post by:
Hi ! I have a text processor code and I want to put the results to standard files. HTML, XML, SQLite - they are ok. But I want to put these datas to DBF too, because when records are many,...
5
by: MontainDoctor | last post by:
Hi Folks I have a database in dbase. The dbf tables have numerous indexes because of which the linking is not possible. What to do? Rakesh
0
by: j.np.12 | last post by:
I have an Access XP database which links to dBase III format tables and updates them. The app used to work fine until recently when the dBase index tables keep getting corrupted and need to be...
0
by: quantumlady | last post by:
Hi, All. I am working on a project with another student that will be used on Oracle, MySWL and DB2 databases. We have completed all the basic functions, but I would like to see if we can improve...
0
by: sanjeevkr98 | last post by:
Hi, We are having databases in DBase and i want to convert it into oracle 10g database. Would anyone help me out how to convert the same to oracle 10g database. I converted all the dbase...
10
by: Johny | last post by:
Is there a module for reading/modifing db files from Python? Thanks for help B.
3
by: cvalle | last post by:
A little about me... I’ve build a few Access dbases but I consider myself a novice. I have never inherited someone else’s Dbase. The dbase is not password protected, but I cannot access all of the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.