Last post Nov 08, 2010 09:02 PM by andrewjboyd
Nov 08, 2010 08:12 PM|Sojan80|LINK
I'd like to have to two tables Countries and states and make it so that any MySql user can access them for the purpose of building databiund drop down lists. What permissions do I need to assign the tables or what's the best way to do this?
Nov 08, 2010 09:02 PM|andrewjboyd|LINK
Set the read permission's on the table for the user you'd be using the connect to MySQL with
Use a MySQLCommand to execute the query (alternatively use the Devart data connector and use Entity Framework)
Check this out