| 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 
My website session times out earlier than expected. Why?
Viewed 5453 times since Tue, May 1, 2012
Do you support SQL 2014?
Viewed 3864 times since Tue, Feb 3, 2015
Do you support SQL 2012?
Viewed 3813 times since Fri, May 4, 2012
Do you support ASP.NET MVC 6?
Viewed 5372 times since Wed, Feb 17, 2016
Do you support Remote MSSQL connection?
Viewed 4360 times since Mon, Apr 30, 2012
How often do you backup my website?
Viewed 5392 times since Tue, May 1, 2012
How to solve the Let’s Encrypt SSL on ASP.NET Core
Viewed 10264 times since Mon, Jul 17, 2017
Can I have more than one MS SQL database on my hosting account?
Viewed 4234 times since Tue, May 1, 2012
Do you allow custom COM components?
Viewed 3394 times since Tue, May 1, 2012
Can I set up additional logins for my MySQL database?
Viewed 3455 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