wpf连接数据库

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

namespace WpfApp
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();

            // 连接字符串
            string connectionString = "Server=your_server_address;Database=your_database_name;User Id=your_username;Password=your_password;";

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

                    // 创建SqlCommand对象
                    string query = "SELECT * FROM YourTable";
                    SqlCommand command = new SqlCommand(query, connection);

                    // 执行查询并读取结果
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            // 处理查询结果
                            string result = reader["YourColumnName"].ToString();
                            // 将结果显示在UI元素中
                            // yourTextBox.Text = result;
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("连接数据库失败：" + ex.Message);
                }
            }
        }
    }
}