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 2551 times since Thu, May 3, 2012

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

Viewed 11602 times since Sun, Feb 15, 2015

How to Deploy and host .Net Core 2 and Angular 6 app

Viewed 10397 times since Tue, Oct 23, 2018

Do you support SQL Server Integration Service?

Viewed 2091 times since Tue, May 1, 2012

Do you support ASP.NET MVC 6?

Viewed 3129 times since Wed, Feb 17, 2016

Do you support Remote MSSQL connection?

Viewed 2700 times since Mon, Apr 30, 2012

I cannot login to my MS SQL database remotely. What did I do wrong?

Viewed 5008 times since Mon, May 7, 2012

Issue with Storing Session

Viewed 2508 times since Tue, Mar 24, 2015

I cannot find a way to enable ASP.NET 4.5 on my Control Panel

Viewed 9676 times since Tue, Sep 11, 2012

How often do you backup my website?

Viewed 3598 times since Tue, May 1, 2012

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