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.

Do you support MS SQL Profiler?

Viewed 1992 times since Wed, May 23, 2012

How to Solve the error: "405 - HTTP verb used to access this page is not allowed"?

Viewed 33 times since Wed, Oct 24, 2018

Can I set up additional logins for my MS SQL database?

Viewed 1701 times since Mon, Apr 30, 2012

I cannot see my website. What should I do?

Viewed 2160 times since Thu, May 3, 2012

How To Solve Problem with Connection String on EF (Entity Framework) 4 or above

Viewed 14480 times since Mon, Apr 1, 2013

How can I restore my MS SQL database?

Viewed 5042 times since Tue, May 1, 2012

How do I send an email from my ASP.NET website by using SMTP Authentication?

Viewed 4054 times since Tue, May 1, 2012

How can I backup my MS SQL database?

Viewed 3429 times since Tue, May 1, 2012

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

Viewed 1972 times since Tue, May 1, 2012

How often do you backup my website?

Viewed 2623 times since Tue, May 1, 2012

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