First download VFPOLEDB driver from http://msdn.microsoft.com/vfoxpro/
Then all you need is to use OleDb with VisualFoxpro driver. Here is a very simple sample that I posted before (assuming you have the sample data):
<%@ Page Language="C#" AutoEventWireup="True" EnableViewState="False"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="C#" runat="server">
private string strCon = @"Provider=VFPOLEDB;
Data Source= C:\Program Files\Microsoft Visual FoxPro 9\Samples\Data\testdata.dbc";
void Page_Load(Object sender, EventArgs e)
{
if (!IsPostBack)
{
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = strCon;
cn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from customer",cn);
DataSet ds = new DataSet();
da.Fill(ds,"Customer");
cn.Close();
myDataGrid.DataSource = ds;
myDataGrid.DataMember = "Customer";
myDataGrid.DataBind();
}
}
private void GetCustomerOrders(object sender,EventArgs e)
{
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = strCon;
cn.Open();
string strSelect = String.Format("select * from orders where cust_id = '{0}'",
myTextBox.Text);
OleDbDataAdapter da = new OleDbDataAdapter(strSelect,cn);
DataSet ds = new DataSet();
da.Fill(ds,"orders");
cn.Close();
ordersDataGrid.DataSource = ds;
ordersDataGrid.DataMember = "orders";
ordersDataGrid.DataBind();
}
</script>
<body>
<form runat="server">
Enter customer id:<asp:textbox id="myTextBox" runat="server"/>
<asp:button type="submit" id="cmdGetData" runat="server"
onClick="GetCustomerOrders" Text="Get Customer's Orders"/>
<asp:datagrid id="ordersDataGrid" runat="server"/>
<asp:datagrid id="myDataGrid" runat="server"/>
</form>
</body>
</html>
| 
