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.

What is the connection string for my MySQL database?

Viewed 4293 times since Mon, May 7, 2012

How to Backup MSSQL Database by using "Export Dump"?

Viewed 438 times since Sun, Mar 9, 2025

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

Viewed 3972 times since Wed, May 2, 2012

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

Viewed 6620 times since Mon, May 7, 2012

Issue with Storing Session

Viewed 3886 times since Tue, Mar 24, 2015

How to solve the Let’s Encrypt SSL on ASP.NET Core

Viewed 9689 times since Mon, Jul 17, 2017

How do I query MySQL Database in PHP ?

Viewed 3486 times since Tue, May 1, 2012

Do you support MySQL WebAdmin Access?

Viewed 3336 times since Tue, May 1, 2012

What is my MS SQL Connection String on my SQL Management Studio tool?

Viewed 48016 times since Tue, May 1, 2012

Do you support ASP.NET MVC 6?

Viewed 4812 times since Wed, Feb 17, 2016

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