Assoicate a primary key with a checkbox inside a datagrid

[Mark]

Hi everyone, could someone please recommend a way to do the following.

I have a datagrid which contains a bound template column consisting of
checkbox and a string pulled from a database table.
I want to be able to associate the primary key of the database table with
the checkbox so that when someone checks a box I can iterate through all the
checkboxs and identify the associated value in the database.

Thanks in advance
Mark

[Elton W]

Hi Mark,

In order to get parimary key value in a datagrid, you can set the datagrid's
DataKeyField = "Parimary_Key_Field_Name". And loop thru datagrid items

CheckBox ck;
foreach (DataGridItem item in datagrid.Items)
{
string pk_value = datagrid.DataKeys[item.Item.ItemIndex].ToString();
ck = (CheckBox)item.FindControl("ckBoxID");
bool checked = ck.Checked;
// process
}
HTH

Elton Wang
el********@hotmail.com
"Mark" wrote:

Hi everyone, could someone please recommend a way to do the following.

I have a datagrid which contains a bound template column consisting of
checkbox and a string pulled from a database table.
I want to be able to associate the primary key of the database table with
the checkbox so that when someone checks a box I can iterate through all the
checkboxs and identify the associated value in the database.

Thanks in advance
Mark

[Mark]

Hi all, I could not find an answer to my original question from anyone so I
just did a little hack

Basically, inside the itemtemplate I created a hidden text field which I
populated with the associated primary key for each record.

When I want to check if a checkbox has been checked and retrieve the primary
key I just did the looked for this hidden field and retrieved the primary
key value that was originally stored in it. Works a treat but I can't help
feeling that there must be a better way

Cheers
Mark
"Mark" <do**@spam.me> wrote in message
news:ur*************@TK2MSFTNGP14.phx.gbl...

Hi everyone, could someone please recommend a way to do the following.

I have a datagrid which contains a bound template column consisting of
checkbox and a string pulled from a database table.
I want to be able to associate the primary key of the database table with
the checkbox so that when someone checks a box I can iterate through all the checkboxs and identify the associated value in the database.

Thanks in advance
Mark

[Mark]

Ahh, that's it :) Thanks Elton
Cheers
Mark
"Elton W" <El****@discussions.microsoft.com> wrote in message
news:EE**********************************@microsof t.com...

Hi Mark,

In order to get parimary key value in a datagrid, you can set the datagrid's DataKeyField = "Parimary_Key_Field_Name". And loop thru datagrid items

CheckBox ck;
foreach (DataGridItem item in datagrid.Items)
{
string pk_value = datagrid.DataKeys[item.Item.ItemIndex].ToString();
ck = (CheckBox)item.FindControl("ckBoxID");
bool checked = ck.Checked;
// process
}
HTH

Elton Wang
el********@hotmail.com
"Mark" wrote:

Hi everyone, could someone please recommend a way to do the following.

I have a datagrid which contains a bound template column consisting of
checkbox and a string pulled from a database table.
I want to be able to associate the primary key of the database table with the checkbox so that when someone checks a box I can iterate through all the checkboxs and identify the associated value in the database.

Thanks in advance
Mark