OLE DB Provider for Visual FoxPro
oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp7\Samples\Data\myVFPDB.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
For more information, see: Microsoft OLE DB Provider for Visual FoxPro To view Microsoft KB articles related to OLE DB Provider for Visual FoxPro, click here.Note: The Visual FoxPro OLE DB Provider is NOT installed by MDAC 2.x. You must install Visual FoxPro 7.0 in order to get it's OLE DB Provider.
oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp7\Samples\Data\myVFPDB.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
For more information, see: Microsoft OLE DB Provider for Visual FoxPro To view Microsoft KB articles related to OLE DB Provider for Visual FoxPro, click here.Note: The Visual FoxPro OLE DB Provider is NOT installed by MDAC 2.x. You must install Visual FoxPro 7.0 in order to get it's OLE DB Provider.
DataSet ds=new DataSet("xxxx");
mycc="Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;K:\\c#\\21点\\bin\\Debug";
Microsoft.Data.Odbc.OdbcConnection oleconnection=new Microsoft.Data.Odbc.OdbcConnection(mycc);
Microsoft.Data.Odbc.OdbcDataAdapter oledatareader=new Microsoft.Data.Odbc.OdbcDataAdapter();
sqlc="select * from xx";
oledatareader.SelectCommand=new Microsoft.Data.Odbc.OdbcCommand(sqlc,oleconnection);
dataGrid1.Visible=true;
oledatareader.Fill (ds,"xx");
dataGrid1.DataSource =ds.Tables ["xx"].DefaultView;
dataGrid1.Show();