Database problem - ListView or DataView [Resolved]

[arsmakman]

Hello all,

I am currently working on project that is a database-driven mp3-player. So, there is a database file with the songs (and a lot of info on them), connected to a player. The database is a DataSet control.

Now, to show this information to the user, most logically either a ListView or DataGrid control can be used. There only seem to be problems with both of them:

The ListView:
- It will not let you edit information in columns other that the first.
- It's not very hard to create a custom way to change the text in the subitems (e.g. by putting a textbox above the subitem). But, there is no property of the ListView that tells you which subitem is selected.

The DataGrid:
- It will let you add new lines easily, which should not happen (they should be added, by adding files with an OpenFileDialog or FolderBrowserDialog).
- It will not let you rearrange columns.
- Data can not be different from database info (e.g. filesize will be in bytes in the database, but should be in KB in view)

Does anybody know a solution for the problems with one of these controls?
Or is there a different control that will allow you to do these things?

Thanks in advance,
Alex.