FoxPro Database and asp.net

Question

I have a website that uses asp.net 3.5 and Sql server 2008 as backend data store . now we want to add a new page to our website . but the data that we want to share in this page is already being created and saved by a FoxPro software in one of our local systems.

I've no experience in FoxPro . is there any way to use this data in our site ? specially without being have to create a new database in server and importing or writing all records all over again ? what is the best way in such a situation ?

by the way , is it possible to change the extension of a FoxPro database or not ? something like Database.customExt ?

score 2 · Accepted Answer · answered Apr 17 '12 at 16:17

2

You can connect to a FoxPro database using an OLEDB datasource in ADO.NET. It's up to you whether you feel the need to import the data into SQL Server or just access it directly in FoxPro. It would depend on whether you want to join the data with the SQL Server data in queries for one thing.

answered Apr 17 '12 at 16:17

Simon

6,062
13
60
97

thank you , I feel better now . then , does it need a server like SQL SERVER or is file-based and we can copy it into our app_data and use it ? and do you have any idea about second question about extension – mohsen dorparasti Apr 17 '12 at 16:23
It's file based and doesn't require a server. I don't know what would happen if you changed the extension... – Simon Apr 18 '12 at 10:26

score 2 · Answer 2 · answered Apr 17 '12 at 18:31

2

In addition to the answers that you already got. You might be interested in using LINQ to VFP or VFP Entity Framwork Provider to make the data access even easier by using LINQ.

answered Apr 17 '12 at 18:31

Tom Brothers

5,929
1
20
17

score 1 · Answer 3 · answered Apr 17 '12 at 16:56

You could create a linked server to this Foxpro Database.

Also, Foxpro tables can have any extension. However, you'll have to specify the extension when using the table or database. For Example:

OPEN DATABASE MyFoxProDatabase.customExt
USE mytable.custonExt

score 1 · Answer 4 · answered Apr 17 '12 at 17:07

You have several options for structuring your data access to FoxPro. You can put the ADO.NET data access code in the codebehind, in it's own c# library or use the objectdatasource for 2 way binding.

private void LoadData(string parameter)
{
    string sql = "SELECT a.myfield FROM mytable.customExt a WHERE a.whereField=?";
    using(OleDbConnection conn = new OleDbConnection(myConnectionString))
    {
        using (OleDbCommand command = new OleDbCommand(sql, conn))
        {
            command.Parameters.AddWithValue("@Parameter", parameter);

            try
            {
                conn.Open();
                using(OleDbDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    myGridView.DataSource = dr;
                    myGridView.DataBind();
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
    }
}

Here is a sample connection string to use in web.config:

<add name="myData" connectionString="Provider=VFPOLEDB.1;Data Source=C:\MyFiles\" providerName="System.Data.OleDb"/>

I belive ou can use a custom extension to your FoxPro tables and databases. All your SQL statements would then need to explicitly use that extension.

SELECT t.MyField FROM MyTable.customExt t

thank you , so FoxPro is file-based and just needs to be copied into my app_data . right ? — mohsen dorparasti, Apr 17 '12 at 17:18
@reza - The file(s) can be anywhere on your file system that your code can read and/or write to. FoxPro is file-based. — DaveB, Apr 17 '12 at 18:35

score 1 · Answer 5 · answered Apr 17 '12 at 20:35

While you can change the extension for a Visual FoxPro table, that only affects the DBF file. If the table has any memo fields, there's an associated FPT file, for which you can't change the extension. Similarly, if the table has an associated index file, it must have a CDX extension.

So, if the reason you want to change the extension is to allow multiple tables with the same filestem, don't. It's a good way to really mess things up.

FoxPro Database and asp.net

5 Answers5

Linked