Hi!

Are there any possibilities to open and process an DBase / Visual
FoxPro Table ?

Hi,
>Visual FoxPro Table ?
yes
-> www.codebase.com

http://www.grafxsoft.com/

Vulcan.Net is a hot new xBase language compiler targeting .NET Framework.
Offering high compatibility with Visual Objects, Vulcan.NET offers an ideal
way to migrate existing VO applications to the .NET platform. VulcanDB is a
data provider, written in .NET managed code, supports data access while
using a minimal amount of resources, even on limited compact devices. The
data provider is compatible with the DBF/CDX feature set. For more
information on VulcanDB click here . VulcanDB, available separately, end of
summer 2005. Vulcan.Net is targeted to ship by the end of 2005, however for
those who want to get started early, Vulcan.Net is available through a
Platinum Subscription VOPS. Click here for more information on VOPS To Join
our Vulcan.Net mail list click here.

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi!
>
> Are there any possibilities to open and process an DBase / Visual
> FoxPro Table ?
>

You can do it with an ODBC connection:

Dim conn As New Odbc.OdbcConnection
conn.ConnectionString = "PWD=;SourceType=DBF;DSN=Visual FoxPro Tables;" & _
"Collate=Machine;BackgroundFetch=Yes;Exclusive=No;" & _
"SourceDB=" & DbSource & ";" & _
"UID="

Dim strSelect As String = "Select * FROM " & "[" & DbName & "]"
Dim cmd As New OdbcCommand(strSelect, conn)
Dim dr As OdbcDataReader
conn.Open()
dr = cmd.ExecuteReader()

While (dr.Read())
cmbTo.Items.Add(dr.GetString(0))
End While
dr.Close()
conn.Close()

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi!
>
> Are there any possibilities to open and process an DBase / Visual
> FoxPro Table ?
>

Errrrr ... did not notice I was in the CF forum -- there is no ODBC
namespace for CF.

"Earl" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You can do it with an ODBC connection:
>
> Dim conn As New Odbc.OdbcConnection
> conn.ConnectionString = "PWD=;SourceType=DBF;DSN=Visual FoxPro Tables;" &
> _
> "Collate=Machine;BackgroundFetch=Yes;Exclusive=No;" & _
> "SourceDB=" & DbSource & ";" & _
> "UID="
>
> Dim strSelect As String = "Select * FROM " & "[" & DbName & "]"
> Dim cmd As New OdbcCommand(strSelect, conn)
> Dim dr As OdbcDataReader
> conn.Open()
> dr = cmd.ExecuteReader()
>
> While (dr.Read())
> cmbTo.Items.Add(dr.GetString(0))
> End While
> dr.Close()
> conn.Close()
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi!
>>
>> Are there any possibilities to open and process an DBase / Visual
>> FoxPro Table ?
>>
>
>