CheckBoxList C# Values from a SQL Server database separated by ":"

Question

I have a CheckBoxList that needs to be populated from a SQL Server database that is separated by :.

aspx page

<asp:CheckBoxList ID="chkTopics" runat="server" CssClass="ChkList">
 <asp:ListItem Value="ABC">ABC</asp:ListItem>
 <asp:ListItem Value="D-E-F">D-E-F</asp:ListItem>
 <asp:ListItem Value="GHI">GHI</asp:ListItem>
 <asp:ListItem Value="J,K,L">J,K,L</asp:ListItem>
 <asp:ListItem Value="MNO">MNO</asp:ListItem>
 <asp:ListItem Value="PQR">PQR</asp:ListItem>
</asp:CheckBoxList>

.cs page on what how I am getting the values:

SqlConnection conn = null;
conn = new SqlConnection(conn_string);

SqlCommand sqlCommand = new SqlCommand("aspnet_GetAnswers", conn);
sqlCommand.CommandType = CommandType.StoredProcedure;

conn.Open();

SqlDataReader rdr = sqlCommand.ExecuteReader();

if (rdr.Read())
{
  FirstName.Text = rdr.GetValue(2).ToString();
  LastName.Text = rdr.GetValue(3).ToString();
 --> Putting the Code here to read the values and check the values that match.
}

rdr.Close();
conn.Close();
conn.Dispose();

From the Database:

rdr.GetValue(9).ToString();

ABC:GHI:J,K,L:

So, what problem are you having? Are you saying that you don't know how to "split" a "string"? That's a hint. — John Saunders
– John Saunders, Commented Jan 16, 2014 at 16:25

Grant Winney · Accepted Answer · 2014-01-16 16:32:27Z

1

You can do a string.Split() on the colon, then create each LineItem and add them directly to the CheckBoxList:

var result = rdr.GetValue(9).ToString();
chkTopics.Items.AddRange(result.Split(':')
                               .Select(x => new ListItem { Text = x, Value = x})
                               .ToArray());

If there's a chance you'll have extra colons that would result in empty items, you can remove them using the StringSplitOptions.RemoveEmptyEntries option:

.Split(new[] { ':' }, StringSplitOptions.RemoveEmptyEntries

edited Jan 16, 2014 at 16:32

answered Jan 16, 2014 at 16:24

Grant Winney

66.6k13 gold badges120 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mrmcg Over a year ago

Checked this one out and it does not select anything.

nestedloop · Accepted Answer · 2014-01-16 16:38:55Z

1

Trim the last colon:

string trimmedString = optionsStringFromDb.TrimEnd(':');

Get options list:

List<string> myOptions = trimmedString.Split(':').ToList();

Then populate your CheckBoxList:

foreach (string option in myOptions)
{
   chkTopics.Items.Add(new ListItem(option));
}

edited Jan 16, 2014 at 16:38

answered Jan 16, 2014 at 16:23

nestedloop

2,67624 silver badges35 bronze badges

2 Comments

nestedloop Over a year ago

@mrmcg What do you mean by "doesnt seem to flow" ? You will have to be more specific.

nestedloop Over a year ago

@mrmcg Is it better now? 'optionsStringFromDb is just a generic name (replace by whatever string you hold your query result)

Irfan TahirKheli · Accepted Answer · 2014-01-16 16:34:48Z

0

Like This

 string str = GetValue(9).ToString().TrimEnd(':');
 string[] strList = str.Split(':');


 foreach (string s in strList)
        {
            foreach (ListItem item in chkTopics.Items)
            {
                if (item.Value == s)
                {
                    item.Selected = true;
                    break;
                }

            }

        }

edited Jan 16, 2014 at 16:34

answered Jan 16, 2014 at 16:24

Irfan TahirKheli

3,6621 gold badge26 silver badges36 bronze badges

1 Comment

mrmcg Over a year ago

But the other ones are not showing up. The ones in the Database needs to be Selected.

Collectives™ on Stack Overflow

CheckBoxList C# Values from a SQL Server database separated by ":"

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related