Thanks for the links + google searches (which you can also send using www.lmgtfy.com
, for example like this: http://www.lmgtfy.com/?q=Books+by+Imar+Spaanjaars
First I read and installed:
(installation went fine, but I haven't tried it out yet as I first want to make sure I can somehow retrieve something from my mySQL database)
Then I realized that I had to install the ODBC MySQL Connector:
However I did not know how to make VWD "see" the ODBC connector until I found this really great article, about how to setup an ODBC connection to a database:
Now I can actually "see" my database and browse it through the solution explorer in VWD - however I'm not sure if I can just use the GridView control, drag it into an aspx page and bind it to a datatable (called GaveListe in the DB). I tried to do this (using my ODBC connection string) - but when I try to save this in "Save the configuration string to the application configuration file" I get the following error:
Database schema could not be retrived for this connection. Please make sure the connection settings are correct and the database is online. The conncetion has been disabled.
(however I can still press "ok" and get through the GridView guide for configuring the datasource)
But when I try to "run" my application I receive the following exception:
ERROR  [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[GaveListe]' at line 1
(which I kind of expected as the datasource configuration for the GridView did not complete error free)
Can I do it like I do it? (meaning setup GridView to use my mySQL connection string and still expect to be able to add "UPDATE, DELETE, etc" to the control) - Or do I need to write something more? (note that my DB is currently empty - It's just the table "GaveListe" that I have created without any content).
Br. Allan R