Am I right?--ADO and SQL Server

[everjoe]

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.

[Ianpbaker]

Hi everjoe

There is nothing programatically wrong with using the connection.execute statment, in fact it can be faster because the server is handling most of the work instead of the user computer. The main problem is when adding or updating string records. As you probably know when using SQL strings in vb you need to use the ' character to enclose so it doesn't interfere with vb's ", That's all fine and dandy as long as the string you are inserting doesn't have a ' in it. if it did you would get the following output

strSQL = "UPDATE test SET mystring = 'doesn't'"
which would obviously fail.

So as long as you take that into account in your code, there isn't anything worng with doing this.

Ian

[parkes]

Thats the way I tend to use it to, as I've monitored the resources being used by the PC when using these methods and it doesn't use as much as using the Addnew, etc.

One thing you could also make use of is the Data Enviroment as it makes accessing your Tables, etc easier.

[everjoe]

Thank you for your kindness,Lanpbaker and Parkes.
All your suggestions benefit me greatly.
I have little chance to deal with strings with the ' characters in them.So,as you have mentioned,using the Execute method and SQL statements to add and update and delete data is not a hard way.
I have never used the Data Enviroment.I will take a look at it.
Thank you again.

[Edited by everjoe on 08-08-2000 at 11:57 AM]