<%@ import namespace="System.Data" %>
<%@ import namespace="MySql.data.MySqlclient" %>
<%@ import namespace="MySql.data.MySqlclient.MySqlConnection" %>
<Script runat="server">
Sub page_load()
Dim dbconn As MySqlConnection
Dim dbCMD As MySqlCommand
Dim dtr As MySqldatareader
dbconn = New MySqlConnection("server=MySQL Server;database=MYSQL_database;user=DB Login;port=3306;password=DB password;")
dbconn.open()
dbCMD = New Mysqlcommand("select * from table_name", dbconn)
dtr = dbCMD.executereader()
While dtr.read()
Response.Write("<li>")
Response.Write(dtr(0) & "---" & dtr(1))
End While
dtr.close()
dbconn.close()
End Sub
</Script>
Most Popular Articles
AJAX: Unknown server tag 'asp:ScriptManager'
If, when accessing your ASP .NET application, the message "AJAX: Unknown server tag 'asp:...
How to send emails from ASP.NET / C# ?
To send emails from Windows platforms, you must use "SMTP authentication". Below is an example...
Is Rewrite URL available on Windows platform?
Yes, URL Rewrite is available for all Windows packages.
System.Security.SecurityException sau That assembly does not allow partially trusted callers
If you run an ASP .NET application, and the below error is returned:...
