Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

How to 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>  


If you run in to problems using this code, please post in our community forum. Technical support cannot assist with specific coding related issues.

Article ID: 833, Created On: 8/16/2010, Modified: 4/21/2011