C#

lblStartTime.Text = Convert.ToDateTime(sql_reader["start_time"]).ToString("HH:mm");

lblStartTime.Text = sql_reader["start_time"].ToString("HH:mm");

CREATE TABLE `job_orders` (
  `job_order_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `cleaner_id` int(11) DEFAULT NULL,
  `job_order_status` int(255) DEFAULT '1' COMMENT 'New, Cancelled, Completed, Payment',
  `is_cancelled` bit(1) DEFAULT b'0',
  `job_order_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `job_order_note` text,
  `created_date` datetime DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`job_order_id`),
  UNIQUE KEY `idx_job_orders_job_order_id` (`job_order_id`),
  KEY `idx_job_orders_customer_id` (`customer_id`),
  KEY `idx_job_orders_cleaner_id` (`cleaner_id`),
  KEY `idx_job_orders_job_order_status` (`job_order_status`),
  KEY `idx_job_orders_is_cancelled` (`is_cancelled`),
  KEY `idx_job_orders_job_order_date` (`job_order_date`),
  KEY `idx_job_orders_start_time` (`start_time`),
  KEY `idx_job_orders_end_time` (`end_time`),
  KEY `idx_job_orders_created_date` (`created_date`),
  KEY `idx_job_orders_created_user` (`created_user`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

Jassim Rahma wrote:

Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.

lblStartTime.Text = ((TimeSpan)sql_reader["start_time"]).ToString("hh\\:mm");

private static string FormatTime(TimeSpan time)
{
    return string.Format("{0:##00}.{1:00}", time.TotalHours, time.Minutes);
}

lblStartTime.Text = FormatTime((TimeSpan)sql_reader["start_time"]);

• http://en.wikipedia.org/wiki/Factory_method_pattern[^]
• http://en.wikipedia.org/wiki/Singleton_pattern[^]
• http://en.wikipedia.org/wiki/Chain_of_responsibility_pattern[^]

Quote: amazon.com - Design Patterns: Elements of Reusable Object-Oriented Software [^]

Capturing a wealth of experience about the design of object-oriented software, four top-notch designers present a catalog of simple and succinct solutions to commonly occurring design problems.

Sahyadri31 wrote:

Winners don't do different thing they do things differently.