If you want to play a Haruhi game, you've got a lot of different makers putting out a lot of different games. Namco Bandai has the ultra-popular PSP and PS2 title rights, while Kadokawa Shoten holds the Wii game rights. So now Sega has grabbed onto the license for the Nintendo DS. There's not much else to say at the moment, as the site has just opened. The game's still got the temporary title of The Melancholy of Suzumiya Haruhi -- the other games had titles like The Promise of Suzumiya Haruhi or The Agitation of Suzumiya Haruhi.
So, in the meantime, enjoy seeing the Haruhi dance again!