Dim CNN AsNew ADODB.Connection Dim STRSQL AsString '打开 PrivateSub Form_Load()Sub Form_Load() CNN.ConnectionString ="Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDb=E:DBF" CNN.Open End Sub '创建 PrivateSub Command1_Click()Sub Command1_Click() CNN.CursorLocation = adUseClient STRSQL ="CREATE TABLE E:DBFDEMO.DBF ([IDA] CHAR(32),[NAME] CHAR(32))" CNN.Execute STRSQL 'CNN.Close End Sub '添加 PrivateSub Command2_Click()Sub Command2_Click() STRSQL ="insert into demo([ida],[NAME]) values('1','sdf')" CNN.Execute STRSQL End Sub '显示 PrivateSub Command3_Click()Sub Command3_Click() Dim rs AsNew ADODB.Recordset STRSQL ="select * from demo" Set rs = CNN.Execute(STRSQL) IfNot rs.EOF Then Text1.Text = rs.Fields(1) EndIf End Sub '修改 PrivateSub Command4_Click()Sub Command4_Click() STRSQL ="update demo set name='好好' where ida='1'" CNN.Execute STRSQL End Sub