检查单据C#中是否存在特定字段

using System;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString"; // 替换为实际的数据库连接字符串

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            string tableName = "YourTableName"; // 替换为实际的表名
            string columnName = "YourColumnName"; // 替换为要检查的字段名

            // 查询表结构
            string query = $"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{tableName}' AND COLUMN_NAME = '{columnName}'";

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                object result = command.ExecuteScalar();

                if (result != null)
                {
                    Console.WriteLine($"字段 {columnName} 存在于表 {tableName} 中");
                    // 执行相应的操作
                }
                else
                {
                    Console.WriteLine($"字段 {columnName} 不存在于表 {tableName} 中");
                }
            }
        }
    }
}