VB and MySQL

[goalstopper]

I am very much a newbie. I need some help getting results. I want to run a count query against a MySQL table using VB.net. The query is very simple 'SELECT COUNT(*) FROM tempdata WHERE cto = '7488'.

If I run this on the server is get a return value of 4. What I can't figure out is how to get that returned value in VB.NET. I can open the connection. I just cant figure out how to get that returned value from the count. It cant be that difficult. Can anyone help?

Thanks

[redhead]

have you checked the VB.net-MySQL tutorial ?
Look about 3/5 down into it, where it states Retrieving the User ID With A Parameterized Query, it should give you an idear.. especialy the line:
UserID = myCommand.ExecuteScalar
kinda gives me the idear that in this example the UserID will be holding the fetched result from the query.

[rdove]

the .NET framework is not equipped with a provider for for MySQL, you will need to download one.

Google returns numerous amounts of results for providers:
http://www.google.com/search?hl=en&l...+data+provider