Populate a Listview (with columns) from SQL Server 2005 using .Net Framework and VS 2005.

Question

Hi, What is the best to do this? I have read around a bit and it seems to be SQL Server -> Dataset -> Listview. Is there any way to do the Dataset -> Listview automatic? Like put this database table in that listview column? (In .Net 2.0 and VS 2005). Or do I have to iterate through the dataset? If a table is updates is it possible to have the SQL server raise an event and update the listView? Thank you in advance!