How do I query MySQL database in ASP.NET?
| In order to query your mySQL Database with ASP.NET script, you need to organize an ODBC connection with us first. The following the snippet of the code:
<%@ Page Language="VB" %>
<%@ import Namespace="System.Data.Odbc" %>
Public Sub Page_Load()
Dim mySelectQuery As String = "SELECT * FROM tblTest"
Dim myConnection As New OdbcConnection("DSN=<username>_mysqlConn")
Dim myCommand As New OdbcCommand(mySelectQuery, myConnection)
Dim myReader As OdbcDataReader = myCommand.ExecuteReader()
Response.Write (myReader("name") & "<br>")
//always call Close when done reading.
//always call Close when done with connection.
|Posted by: ASPHostServer Administrator - Tue, May 1, 2012 at 11:15 PM. This article has been viewed 4465 times.|
|Online URL: http://faq.asphosthelpdesk.com/article.php?id=84|