asp.net连接sql数据库的源代码

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

public class DatabaseHelper
{
    // 数据库连接字符串
    private static string connectionString = "Server=your_server_name;Database=your_database_name;User Id=your_username;Password=your_password;";

    // 执行查询的方法
    public static DataTable ExecuteQuery(string query)
    {
        DataTable result = new DataTable();
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                result.Load(reader);
            }
            catch (Exception ex)
            {
                Console.WriteLine("数据库连接或查询执行出错: " + ex.Message);
            }
        }
        return result;
    }
}