ASP.NET+MySQL简明图示入门

第十步 示例程序

至此我们的数据库终于完成，MySQL Connector/Net也安装成功，我们该做点 其他什么事情了。下面我将提供一段简单的脚本，在这段脚本中，我们将连接和 查询数据库中的数据，输入数据不是脚本的要点。 MySQL.aspx

<%@ Page Language="VB" debug="true" %>
<%@ Import Namespace = "System.Data" %>
<%@ Import Namespace = "MySql.Data.MySqlClient" %>
<script language="VB" runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
　 Dim myConnection As MySqlConnection
　 Dim myDataAdapter As MySqlDataAdapter
　 Dim myDataSet As DataSet
　 Dim strSQL As String
　 Dim iRecordCount As Integer
　 myConnection = New MySqlConnection("server=localhost; user id=15secs; password=password; database=mydatabase; pooling=false;")
　 strSQL = "SELECT * FROM mytable;"
　 myDataAda