c#程序实现服务器远程连接数据库

using System;
using System.Data;
using System.Data.SqlClient;

namespace RemoteDatabaseConnection
{
    class Program
    {
        static void Main(string[] args)
        {
            // 创建数据库连接字符串
            string connectionString = "Data Source=服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码";

            // 创建数据库连接对象
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                try
                {
                    // 打开数据库连接
                    connection.Open();

                    // 执行SQL查询
                    string sqlQuery = "SELECT * FROM 表名";
                    SqlCommand command = new SqlCommand(sqlQuery, connection);
                    SqlDataReader reader = command.ExecuteReader();

                    // 处理查询结果
                    while (reader.Read())
                    {
                        // 读取数据并进行相应的操作
                        string column1Value = reader.GetString(0);
                        int column2Value = reader.GetInt32(1);
                        Console.WriteLine("Column1: " + column1Value + ", Column2: " + column2Value);
                    }

                    // 关闭数据阅读器
                    reader.Close();
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);
                }
                finally
                {
                    // 关闭数据库连接
                    connection.Close();
                }
            }
        }
    }
}