SQL question

[e-spike]

I'm having some trouble with some simple .net stuff. I'm trying to use visual studio, but with a mysql database rather than an mssql database. I set up the connection etc fine, but when i try and follow a tutorial to use parameters in my querystring when creating a dataset, it says that there was an invalid @ found near the where clause. Is it only msSql querys that support parameters, or is there another way to define them for mysql. I'm trying to follow this tutorial:

http://download.microsoft.com/download/8/5/8/85803fdd-fe9a-4783-ab37-e0c565172ffd/asp_net_atlas.wmv

 

[Haircut]

Never used MySQL, but as far as I know the @ for parameters is a MSSQL thing only.

 

[e-spike]

so what do i use to have parameters in mysql?

 

[.Andy]

you use ? i.e, ?parameterName

 

[e-spike]

you use ? i.e, ?parameterName

sure thats not querystring stuff?