用ADO如何连接dbf数据库

Question

rt

Answer 1

在form上放一个ado 的adotable.其它的ado组件使用方法相防.
dbftable.Close;
dbftable.ConnectionString:='Driver={Microsoft Visual FoxPro Driver}; Deleted=Yes; Null=Yes; Collate=Machine; BackgroundFetch=No; Exclusive=No; SourceType=DBF; SourceDB=d:\alldbf;';
dbftable.TableName:='dbf1';
dbftable.Active:=true;shomessage(dbftable.FieldByName('用户名').AsString);
{
dbftable.edit;
dbftable.FieldByName('用户名').AsString:='小中';
dbftable.post;
}
dbftable.Active:=false;

Answer 2

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="