Connect to MySQL with ASP.Net

<%@ import namespace="System.Data" %> 
<%@ import namespace="MySql.data.MySqlclient" %>
<%@ import namespace="MySql.data.MySqlclient.MySqlConnection" %>
<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;")
dbconn.open()
dbCMD = New Mysqlcommand("select * from table_name", dbconn)
dtr = dbCMD.executereader()
While dtr.read()
Response.Write("<li>")
Response.Write(dtr(0) & "---" & dtr(1))
End While
dtr.close()
dbconn.close()
End Sub
</Script>
  • 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...