Code Forums - View Single Post

goalstopper · 07-07-2005, 11:09 AM

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

07-07-2005, 11:09 AM	#1 (permalink)
goalstopper Registered User Join Date: Jul 2005 Posts: 1	VB and MySQL 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