ASP.NET use SqlConnection connect MySQL

by

SqlConnection is for SQL Server. You need MySqlConnection – this is not part of the .NET Framework, so you will have to download it and reference it in your project. You can then create a MySqlConnection object and connect to MySQL in your application:

MySqlConnection connection = new MySqlConnection(myConnString);

You will also have to use the MySqlCommand object rather than the SqlCommand object.

http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqlconnection.html

More Related Contents:

  1. How do I run this code
  2. In C#, what is the difference between public, private, protected, and having no access modifier?
  3. System.MissingMethodException: Method not found?
  4. How can I create a dynamic button click event on a dynamic button?
  5. Dynamically Created Controls losing data after postback
  6. GridView must be placed inside a form tag with runat=”server” even after the GridView is within a form tag
  7. How to get client date and time in ASP.NET?
  8. Json.NET serialize object with root name
  9. Debug vs. release in .NET
  10. What’s the difference between the WebConfigurationManager and the ConfigurationManager?
  11. Read from word document line by line
  12. Visual Studio – Resx File default ‘internal’ to ‘public’
  13. HttpContext.Current.Session is null in Ashx file
  14. How can I use Dependency Injection in a .Net Core ActionFilterAttribute?
  15. .NET Configuration (app.config/web.config/settings.settings)
  16. C#, FindControl [duplicate]
  17. Getting current directory in .NET web application
  18. Application_Error in global.asax not catching errors in WebAPI
  19. Validating file types by regular expression
  20. Why do we need a private constructor?
  21. Can I use ASP.NET MVC together with regular ASP.NET Web forms
  22. Memory Mapped Files .NET
  23. Authentication Service using WCF
  24. Could not load file or assembly ‘System.Net.Http.Formatting’ or one of its dependencies. The system cannot find the path specified
  25. C# Clear Session
  26. Why does ServerVariable[“REMOTE_ADDR”] returns the server IP?
  27. Reading XML with an “&” into C# XMLDocument Object
  28. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0
  29. Limit only one session per user in ASP.NET
  30. Web Service without adding a reference?

Leave a Comment