view and process objectdatasource's select data programmatically

Question

0.00/5 (No votes)

See more:

i have a checkboxlist populated from a datasource which contains all newspapers. a second datasource which i want to view and compare its select data, contains favorites newspapers.

i want checkboxes preselected according to newspaper ids from the second datasources. its select method returns data as ienumarable. and the values of checkboxes are strings.

how can i compare the values belong to checkboxes and the select data from the second datasource ?

i try the following solution but none of cbs is checked :

C#

protected void CheckBoxList1_DataBound(object sender, EventArgs e)
        {
            IEnumerable results = FavoritesDataSource.Select();
            foreach (var item in results)
            {
                foreach (ListItem cb in CheckBoxList1.Items)
                {
                    if (item.ToString()== cb.Value)
                    {
                        cb.Selected = true;
                    }
                }
            }

XML

cb is holding newspaper names as text and ids as value. so i want to compare ids.
this is the datasource ( favorites datasource )
 Collapse
<asp:ObjectDataSource ID="FavoritesDataSource" runat="server"
    OldValuesParameterFormatString="original_{0}"
    SelectMethod="GetfavoritesByContactId" TypeName="myapp.FavoritesBLL">
    <SelectParameters>
        <asp:QueryStringParameter Name="contactid" QueryStringField="contactid"
            Type="Int32" />
    </SelectParameters>
</asp:ObjectDataSource>
this is the checkboxlist populated with another data source (newspapers data source ). there is no problem with that, all cbs are populated.
 Collapse
<asp:CheckBoxList ID="CheckBoxList1" runat="server"
        DataSourceID="NewspaperDatasource" DataTextField="npName"
        DataValueField="newspaperid" ondatabound="CheckBoxList1_DataBound">
    </asp:CheckBoxList>
and this is the code i try to compare newspaper ids.
 Collapse
protected void CheckBoxList1_DataBound(object sender, EventArgs e)
        {
            IEnumerable results = FavoritesDataSource.Select();
            foreach (var item in results)
            {
                foreach (ListItem cb in CheckBoxList1.Items)
                {
                    if (item.ToString()== cb.Value)
                    {
                        cb.Selected = true;
                    }
                }
            }
        }
i think there's a problem with ienumerable.

Posted 5-Jan-11 4:28am

tyu

Updated 5-Jan-11 8:42am

v2

Add a Solution

Comments

Manfred Rudolf Bihy 6-Jan-11 15:59pm

What exactly does the method FavoritesDataSource.Select() return? What is kind of IEnumerable<elementtypehere> is it?
If we know what type elementTypeHere is we stand a much better chance of choosing the correct property to compare it to cb.Text.

Manfred Rudolf Bihy 6-Jan-11 16:06pm

See also the modifications I made to my answer. (added footnotes)

tyu 7-Jan-11 5:04am

return type is favoritesdatatable from the BLL. and the query in the table adapter returns only newspaper ids from the favorites table. favorites table has two columns, contactid and favorites id. so query returns favorite newspapers's id for a given contactid

Manfred Rudolf Bihy 7-Jan-11 12:35pm

OK! So one problem is, does item.ToString() give you the value from column favoritesid?
Next problem is then how to get the id from the CheckBoxes. CheckBox.Text I take it contains the name of the paper. Is that true?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Accepted Answer · 2011-01-05T04:59:00

I'm only guessing here so you'll have to try it out yourself, but it would seem that the item.ToString()^1. gives you the name of one of the favorite newspapers and in all the checkboxes the name of the newspaper
would be in the property cb.Text.

This is all guesswork as we didn't see the code yet that initialized the asp:checkbox instances and neither the code that reads in all the newspapers. I still think that cb.Text probably does the trick.

C#

protected void CheckBoxList1_DataBound(object sender, EventArgs e)
        {
            IEnumerable results = FavoritesDataSource.Select();
            foreach (var item in results)
            {
                foreach (ListItem cb in CheckBoxList1.Items)
                {
                    // Make that cb.Text instead of cb.Value
                    // what exactly is the type of item? Then you'd know
                    // what property to use to compare it to cb.Text
                    if (item.ToString() == cb.Text)
                    {
                        cb.Selected = true;
                    }
                }
            }

Footnotes:

1. If FavoritsDataSource.Select() returned a list of objects of a type you wrote yourself, chances are good the ToString() method will not return anything sensible at all but the class name of those objects.
End Footnotes

Best Regards,
Manfred