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.

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

Viewed 4755 times since Wed, Oct 24, 2018

Do you allow custom COM components?

Viewed 2607 times since Tue, May 1, 2012

Do you support MS SQL Profiler?

Viewed 3034 times since Wed, May 23, 2012

Do you support MySQL WebAdmin Access?

Viewed 2995 times since Tue, May 1, 2012

What is the connection string for my MySQL database?

Viewed 3798 times since Mon, May 7, 2012

Domain Name Server (DNS) Amplification Attack

Viewed 9212 times since Wed, Oct 15, 2014

What is the connection string for my mariaDB database?

Viewed 1391 times since Fri, Jun 26, 2020

Can I set up additional logins for my MySQL database?

Viewed 2677 times since Mon, Apr 30, 2012

How can I enable ASP.NET 3.5 on your Control Panel?

Viewed 3617 times since Wed, May 2, 2012

I cannot see my website. What should I do?

Viewed 3553 times since Thu, May 3, 2012

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