| <%@ 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> |
Article ID: 166, Created: July 25, 2012 at 12:37 AM, Modified: July 25, 2012 at 12:37 AM