Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Anup Singh
  Where is Anup Singh?
 Delhi
 India
 Anup Singh
 Tags
Subject: RE: Can we operate .DBF files NET
Thread ID: 197789 Message ID: 197818 # Views: 61 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: ODBC, ADO and OLEDB
Date: Monday, October 06, 2008 3:36:34 PM         
   


> Dear Friends
>
> Can we operate our .dbf database through NET. If yes how ?
>
> With regard
> Anup Singh
> (M.D.)
>
> MARG Compusoft Pvt. Ltd.

>
> Email:anupmarg@gmail.com
> Web:www.margcompusoft.com

Choose other in data sources and build the connection string using OleDb provider for VFP. You may need to edit the generated code if you don't use the support that came with SP2 (I don't use that).
In code it looks like:
OleDbConnection cn = 
 new OleDbConnection(@"Provider=VFPOLEDB;Data Source=c:\MyFolder\MyDatabase.dbc");
// usual ADO.Net commands


You can create typed datasets and use Linq to dataset as well.

However, use VFP tables only if you're doing it to support existing applications in VFP. Otherwise using another backend like MS SQL is the way to go.

Cetin Basoz



COMPLETE THREAD
Can we operate .DBF files NET how ? Posted by Anup Singh @ 10/6/2008 1:10:55 PM
RE: Can we operate .DBF files NET Posted by surinder singh @ 10/6/2008 1:32:29 PM
RE: Can we operate .DBF files NET Posted by tushar @ 10/6/2008 2:33:00 PM
RE: Can we operate .DBF files NET Posted by Cetin Basoz @ 10/6/2008 3:36:34 PM
RE: Can we operate .DBF files NET Posted by Anup Singh @ 10/8/2008 11:18:20 AM
RE: Can we operate .DBF files NET Posted by Cetin Basoz @ 10/8/2008 12:11:20 PM
RE: Can we operate .DBF files NET Posted by Yuri Rubinov @ 10/8/2008 6:10:03 PM
RE: Can we operate .DBF files NET Posted by Anders Altberg @ 10/8/2008 6:50:43 PM
RE: Can we operate .DBF files NET Posted by Samir Ibrahim @ 10/8/2008 3:52:57 PM
RE: Can we operate .DBF files NET Posted by Anup Singh @ 10/10/2008 8:13:42 AM