WHILE EN ROUTE, THE PLT ENCTRD HEADWINDS, BUT HE THOUGHT HE HAD SUFFICIENT FUEL FOR THE FLT. HOWEVER, DURING A VOR APCH TO LAND AT NIGHT, HE ENCTRD LOW CLOUDS & WAS UNABLE TO SEE THE AIRPORT AT THE MISSED APCH POINT (MAP). HE EXECUTED A MISSED APCH & CONTACTED MINNEAPOLIS CENTER 'FOR ALTERNATE AIRPORT WITH ILS OR KNOWN VFR CONDITIONS DUE TO FUEL CONCERN.' VECTORS WERE PROVIDED, BUT HIS FUEL WAS EXHAUSTED BEFORE REACHING A SUITABLE AIRPORT. SUBSEQUENTLY, AN EMERGENCY LANDING WAS MADE IN A CATTLE FEED LOT. BEFORE STOPPING, THE ACFT HIT A FEED TROUGH & WAS DAMAGED.