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 13902 times since Tue, Oct 23, 2018

Sample Code to Send email using ASP.NET 2

Viewed 10179 times since Tue, May 1, 2012

Sample Code to Send email using ASP.NET1.1

Viewed 5881 times since Tue, May 1, 2012

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

Viewed 13753 times since Sun, Feb 15, 2015

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

Viewed 10162 times since Tue, Apr 2, 2013

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

Viewed 7040 times since Mon, May 7, 2012

Do you support SQL Server Integration Service?

Viewed 3334 times since Tue, May 1, 2012

Can I set up additional logins for my MS SQL database?

Viewed 3500 times since Mon, Apr 30, 2012

Can I have one database user associated to more than 1 MS SQL database?

Viewed 3804 times since Tue, May 1, 2012

I cannot see my website. What should I do?

Viewed 4240 times since Thu, May 3, 2012

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