Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Re: CheckBox in a DataGrid and a datatable field

Thread Tools

Re: CheckBox in a DataGrid and a datatable field

Just D
Posts: n/a
Hi Calvin,

Thanks for your answer. Yes, I'm able to get the CheckBox status in every
cell. You can take a look, it was very helpful to write my own code based on
this example:;EN-US;320707

But the problem was - I can't get the event when this click happened to
create a SQL command and send to the database automatically, without "Apply"
button as was used in this example. That's a problem for me.

ItemCreated... It's really not like ItemCreated, I just change the status of
the CheckBox control in the cells, I can get all cells with these changes
using foreach like in the example above, but to catch this moment when I
should do that, it's a real problem.

Probably I could use Select/Edit/Cancel ot whatever, it has its own event
that I can catch, but the customer wants to get a CheckBox only.

Just D.
"Calvin Luttrell/" <(E-Mail Removed)> wrote in
message news:%(E-Mail Removed)...
Just D,

I think I would look in to the ItemCreated even on the datagrid. You
should be able to access the controls property from each cell. Very creative
solution BTW. Did you think about just making a background process to reset
these values?

-Calvin Luttrell

> Does anybody know how to write the following code?
> I have a database table with a few columns including: ID [int], "Task"
> [varchar], ForceRun [bit]. I need to show the DataGrid on the ASPX page

> these selected fields and allow user to click one or more CheckBox

> to activate this bit on the database table for a required ID.
> I have already added a template column to the DataGrid and I can get the
> CheckBox status from this CheckBox for each string. If I click a button
> "Apply" on this page I can get a full list of changed items and send a

> command to the database to activate these bits. It works, but...
> The customer wants this aspx page to be updated automatically, once per
> selected time, for example one time per 10 seconds. I think that I have

> two possible ways to do that.
> 1. I need to read the status of these CheckBox controls from the

> and create a SQL string to send to the database immediately after

> just after the user clicked this control.
> 2. Wait for the auto refresh and work with the whole DataGrid before the
> page is updated. I have this functions but I don't know how to call it
> before updating of the page.
> I used this tag to reload the page automatically. It works fine.
> <meta http-equiv="refresh" content="10">
> But it causes a full reload of the page including the datagrid and I

> get the CheckBox status on Page_Load() because the DataGrid resets every
> time on Page_Load(). I think that I need some event to check the status

> these CheckBox controls in the DataGrid before content reloading. But

> If I go the first way, what event should I use to understand that the

> clicked the CheckBox to work with these changes after the changes have

> done before page refreshing?

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort a datatable and create a new datatable Fredrik Rodin ASP .Net 3 09-28-2007 07:28 AM
DataGrid and embeded Checkbox..How to find if checkbox clicked =?Utf-8?B?RG90TmV0RGV2?= ASP .Net 1 10-06-2006 04:11 PM
1.Enter space bar for field names and save the field.The field shoud not get saved and an alert should be there as"Space bars are not allowed" Sound Javascript 2 09-28-2006 02:43 PM
Howto bind CheckBox to the datagrid/ Then update the database field when the checkbox is clicked. Joey Pang ASP .Net Datagrid Control 4 06-13-2005 02:29 AM
CheckBox in a DataGrid and a datatable field Just D ASP .Net 0 05-24-2004 05:01 AM