writeable checkbox in datagrid from bit field in table

[hazz]

I am having a very difficult time with what should be an easy task.

I simply want to select these fields from the database table into the
GridView control and have checkboxes appear for which the user can select
which columns to include in a report.
The checkboxes are always read only, even when I set the value for readonly
to false in the BoundField GridView tasks (EditColumn).
Does anyone know of an example I can see, an article or just another way of
looking at what I may be missing here?
I can update the table in the database so I must have permissions to change
the table, at least from sql management studio. Maybe I need permissions
from within the website. Maybe thats why when I go into the wizard and
choose the advance option to create an UPDATE/INSERT query, it doesn't allow
me to check that box. Thanks, -Greg

SELECT COLUMN_NAME as [Data Item Name],

Column_ID as [Column Id],

Include_in_Report as [Include in Report] -- a bit data value

FROM ColumnsToSelect

 

[Guest]

Your checkbox will remain read only while your gridview is in readonly mode.
If you flip it into edit mode then it will become editable, although in order
for the cahnge to be written back to the DB you need to specify some kind of
insert command to the bound datasource.

 

[hazz]

I'm looking into this. Thank you.

Your checkbox will remain read only while your gridview is in readonly
mode.
If you flip it into edit mode then it will become editable, although in
order
for the cahnge to be written back to the DB you need to specify some kind
of
insert command to the bound datasource.

I am having a very difficult time with what should be an easy task.

I simply want to select these fields from the database table into the
GridView control and have checkboxes appear for which the user can select
which columns to include in a report.
The checkboxes are always read only, even when I set the value for
readonly
to false in the BoundField GridView tasks (EditColumn).
Does anyone know of an example I can see, an article or just another way
of
looking at what I may be missing here?
I can update the table in the database so I must have permissions to
change
the table, at least from sql management studio. Maybe I need permissions
from within the website. Maybe thats why when I go into the wizard and
choose the advance option to create an UPDATE/INSERT query, it doesn't
allow
me to check that box. Thanks, -Greg

SELECT COLUMN_NAME as [Data Item Name],

Column_ID as [Column Id],

Include_in_Report as [Include in Report] -- a bit data value

FROM ColumnsToSelect

 

[hazz]

Oh my gosh....the table I was using for the update didn't have an identity
column. Visual Studio is not going to let someone update a table it can't
update. Wheww!!! Bonehead me !!

Your checkbox will remain read only while your gridview is in readonly
mode.
If you flip it into edit mode then it will become editable, although in
order
for the cahnge to be written back to the DB you need to specify some kind
of
insert command to the bound datasource.

I am having a very difficult time with what should be an easy task.

I simply want to select these fields from the database table into the
GridView control and have checkboxes appear for which the user can select
which columns to include in a report.
The checkboxes are always read only, even when I set the value for
readonly
to false in the BoundField GridView tasks (EditColumn).
Does anyone know of an example I can see, an article or just another way
of
looking at what I may be missing here?
I can update the table in the database so I must have permissions to
change
the table, at least from sql management studio. Maybe I need permissions
from within the website. Maybe thats why when I go into the wizard and
choose the advance option to create an UPDATE/INSERT query, it doesn't
allow
me to check that box. Thanks, -Greg

SELECT COLUMN_NAME as [Data Item Name],

Column_ID as [Column Id],

Include_in_Report as [Include in Report] -- a bit data value

FROM ColumnsToSelect

 

[hazz]

but how do I get the checkbox value to stick?
After I select it, it gets checked.
But when I move onto the next row, it reverts back to an empty box.
hmmm.

Your checkbox will remain read only while your gridview is in readonly
mode.
If you flip it into edit mode then it will become editable, although in
order
for the cahnge to be written back to the DB you need to specify some kind
of
insert command to the bound datasource.

I am having a very difficult time with what should be an easy task.

I simply want to select these fields from the database table into the
GridView control and have checkboxes appear for which the user can select
which columns to include in a report.
The checkboxes are always read only, even when I set the value for
readonly
to false in the BoundField GridView tasks (EditColumn).
Does anyone know of an example I can see, an article or just another way
of
looking at what I may be missing here?
I can update the table in the database so I must have permissions to
change
the table, at least from sql management studio. Maybe I need permissions
from within the website. Maybe thats why when I go into the wizard and
choose the advance option to create an UPDATE/INSERT query, it doesn't
allow
me to check that box. Thanks, -Greg

SELECT COLUMN_NAME as [Data Item Name],

Column_ID as [Column Id],

Include_in_Report as [Include in Report] -- a bit data value

FROM ColumnsToSelect