MySql.Data.MySqlClient.MySqlDataReader.GetTimeSpan C# (CSharp) Method

GetTimeSpan() public method

public GetTimeSpan ( int column ) : System.TimeSpan
column int
return System.TimeSpan
    public TimeSpan GetTimeSpan(int column)
    {
      IMySqlValue val = GetFieldValue(column, true);

      MySqlTimeSpan ts = (MySqlTimeSpan)val;
      return ts.Value;
    }

Same methods

MySqlDataReader::GetTimeSpan ( string column ) : System.TimeSpan

Usage Example

Ejemplo n.º 1
0
        public ArrayList getTrips()
        {
            MySql.Data.MySqlClient.MySqlConnection conn;
            string myConnectionString = ConfigurationManager.ConnectionStrings["PhpMySqlRemoteDB"].ConnectionString;

            conn = new MySql.Data.MySqlClient.MySqlConnection();
            try
            {
                conn.ConnectionString = myConnectionString;
                conn.Open();

                ArrayList tripArray = new ArrayList();

                MySql.Data.MySqlClient.MySqlDataReader mySQLReader = null;

                string sqlString = "SELECT * FROM Trips";
                MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);

                mySQLReader = cmd.ExecuteReader();
                while (mySQLReader.Read())
                {
                    Trip t = new Trip();

                    t.TripID                       = mySQLReader.GetInt32(0);
                    t.Username                     = mySQLReader.GetString(1);
                    t.From_City_Country            = mySQLReader.GetString(2);
                    t.To_City_Country              = mySQLReader.GetString(3);
                    t.TransportationType           = mySQLReader.GetString(4);
                    t.OutboundTripDetails_Day      = mySQLReader.GetDateTime(5);
                    t.OutboundTripDetails_Time     = mySQLReader.GetTimeSpan(6);
                    t.OutboundTripDetails_Duration = mySQLReader.GetFloat(7);
                    t.AddAReturnTrip               = mySQLReader.GetBoolean(8);
                    t.ReturnTripDetails_Day        = mySQLReader.GetDateTime(9);
                    t.ReturnTripDetails_Time       = mySQLReader.GetTimeSpan(10);
                    t.ReturnTripDetails_Duration   = mySQLReader.GetFloat(11);
                    t.AvailableWeight              = mySQLReader.GetFloat(12);
                    t.ExcludedCategories           = mySQLReader.GetString(13);
                    t.TripNote                     = mySQLReader.GetString(14);

                    tripArray.Add(t);
                }
                return(tripArray);
            }
            catch (MySql.Data.MySqlClient.MySqlException ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
        }
All Usage Examples Of MySql.Data.MySqlClient.MySqlDataReader::GetTimeSpan