public extras load_extras(int booking_ref) { sql = "SELECT * FROM extras WHERE booking_ref='" + booking_ref + "';"; cmd.CommandText = sql; sdr = cmd.ExecuteReader(); extras extra = new extras(); while (sdr.Read()) { if (booking_ref == Int32.Parse(sdr.GetString(7))) { extra.Ref = Int32.Parse(sdr.GetString(0)); extra.Breakfast_price = Double.Parse(sdr.GetString(1)); extra.Breakfast_num = Int32.Parse(sdr.GetString(2)); extra.Evening_meal_price = Double.Parse(sdr.GetString(3)); extra.Evening_meal_num = Int32.Parse(sdr.GetString(4)); extra.Car_hire_price = Double.Parse(sdr.GetString(5)); extra.Car_hire_start = sdr.GetString(6); extra.Car_hire_end = sdr.GetString(7); extra.Car_hire_name = sdr.GetString(8); extra.BookingRef = Int32.Parse(sdr.GetString(9)); } } sdr.Close(); return(extra); Extras extraWin = new Extras(); extraWin.Show(); //extraWin.txtBox_extras_ref.Text = extra.Ref.ToString(); extraWin.txtBox_booking_ref.Text = booking_ref.ToString(); extraWin.txtBox_breakfast.Text = extra.Breakfast_num.ToString(); extraWin.txtBox_evening_meal.Text = extra.Evening_meal_num.ToString(); extraWin.datepicker_start.Text = extra.Car_hire_start; extraWin.datepicker_end.Text = extra.Car_hire_end; extraWin.txtBox_car_hire_name.Text = extra.Car_hire_name; if (extraWin.datepicker_start.Text == "0001-01-01") { extraWin.datepicker_start.Text = ""; } if (extraWin.datepicker_end.Text == "0001-01-01") { extraWin.datepicker_end.Text = ""; } }