Connect to MySQL with ASP.Net

<%@ import namespace="System.Data" %> 
<%@ import namespace="" %>
<%@ import namespace="" %>
<Script runat="server">
Sub page_load()
Dim dbconn As MySqlConnection
Dim dbCMD As MySqlCommand
Dim dtr As MySqldatareader
dbconn = New MySqlConnection("server=MySQL Server;database=MYSQL_database;user=DB Login;port=3306;password=DB password;")
dbCMD = New Mysqlcommand("select * from table_name", dbconn)
dtr = dbCMD.executereader()
Response.Write(dtr(0) & "---" & dtr(1))
End While
End Sub
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

SQL server- network related or instance-specific error happened while connection establishing

  Instance-specific or network related error happening while connecting to SQL server   Please...

OleDB connection string examples

OleDB connection string examples MS Access (Jet) "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA...

Do you allow custom COM components?

Do you allow custom COM components? We are not offering to install the custom COM components...

Error when accessing a WCF services

Error when accessing a WCF services Error when accessing a WCF service: "IIS specified...

How to cache static contents to client with UseMaxAge?

You can consider to caches static contents to the client with UseMaxAge if your website has too...