datagrid

[Torro]

I am left in the following predicament
I have a sql table where columns are automatically generated (ie the user can add more columns as needed)
i want to be able to display all the columns and allow the user to edit the values within
i am currently trying to use the datagrid componenet
however, the simplest way i saw of doing this, autogeneratecolumns, seems not to be working

is it true that automatically generated columns will not be editable?
can i override this?
will it be simpler to dynamically create bound columns?
will it be simpler to use a repeater or datalist?
please advise?