Problem sorting a Datagrid with Checkbox columns (checkboxes not following sort)

[Scott]

I am trying to sort a datagrid which contains 5 checkbox columns. All
other columns sort properly except these 5 checkbox columns which dont
sort at all.

I am using ASP.NET 1.1 and this code is located in a user control.

The code snippet for binding the checkbox control is as follows and is
found in the ItemDataBound event for the datagrid. It appears that
the index value never changes...it always seems to reference the
orginal dataset index.

Any help would be greatly appreciated.

try
{
System.Web.UI.W ebControls.Imag e img1 =
(System.Web.UI. WebControls.Ima ge)e.Item.Cells[7].Controls[1];
int iIndx = e.Item.DataSetI ndex;
/*
0 Disabled
1 Approved
2 Waiting For Approval
3 Rejected
4 Locked
*/
int iResultSR = dsListBuilders. Tables["bb_saved_build ers"].Rows[iIndx]
["sales_rep_appr oved"].ToString() == string.Empty?
2:int.Parse(dsL istBuilders.Tab les["bb_saved_build ers"].Rows[iIndx]
["sales_rep_appr oved"].ToString());

switch(iResultS R)
{
case 0:
img1.ImageUrl=" ../../images/greybox.gif";
break;
case 1:
img1.ImageUrl=" ../../images/checkboxyes.gif ";
break;
case 2:
img1.ImageUrl=" ../../images/checkboxno.gif" ;
break;
case 3:
img1.ImageUrl=" ../../images/redcheckboxno.g if";
break;
case 4:
img1.ImageUrl=" ../../images/lock.gif";
break;
default:
img1.ImageUrl=" ../../images/checkboxno.gif" ;
break;
}
}
catch(Exception exBinding1)
{
//ignore...
}

[=?Utf-8?B?U2VyZ2V5IFBvYmVyZXpvdnNraXk=?=]

Scott,

Instead of locating the data in the original table
dsListBuilders. Tables["bb_saved_build ers"].Rows[iIndx]
use the grid source data:
DataRow row = (e.Item.ItemDat a is DataRow) ? e.Item.ItemData as DataRow :
(e.Item.ItemDat a as DataRowView).Ro w;
int iResultSR = (row["sales_rep_appr oved"].ToString() ==
string.Empty)?2 :int.Parse(row["sales_rep_appr oved"].ToString());

"Scott" wrote:

I am trying to sort a datagrid which contains 5 checkbox columns. All
other columns sort properly except these 5 checkbox columns which dont
sort at all.

I am using ASP.NET 1.1 and this code is located in a user control.

The code snippet for binding the checkbox control is as follows and is
found in the ItemDataBound event for the datagrid. It appears that
the index value never changes...it always seems to reference the
orginal dataset index.

Any help would be greatly appreciated.

try
{
System.Web.UI.W ebControls.Imag e img1 =
(System.Web.UI. WebControls.Ima ge)e.Item.Cells[7].Controls[1];
int iIndx = e.Item.DataSetI ndex;
/*
0 Disabled
1 Approved
2 Waiting For Approval
3 Rejected
4 Locked
*/
int iResultSR = dsListBuilders. Tables["bb_saved_build ers"].Rows[iIndx]
["sales_rep_appr oved"].ToString() == string.Empty?
2:int.Parse(dsL istBuilders.Tab les["bb_saved_build ers"].Rows[iIndx]
["sales_rep_appr oved"].ToString());

switch(iResultS R)
{
case 0:
img1.ImageUrl=" ../../images/greybox.gif";
break;
case 1:
img1.ImageUrl=" ../../images/checkboxyes.gif ";
break;
case 2:
img1.ImageUrl=" ../../images/checkboxno.gif" ;
break;
case 3:
img1.ImageUrl=" ../../images/redcheckboxno.g if";
break;
case 4:
img1.ImageUrl=" ../../images/lock.gif";
break;
default:
img1.ImageUrl=" ../../images/checkboxno.gif" ;
break;
}
}
catch(Exception exBinding1)
{
//ignore...
}

[Scott]

On Aug 8, 10:26 pm, Sergey Poberezovskiy
<SergeyPoberezo vs...@discussio ns.microsoft.co mwrote:

Scott,

Instead of locating the data in the original table
dsListBuilders. Tables["bb_saved_build ers"].Rows[iIndx]
use the grid source data:
DataRow row = (e.Item.ItemDat a is DataRow) ? e.Item.ItemData as DataRow :
(e.Item.ItemDat a as DataRowView).Ro w;
int iResultSR = (row["sales_rep_appr oved"].ToString() ==
string.Empty)?2 :int.Parse(row["sales_rep_appr oved"].ToString());

"Scott" wrote:

I am trying to sort a datagrid which contains 5 checkbox columns. All
other columns sort properly except these 5 checkbox columns which dont
sort at all.

I am using ASP.NET 1.1 and this code is located in a user control.

The code snippet for binding the checkbox control is as follows and is
found in the ItemDataBound event for the datagrid. It appears that
the index value never changes...it always seems to reference the
orginal dataset index.

Any help would be greatly appreciated.

try
{
System.Web.UI.W ebControls.Imag e img1 =
(System.Web.UI. WebControls.Ima ge)e.Item.Cells[7].Controls[1];
int iIndx = e.Item.DataSetI ndex;
/*
0 Disabled
1 Approved
2 Waiting For Approval
3 Rejected
4 Locked
*/
int iResultSR = dsListBuilders. Tables["bb_saved_build ers"].Rows[iIndx]
["sales_rep_appr oved"].ToString() == string.Empty?
2:int.Parse(dsL istBuilders.Tab les["bb_saved_build ers"].Rows[iIndx]
["sales_rep_appr oved"].ToString());

switch(iResultS R)
{
case 0:
img1.ImageUrl=" ../../images/greybox.gif";
break;
case 1:
img1.ImageUrl=" ../../images/checkboxyes.gif ";
break;
case 2:
img1.ImageUrl=" ../../images/checkboxno.gif" ;
break;
case 3:
img1.ImageUrl=" ../../images/redcheckboxno.g if";
break;
case 4:
img1.ImageUrl=" ../../images/lock.gif";
break;
default:
img1.ImageUrl=" ../../images/checkboxno.gif" ;
break;
}
}
catch(Exception exBinding1)
{
//ignore...
}- Hide quoted text -

- Show quoted text -

Thanks Sergey, after I realized that the line should read
e.Item.DataItem ...everything works great!!!

Thanks alot...You have been a great help!!!!! :)