How do I query MySQL database in ASP.NET?

Article Number: 84 | Rating: Unrated | Last Updated: Tue, May 1, 2012 at 11:15 PM

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)

myConnection.Open()

Dim myReader As OdbcDataReader = myCommand.ExecuteReader()

Try

While myReader.Read()

Response.Write (myReader("name") & "<br>")

End While

Finally

//always call Close when done reading.

myReader.Close()

//always call Close when done with connection.

myConnection.Close()

End Try

End Sub

</script>

Attachments

There are no attachments for this article.

What is my MS SQL Connection String on the web.config?

Viewed 45296 times since Tue, May 1, 2012

Do you allow custom COM components?

Viewed 2885 times since Tue, May 1, 2012

Do you support MySQL WebAdmin Access?

Viewed 3250 times since Tue, May 1, 2012

Sample Code to Send email using ASP.NET 2

Viewed 9730 times since Tue, May 1, 2012

I receive this error message: "Unknown file type (binary data)" when trying to deploy my SQL CE database. What did I do wrong?

Viewed 4340 times since Thu, May 3, 2012

How to Solve an Error Message "Validation of viewstate MAC failed"

Viewed 9414 times since Tue, Apr 2, 2013

Can I have more than one MS SQL database on my hosting account?

Viewed 3763 times since Tue, May 1, 2012

Do you support MS SQL Profiler?

Viewed 3305 times since Wed, May 23, 2012

How do I redirect a subdomain to a subdirectory?

Viewed 4059 times since Tue, May 1, 2012

What is the connection string for my MySQL database?

Viewed 4219 times since Mon, May 7, 2012

KB Home \| Advanced Search \| News \| Glossary \| Login
ASP.NET Hosting Knowledge Base