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.

Issue with Storing Session

Viewed 4345 times since Tue, Mar 24, 2015

Can i login to my MySQL database via my own mySQL tool?

Viewed 3708 times since Mon, May 7, 2012

How to Solve an Error Message "Validation of viewstate MAC failed"

Viewed 10361 times since Tue, Apr 2, 2013

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

Viewed 7207 times since Mon, May 7, 2012

Do you support SQL Server Integration Service?

Viewed 3438 times since Tue, May 1, 2012

I cannot see my website. What should I do?

Viewed 4376 times since Thu, May 3, 2012

Do you support MySQL WebAdmin Access?

Viewed 3802 times since Tue, May 1, 2012

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

Viewed 1666 times since Sun, Mar 9, 2025

Do you support SQL 2012?

Viewed 3866 times since Fri, May 4, 2012

How To Solve Problem with Connection String on EF (Entity Framework) 4 or above

Viewed 33047 times since Mon, Apr 1, 2013

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