MySQL DataReader - Checkboxlist Data Retrieve

Kavi suja

HI,
I have checkboxlist in aspx page.It fills from database while run application.I use Edit link button.Now i use MySQL reader to read data from database.

txtPFirstName.Text = dr[3].ToString();

txtPMiddleName.Text = dr[4].ToString();

txtPLastName.Text = dr[5].ToString();

CheckBoxList2.SelectedValue = dr[29].ToString();

For textbox it reads the data correctly.But in checkboxlist the data is not retrieved from database.How I retrieve data from database in to Dropdownlist?Can anyone help me to do this?

11 Replies

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

Sanjeeb Lenka13y ago
Accepted answer
Try like this it may help you:

string[] Branches = dr[29].ToString().Split(',');
                            foreach (ListItem li in CheckBoxList2.Items)
                            {
                                if (Branches.Contains(li.Value))
                                    li.Selected = true;
                            }
Sanjeeb Lenka13y ago
you are welcome kavi..
Kavi suja13y ago
Hi,
Iftikar,Sanjeeb thank you for your replies.It's works for me.
Iftikar Hussain13y ago
try like this

string value = "1,2,4";
string[] dataArray = value.Split(',');
foreach (var data in dataArray)
{
for (int i = 0; i < CheckBoxList2.Items.Count; i++)
{
if (CheckBoxList2.Items[i].Value == data)
{
CheckBoxList2.Items[i].Selected=true;
}
}
}

Regards,
Iftikar
Kavi suja13y ago
Hi,
I'm getting check box list value as comma separated string.
Sanjeeb Lenka13y ago
are you getting the check box list value as comma separated string, or single one from database
Iftikar Hussain13y ago
(string)checkedListBox1.Items[i] will contain the value which you bind it and the value is the database value which was saved earlier

Regards,
Iftikar
Kavi suja13y ago
HI,
if ((string)checkedListBox1.Items[i] == value) here 'string' and 'value' represents what?
Iftikar Hussain13y ago
You need to loop thru all list item of checkbox list and set keep selected

for (int i = 0; i < checkedListBox1.Items.Count; i++)
{
if ((string)checkedListBox1.Items[i] == value)
{
checkedListBox1.SetItemChecked(i, true);
}
}

Regards,
Iftikar
Kavi suja13y ago
Hi Iftikar,
I attach the code here.
CssClass="CheckboxList" Width="100%" RepeatDirection="Horizontal" BorderColor="#3399FF">

CheckBoxList2.DataSource = objRegLogic.GetSPList("SP_Allergy");
CheckBoxList2.DataTextField = "name";
CheckBoxList2.DataValueField = "pkey";
CheckBoxList2.DataBind();
Iftikar Hussain13y ago
Hi,
You need to first bind the data to your checkbox list. Can you share your aspx code?

Regards,
Iftikar