how to bind object in asp.net to control after several listbox and dropdownlist

Question

4.00/5 (1 vote)

See more:

Hi everyone,

I designed some dropdownlist and some listbox, in fact:

one dropdownlist modality

one listbox multiselect Region

one listbox multiselect CesType

And I need to compare both selected Value and get value in the 3rd dropdownlist (or it can be a listbox)CesName.

here is the code that I used BindCesName.

protected void bindCesName()
    {
        string sql = null;
        string region = "'";
        foreach (ListItem ligne in lstbxRegion.Items)
        {
            if (ligne.Selected)
            {
                region = region + ligne.Value + "','";
            }
        }

        string CesType = "'";
        foreach (ListItem ligne in lstbxCesType.Items)
        {
            if (ligne.Selected)
            {
                CesType = CesType + ligne.Value + "','";
            }
        }

        #region CES of selected Main Modality

        if (ddlModality.SelectedIndex > 0)
        {
            if ((lstbxRegion.SelectedIndex > 0) && (lstbxCesType.SelectedIndex > 0))
            {
                sql = "select distinct cesName.cesName, cesName.ID from cesname left join ces on cesname.Id = ces.cesName_ID left join bigmodality on ces.BigModality_ID = bigmodality.Id where ces.ID>0 and bigmodality.Modality_Name='" + ddlModality.SelectedItem.Text + "' and ces.Region_ID in(" + region + "0') and ces.cesType in ("+ CesType +" 0')order by cesname asc";
            }
            else if ((lstbxRegion.SelectedIndex == 0) && (lstbxCesType.SelectedIndex > 0))
            {
                sql = "select distinct cesName.cesName, cesName.ID from cesname left join ces on cesname.Id = ces.cesName_ID left join bigmodality on ces.BigModality_ID = bigmodality.Id where ces.ID>0 and bigmodality.Modality_Name='" + ddlModality.SelectedItem.Text + "' and ces.cesType in (" + CesType + " 0')order by cesname asc";
            }
            else if ((lstbxRegion.SelectedIndex > 0) && (lstbxCesType.SelectedIndex == 0))
            {
                sql = "select distinct cesName.cesName, cesName.ID from cesname left join ces on cesname.Id = ces.cesName_ID left join bigmodality on ces.BigModality_ID = bigmodality.Id where ces.ID>0 and bigmodality.Modality_Name='" + ddlModality.SelectedItem.Text + "' and ces.Region_ID in(" + region + "0')  order by cesname asc";
            }
            else if ((lstbxRegion.SelectedIndex == 0) && (lstbxCesType.SelectedIndex == 0))
            {
                sql = "select distinct cesName.cesName, cesName.ID from cesname left join ces on cesname.Id = ces.cesName_ID left join bigmodality on ces.BigModality_ID = bigmodality.Id where ces.ID>0 and bigmodality.Modality_Name='" + ddlModality.SelectedItem.Text + "' order by cesname asc";
            }
        }

the question comes from the fact that after selecting values in dropdownlist modality, listbox multiselect Region and listbox multiselect CesType, there is nothing (it shows "ALL") in the dropdownlist CesName. Does it mean that my bindCesName doesn't work well?

p.s: I've made autopostback be true.

could anyone help me ?

many thanks in advance!!!

Posted 7-Sep-12 4:36am

jessicachen12

Add a Solution

Comments

Dasaradhi_r 10-Sep-12 10:40am

Is your problem resolved?

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)

Dasaradhi_r · Accepted Answer · 2012-09-07T05:50:00

Solution 1

Hi,
I went through your code and there is nothing wrong about it.
So, My answer is based on the last one liner you wrote:

You have set the auto post back true: That will be the source of the issue.

1) First of all, answer yourself Do you need a post back there?
- To me postback should be avoided.
2) You might disabled viewstate on your page and hence state of these controls is not retained across post backs. So set enable view state property to true in the aspx page in the @Page directive.

HTML

EnableViewState="true"

Just see if the above two points help you. Otherwise, please let me know.

Posted 7-Sep-12 5:50am

Dasaradhi_r

Comments

jessicachen12 10-Sep-12 11:03am

thank you so much, it is true there is a mistake about the auto postback.

jessicachen12 13-Sep-12 5:28am

Hi, how to et enable view state property to true in the aspx page in the @Page directive?

Dasaradhi_r 13-Sep-12 5:51am

As stated in the second point, In your .aspx page, In the @Page directive, at the end just put - EnableViewState="true". Let me know, if you still not able to do it.

jessicachen12 13-Sep-12 11:21am

thank you

Dasaradhi_r 13-Sep-12 11:56am

Can you accept my answer if this has helped you to solve your problem?