ASP.NET 2.0 and MySQL

[dm1608]

Anyone know how I can query MySQL from ASP.NET 2.0 and populate a GridView
control?

 

[Michael Hamrah]

I think you want to use an odbc connector. Not sure about the
connection string.

 

[Mark Rae]

Anyone know how I can query MySQL from ASP.NET 2.0 and populate a GridView
control?

1) Install the native .NET data provider for MySQL
http://dev.mysql.com/downloads/connector/net/1.0.html

2) Connect to your MySQL database
http://www.connectionstrings.com/

3) Fetch your data into a MySQL DataSet or DataReader

4) Bind the datasource to your GridView

 

[Jacob]

Have you tried downloading the MySQL connector for dotNet? It's
available on their website.

 

[dm1608]

How does this work for Declaritve Data Binding? I.E., no code.

 

[Mark Rae]

How does this work for Declaritve Data Binding? I.E., no code.

I wouldn't have the slightest idea, thank God...

 

[dm1608]

Why? MySQL is a viable alternative to using SQL Server.

 

[Mark Rae]

Why? MySQL is a viable alternative to using SQL Server.

MySQL is fine - I've used it lots over the years - it's the nothing that you
think you can do anything useful in Visual Studio without code that I was
commenting on...