Recently in learning to use VB to write a paragraph about the database code ~ but when Refresh Adodc always quote "the method of object Refresh IAdodc failure", the code is as follows:
Add records to the Adodc1. You. AddNew '
Adodc1. You. Fields (0)=Text4. Text
For I=1 To 4 'set the field content
Adodc1. You. Fields. (I)=MSFlexGrid2 TextMatrix (data_h, I)
Next I
Adodc1. You. Update
Adodc1. RecordSource="select * from shanghuobiao" 'query
Adodc1. Refresh 'to Refresh the ADO controls
Each run in Adodc1 Refresh this sentence has a problem ~ after blocking the line of code can run, also successfully adding new records to the database, excuse me each, how to solve this problem??