shaik irshad sharif shaik irshad sharif - 1 year ago 123
MySQL Question

ASP and MySQL connectivity

Is there a way to access mysql database using connection string in ASP.Net application?

<add name=""
connectionString="" />

Answer Source

You need to first have MySql .Net connector plugin installed in your system. If you don't have, get it and install it:

Then you can simply define your connection string as below:

<add name="MySQLCnn" connectionString="server=[SERVER Address];User Id=[Your Username];password=[Your Password];database=[Database Name]" providerName="MySql.Data.MySqlClient" />

Here is a simple code which will help you in through this way:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download