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 do I query MySQL Database in PHP ?

Viewed 1700 times since Tue, May 1, 2012

Do you support SQL 2012?

Viewed 1767 times since Fri, May 4, 2012

Do you allow custom COM components?

Viewed 1708 times since Tue, May 1, 2012

How often do you backup my website?

Viewed 2895 times since Tue, May 1, 2012

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

Viewed 4396 times since Tue, May 1, 2012

My application pool stops working. What is wrong with my site?

Viewed 2551 times since Sun, Feb 15, 2015

My website session times out earlier than expected. Why?

Viewed 2995 times since Tue, May 1, 2012

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

Viewed 1836 times since Tue, May 1, 2012

Do you support SQL 2014?

Viewed 1687 times since Tue, Feb 3, 2015

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

Viewed 514 times since Wed, Oct 24, 2018

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