Argentini.Halide.H3Reader.GetDate C# (CSharp) Method

GetDate() public method

Read a column value in as a string formatted as a date.
public GetDate ( string columnName ) : string
columnName string Name of column to retrieve
return string
        public string GetDate(string columnName)
        {
            string output = string.Empty;

            try
            {
                int ord = (dr_Oledb != null ? dr_Oledb.GetOrdinal(columnName) : dr.GetOrdinal(columnName));

                if (dr_Oledb != null)
                {
                    if (dr_Oledb.IsDBNull(ord))
                    {
                        output = "";
                    }

                    else
                    {
                        output = dr_Oledb.GetDateTime(ord).ToString("M/d/yyyy");
                    }
                }

                else
                {
                    if (dr.IsDBNull(ord))
                    {
                        output = "";
                    }

                    else
                    {
                        output = dr.GetDateTime(ord).ToString("M/d/yyyy");
                    }
                }
            }

            catch (Exception err)
            {
                _lastSqlError = err;
            }

            return output;
        }