iis通过域名远程连接数据库

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Server=yourdomain.com,1433;Database=YourDatabase;User Id=YourUsername;Password=YourPassword;";
        
        try
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("Connected to the database successfully!");
                
                // 执行数据库操作
                SqlCommand command = new SqlCommand("SELECT * FROM YourTable", connection);
                SqlDataReader reader = command.ExecuteReader();
                
                while (reader.Read())
                {
                    Console.WriteLine(reader["ColumnName"].ToString());
                }
                
                reader.Close();
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("Error: " + ex.Message);
        }
    }
}