hi all!!

what i need to do is to fill a gridview With a query and just let one column
to edit and when i click a button update all values in that column to the database...
ex:

table Answers:
ID(Int)
Question(Nvarchar(50)
Answer(Bit)
fill the gridview

Select Question , Answer FROM Answers

Ok now i need to edit all rows in the column Answer and if possible with enum

answer = 0 Enum = Yes
answer = 1 Enum = No
answer = DbNull Enum = Not applicable or N/A

anny ideas in how to do this??
instead row to row?

Thanks in advance