asp怎么连接mysql

<%@ Language=VBScript %>
<%
Dim conn
Dim connStr
Dim rs

' 数据库连接字符串
connStr = "DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=your_server;PORT=your_port;DATABASE=your_database;UID=your_username;PWD=your_password;"

' 创建连接对象
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connStr

' 执行查询
Dim sql
sql = "SELECT * FROM your_table"
Set rs = conn.Execute(sql)

' 输出结果
Do While Not rs.EOF
    Response.Write rs("column_name") & "<br>"
    rs.MoveNext
Loop

' 关闭连接
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>

using System;
using System.Data;
using MySql.Data.MySqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string connectionString = "Server=your_server;Port=your_port;Database=your_database;Uid=your_username;Pwd=your_password;";
        using (MySqlConnection conn = new MySqlConnection(connectionString))
        {
            conn.Open();
            string sql = "SELECT * FROM your_table";
            using (MySqlCommand cmd = new MySqlCommand(sql, conn))
            {
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Response.Write(reader["column_name"].ToString() + "<br>");
                    }
                }
            }
        }
    }
}