สอบถามเรื่องเกี่ยวกับ การดึงข้อมูลวันที่และเวลาจาก db มาแสดงใน Listview ค่ะ

        private void Loadlistname()
        {
            ListView1.Items.Clear();
            command.CommandText = "select * from Lorry_rental ";  
            command.Connection = conn;
            conn.Open();
            OdbcDataReader rs = command.ExecuteReader();
            while (rs.Read())
            {
                ListViewItem mylist = new ListViewItem();
                mylist.Text = (rs.GetString(0));
                mylist.SubItems.Add(rs.GetString(1));
                mylist.SubItems.Add(rs.GetString(2));
                mylist.SubItems.Add(rs.GetString(4));
                mylist.SubItems.Add(rs.GetString(6));
                mylist.SubItems.Add(rs.GetString(8));
                mylist.SubItems.Add(rs.GetString(12));
                mylist.SubItems.Add(rs.GetString(10));
                mylist.SubItems.Add(rs.GetString(13));
                ListView1.Items.Add(mylist);
            }
            rs.Close();
            conn.Close();
        }

int HH1 = int.Parse(ComboBox1.Text.Substring(0, 2));
            int MM1 = int.Parse(ComboBox1.Text.Substring(3, 2));
            int HH2 = int.Parse(ComboBox2.Text.Substring(0, 2));
            int MM2 = int.Parse(ComboBox2.Text.Substring(3, 2));
            System.DateTime fromDate = new DateTime(DateTimePicker1.Value.Year, DateTimePicker1.Value.Month, DateTimePicker1.Value.Day, HH1, MM1, 0);
            System.DateTime toDate = new DateTime(DateTimePicker2.Value.Year, DateTimePicker2.Value.Month, DateTimePicker2.Value.Day, HH2, MM2, 0);

            if (textBox7.Text == "" || comboBox10.Text == "" || comboBox9.Text == "" || textBox12.Text == "" || comboBox11.Text == "" || textBox10.Text == "" || textBox11.Text == "" || textBox2.Text == "" || textBox6.Text == "" || textBox5.Text == "" || comboBox8.Text == "" || comboBox12.Text == "" || textBox4.Text == "" || textBox3.Text == "" || textBox9.Text == "" || textBox8.Text == "" || comboBox10.Text == "กรุณาเลือกสถานะ" || comboBox8.Text == "กรุณาเลือก" || comboBox12.Text == "กรุณาเลือก")
            {
                MessageBox.Show("กรุณาป้อนข้อมูลรายละเอียดให้ครบ");
            }
            else
            {
                command.CommandText = "insert into Lorry_rental values('" + textBox7.Text + "','" + comboBox10.Text + "','" + textBox6.Text + "','" + textBox5.Text + "','" + comboBox9.Text + "','" + textBox12.Text + "','" + Convert.ToDateTime(DateTimePicker1.Text).ToShortDateString() + "','" + ComboBox1.Text + "','" + Convert.ToDateTime(DateTimePicker2.Text).ToShortDateString() + "','" + ComboBox2.Text + "','" + comboBox11.Text + "','" + textBox10.Text + "','" + textBox11.Text + "','" + textBox2.Text + "','" + textBox4.Text + "','" + textBox3.Text + "','" + comboBox8.Text + "','" + comboBox12.Text + "','" + textBox9.Text + "','" + textBox8.Text + "')";
                command.Connection = conn;
                conn.Open();
                command.ExecuteNonQuery();
                conn.Close();

                MessageBox.Show("บันทึกเรียบร้อยแล้ว");

                ReserveTime objReserve = new ReserveTime();
                objReserve.rental_id = this.textBox7.Text;
                objReserve.status_rentalorder = this.comboBox10.Text;
                objReserve.Customer_id = this.textBox6.Text;
                objReserve.ReserveDataId = this.comboBox9.Text;
                objReserve.StartTime = fromDate;
                objReserve.ToTime = toDate;
                objReserve.amount_service = this.textBox11.Text;
                objReserve.type_work = this.comboBox11.Text;
                objReserve.mony_rental = this.textBox2.Text;

                this.reserveList.Add(objReserve);
                ListViewItem lvItem = new ListViewItem(objReserve.rental_id);
                lvItem.SubItems.Add(objReserve.status_rentalorder);
                lvItem.SubItems.Add(objReserve.Customer_id);
                lvItem.SubItems.Add(objReserve.ReserveDataId);
                lvItem.SubItems.Add(objReserve.StartTime.ToString("d/MM/yyyy"));
                lvItem.SubItems.Add(objReserve.ToTime.ToString("d/MM/yyyy"));
                lvItem.SubItems.Add(objReserve.amount_service);
                lvItem.SubItems.Add(objReserve.type_work);
                lvItem.SubItems.Add(objReserve.mony_rental);
                this.ListView1.Items.Add(lvItem);

                this.DateTimePicker1_ValueChanged(null, null);
                this.DateTimePicker2_ValueChanged(null, null);
                reset();
                Autonum();