| Home » Categories » Multiple Categories |
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" %>
<script runat="server">
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.
|
Related Articles 
How to Deploy and host .Net Core 2 and Angular 6 app
Viewed 13062 times since Tue, Oct 23, 2018
Do you support MySQL WebAdmin Access?
Viewed 3214 times since Tue, May 1, 2012
Can I have more than one MySQL database on my hosting account?
Viewed 8476 times since Tue, May 1, 2012
Can I have one database user associated to more than 1 MS SQL database?
Viewed 3303 times since Tue, May 1, 2012
Do you support Remote MSSQL connection?
Viewed 3797 times since Mon, Apr 30, 2012
How often do you backup my website?
Viewed 4806 times since Tue, May 1, 2012
Can i login to my MySQL database via my own mySQL tool?
Viewed 3005 times since Mon, May 7, 2012
How To Solve Problem with Connection String on EF (Entity Framework) 4 or above
Viewed 31816 times since Mon, Apr 1, 2013
Do you allow custom COM components?
Viewed 2853 times since Tue, May 1, 2012
I receive this error message: "Directory Listing Denied. This Virtual Directory does not allow contents to be listed."
Viewed 10580 times since Mon, Apr 30, 2012
|
Subscribe to Article
Print Article-
Email Article to Friend
Export to PDF
Export to MS Word
Tweet This Article
Digg It
Stumble Upon
Del.icio.us