.NET 判断表的某列是否存在

作者：vkvi 来源：ITPOW（原创）日期：2012-10-12

public DataTable Select(string commandText)
{
    using (DataTable result = new DataTable())
    {
        using (SQLConnection conn = new SQLConnection(ConnectionString))
        {
            conn.Open();
            using (SQLDataAdapter adapter = new SQLDataAdapter(commandText, conn))
            {
                adapter.Fill(result);
            }
            conn.Close();
        }
        
        return result;
    }
}


public bool CheckColumnExists(string tableName, string columnName)
{
    bool result = false;

    using (DataTable dataTable = Select("select * from " + tableName + " where 1=0"))
    {
        if (dataTable.Columns.Contains(columnName))
        {
            result = true;
        }
    }
    
    return result;
}

电邮：cftea@126.com