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 Deploy and host .Net Core 2 and Angular 6 app

Viewed 13609 times since Tue, Oct 23, 2018

Can you grant SELECT PRIVILEGE to the system table mysql.proc

Viewed 6504 times since Mon, Jun 18, 2012

Do you support SQL 2012?

Viewed 3645 times since Fri, May 4, 2012

Issue with Storing Session

Viewed 4054 times since Tue, Mar 24, 2015

How to solve ReportViewer error message: "An error has occurred during report processing. Input string was not in a correct format"

Viewed 8537 times since Tue, Jun 18, 2013

How often do you backup my website?

Viewed 5115 times since Tue, May 1, 2012

What is the connection string for my MySQL database?

Viewed 4489 times since Mon, May 7, 2012

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

Viewed 4149 times since Wed, May 2, 2012

Do you support Remote mySQL connection?

Viewed 3817 times since Mon, Apr 30, 2012

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

Viewed 6834 times since Tue, May 1, 2012

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