Hi all.
I am a novice at VB and SQL Server.Now I am working around a project accessing SQL server databases via ADO.

Restricted to the network bandwidth,the minimum data exchange is prefered.

All my forms share one ADO connection.When manipulating data,I use the "execute" method of the command object instead of using the "AddNew,Delete,Update" method of the RecordSet object.
Is that the most efficient way?Could you give me any suggestions?

Thanks in advance.