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.

My site is showing 500 Internal Server error message. What is wrong here?

Viewed 4147 times since Thu, May 3, 2012

I get an error Server.CreateObject Failed when I try to use CDONTs. What can I do?

Viewed 3274 times since Tue, May 1, 2012

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

Viewed 4225 times since Wed, May 2, 2012

Can I have one database user associated to more than 1 MS SQL database?

Viewed 3706 times since Tue, May 1, 2012

Do you support Remote MSSQL connection?

Viewed 4158 times since Mon, Apr 30, 2012

I cannot see my website. What should I do?

Viewed 4157 times since Thu, May 3, 2012

How can I change my SQL Server collation name?

Viewed 3829 times since Mon, May 21, 2012

Do you support ASP.NET MVC 6?

Viewed 5167 times since Wed, Feb 17, 2016

How to Restore MSSQL Database by using "Import Dump"?

Viewed 1009 times since Sun, Mar 9, 2025

Domain Name Server (DNS) Amplification Attack

Viewed 9863 times since Wed, Oct 15, 2014

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