Hi,

I saw three different syntaxes in command lines:
UpdateCommand="UPDATE [mytable] SET [name] = @name ...
UpdateCommand="Update `mytable` set `name`=? ...
UpdateCommand="UPDATE [mytable] SET [name] = ? ...

Does the three do the same?
Why those differences?
Thanks

Hi hertendreef,

It depends on the data source you're using. The ? will work with databases like Access, while the @name works with SQL Server.

The [] are used to enclose database objects that have (semi) invalid names, containing reserved words or spaces. Enclosing the name in [] tells the database to take the text between them as literal text.

I am not sure if your second example works; may work on other databases...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Thanks