| public ColumnName ( int columnNumber ) : string | ||
| columnNumber | int | Number of column to retrieve. |
| return | string | |
/// <summary>
/// Initialize the DatabaseRow with a single row form a Halide.H3Reader object.
/// </summary>
/// <param name="reader">An open Halide.H3Reader object that can be used to read a row from a database.</param>
public DatabaseRow(H3Reader reader)
{
_fieldCount = reader.FieldCount;
try
{
_dataItems = new DatabaseItem[_fieldCount];
if (_dataIndex != null) _dataIndex.Clear();
for (int x = 0; x < _fieldCount; x++)
{
_dataItems[x] = new DatabaseItem();
String columnName = reader.ColumnName(x).ToLower();
_dataIndex.Add(columnName, x);
_dataItems[x].IsNullable = reader.GetColumnAllowNulls(columnName);
_dataItems[x].ColumnName = columnName;
_dataItems[x].ColumnSize = reader.GetColumnSize(columnName);
_dataItems[x].ColumnSQLType = reader.GetDataTypeName(columnName).ToLower();
_dataItems[x].IsAutoIncrementing = reader.GetColumnIsAutoIncrement(columnName);
_dataItems[x].IsIdentity = reader.GetColumnIsIdentity(columnName);
_dataItems[x].IsPrimaryKey = reader.GetColumnIsKey(columnName);
_dataItems[x].SystemDataType = reader.GetColumnSystemDataType(columnName).ToLower();
_dataItems[x].Value = reader.GetString(columnName);
}
}
catch
{
}
}
/// <summary>
/// Generate CSV data from a SQL Server request. Converts quotation marks to """.
/// </summary>
/// <param name="select">SQL Server command to execute, which retrieves a dataset.</param>
/// <param name="connectionStringName">Connection String name in the Web.config file.</param>
/// <param name="includeHeaders">Include column names as a header row in the CSV file.</param>
/// <param name="alwaysUseQuotes">Wrap all values in quotation marks. False will omit quotation marks around numeric values.</param>
/// <returns>StringBuilder result with the new CSV data.</returns>
public static StringBuilder GenerateCSV(String select, String connectionStringName, Boolean includeHeaders, Boolean alwaysUseQuotes)
{
StringBuilder csv = new StringBuilder();
using (H3Reader reader = new H3Reader(select, true, connectionStringName))
{
#region Build header row
if (includeHeaders)
{
for (Int32 x = 0; x < reader.FieldCount; x++)
{
if (x > 0)
{
csv.Append(",");
}
csv.Append("\"" + reader.ColumnName(x) + "\"");
}
csv.Append("\r\n");
}
#endregion
#region Build data rows
ArrayList types = new ArrayList();
types.Add("int");
types.Add("bigint");
types.Add("float");
types.Add("decimal");
types.Add("numeric");
types.Add("money");
types.Add("tinyint");
types.Add("int");
types.Add("smallint");
types.Add("smallmoney");
types.Add("real");
while (reader.Read())
{
for (Int32 x = 0; x < reader.FieldCount; x++)
{
if (x > 0)
{
csv.Append(",");
}
if (!alwaysUseQuotes && types.Contains(reader.GetDataTypeName(x).ToLower()))
{
csv.Append(reader[x]);
}
else
{
csv.Append("\"" + reader[x].Replace("\"", """) + "\"");
}
}
csv.Append("\r\n");
}
#endregion
}
return csv;
}
