如何使用C#检查SQL查询是否成功

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Your_Connection_String_Here";
        string sqlQuery = "SELECT * FROM YourTable";

        try
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(sqlQuery, connection);
                connection.Open();

                // 执行查询并获取结果
                SqlDataReader reader = command.ExecuteReader();

                // 读取结果
                while (reader.Read())
                {
                    // 处理每一行数据
                }

                // 关闭DataReader
                reader.Close();
            }
            Console.WriteLine("查询成功执行。");
        }
        catch (SqlException ex)
        {
            Console.WriteLine("SQL错误: " + ex.Message);
        }
        catch (Exception ex)
        {
            Console.WriteLine("其他错误: " + ex.Message);
        }
    }
}