ADO.NET Provider for Smartsheet

Build 25.0.9434

Header

Specifies whether the first row of the data is treated as column headers or not.

Data Type

bool

Default Value

false

Remarks

This property determines how the provider handles the first row of data when assigning column names. If set to true, the first row is used as column headers, allowing for more descriptive column names. If set to false, the provider assigns generic names, which may be less intuitive but avoids relying on the contents of the data.

When interpreting the first row as headers, certain conditions must be met. Column headers should not contain special characters, as these may cause parsing errors. Additionally, all column headers must be non-empty to ensure proper detection and assignment. While meaningful column names can simplify query writing and improve data readability, users should ensure that the first row in the dataset truly represents headers to avoid misinterpretation.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434