Relative c# newbie - dbase connectivity question

  • Thread starter Thread starter trinity1187
  • Start date Start date
T

trinity1187

Hey all-

Current Clipper programmer working on C# (Yes, there are few of us
still around :D), and I'm working on translating a legacy app to C#.
I've found various instructions on connecting to a DBase III format
file on the net, but I haven't found anything on reindexing to a pre-
existing index file.

In clipper it would be:

Use XXXXX New alias XXXXXX
Set index to YYYYYY
Reindex

That would produce an index file called YYYYYY.NTX.

Is there an equivalent command structure in C# (Using studio express
2005)? A pack (remove deleted records) function would be useful too.

John
 
Current Clipper programmer working on C# (Yes, there are few of us
still around :D), and I'm working on translating a legacy app to C#.
I've found various instructions on connecting to a DBase III format
file on the net, but I haven't found anything on reindexing to a pre-
existing index file.

In clipper it would be:

Use XXXXX New alias XXXXXX
Set index to YYYYYY
Reindex

That would produce an index file called YYYYYY.NTX.

Is there an equivalent command structure in C# (Using studio express
2005)? A pack (remove deleted records) function would be useful too.
Click to expand...

The first thing you need to do is to get rid of the concept of "can C# do
this?" C# itself knows nothing about databases, nor does VB.NET, nor Managed
C++, etc. It is the individual database provider that knows how to work with
a database. The database provider implements interfaces which can be read
from any .NET language (which makes it "appear" that C#/VB/etc. knows about
databases), so your real concern is in finding a provider that is capable of
doing what you want. I would suggest looking into the Visual FoxPro driver.
It has more control of dBASE files than anything else I've ever seen.
Certainly the Jet provider cannot do what you want.

I've cross-posted this reply to the ADO.NET group. Hopefully someone there
can help you more.
 
Jeff,

I'm redirecting you again.

As you ask your question in the FoxPro newsgroups, you probably get the
answer you want.

Cor
 
Back
Top