listitem not showing all values

ToBe

Hi

I have and Edit form contain a checkboxlist and when I'm trying to check the selected values from my databse it goes will in the loop but it will always show the first item in the Checkboxlist even if the saved values is morethan that .

this is my code :

string sqlstr4 = "SELECT REG.ID, CETYPE.Type FROM tblReges INNER JOIN tblGE ON tblReges.ID = CETYPE.ID where ID = tblReges.ID";

SqlCommand cmd4 = new SqlCommand(sqlstr4, con);

cmd4.CommandType = CommandType.Text;

cmd4.CommandTimeout = 15;

SqlDataAdapter ad = new SqlDataAdapter(cmd);

DataSet DS = new System.Data.DataSet(cmd.CommandText);

ad.Fill(DS);

if (DS.Tables[0].Rows.Count > 0)

{

foreach (ListItem litem in CheckBoxList.Items)

{

if (litem.Text == DS.Tables[0].Rows[0].ItemArray[1].ToString())

{

litem.Selected = true;

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
My suspicion is that it's not matching properly - perhaps because of differences in capitalization or leading/trailing whitespace.

See if it's any better if you do this:

string temp = DS.Tables[0].Rows[0].ItemArray[1].ToString().Trim().ToLower();
if (litem.Text.Trim().ToLower() == temp)
{
litem.Selected = true;
}
0
ToBe13y ago
thank you for your suggestion it's working now using the the DS.Tables[0].ROws with the trim thank you sooooo much
0
ToBe13y ago
thank you for your reply Vulpes

IU coerrected that and still I'm having the same problem :

string sqlstr4 = "SELECT REG.ID, CETYPE.Type FROM tblReges INNER JOIN tblGE ON tblReges.ID = CETYPE.ID where ID = tblReges.ID";
SqlCommand cmd4 = new SqlCommand(sqlstr4, con);
cmd4.CommandType = CommandType.Text;
cmd4.CommandTimeout = 15;

SqlDataAdapter ad = new SqlDataAdapter(cmd4);
DataSet DS = new System.Data.DataSet(cmd4.CommandText);
ad.Fill(DS);

if (DS.Tables[0].Rows.Count > 0)
{
foreach (ListItem litem in CheckBoxList.Items)
{
if (litem.Text == DS.Tables[0].Rows[0].ItemArray[1].ToString())
{
litem.Selected = true;
}

}

}
0
Vulpes13y ago
Just wondered whether you're using the correct SQL command.

You're creating a command called 'cmd4' but then using 'cmd' when creating your data adapter.
0