The pilot/owner of the aircraft indicated that he had the aircraft refueled prior to departure from Sarasota. He questioned the line person, who did the refueling, but did not visually check the quantity prior to departure. The pilot stated that he was aware that the fuel quantity gauges were inaccurate, so he always flew by elapsed time. Approaching Charlotte, NC from the south, he contacted approach control and indicated that he would land at Rock Hill, SC. After some apparent consideration, he changed his destination to Charlotte, which was only about 14 miles away. He was being radar vectored for a landing on runway 18L at Charlotte, when the engine lost power. The pilot radioed that he had run out of fuel and was looking for a place to land. The airplane touched down on a small lake, became airborne, and collided with trees at the edge of the lake. No evidence of fuel was found at the site.