How to prevent duplication in DropDownlist in C#

Question

4.00/5 (1 vote)

See more:

0 down vote favorite

I have a web form when i click on search button DropDownList must select the text among the Dataitems available in dropdownlist but problem with my code is that it insert the duplicate Dataitem text instead of selecting original Dataitem. Following is my code

C#

sqlChk = s.callingSP("SP_SearchCase", txtOfficeSerialNO.Text.Trim());
    if (sqlChk.Tables[0].Rows.Count > 0)
    {
        divEmpMast.Style.Add("display", "block");

        lblMsg.Visible = false;

        txtSNO.Text = sqlChk.Tables[0].Rows[0]["SNo"].ToString();

        txtSending.Text = sqlChk.Tables[0].Rows[0]["DateOfSending"].ToString();
        if (string.IsNullOrEmpty(sqlChk.Tables[0].Rows[0]["FrmWhere"].ToString()))
        {
            // Write your Custom Code
            sqlChk.Tables[0].Rows[0]["FrmWhere"] = "None";
        }
        else
           ddlSubdistrict.SelectedItem.Text=sqlChk.Tables[0].Rows[0]["FrmWhere"].ToString();

Please help

Posted 7-Jan-15 0:32am

ankitsrist

Add a Solution

3 solutions

Solution 3

Hi,

You can also use a dataview for storing the table data there and then you can able to select the distinct values for the data. Please follow this link here.

Thanks
Sisir Patro

Posted 7-Jan-15 1:44am

Sisir Patro

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-01-07T01:00:00

Solution 1

You should do like this...

C#

if(ddlSubdistrict.Items.Contains(ddlSubdistrict.Items.FindByText(sqlChk.Tables[0].Rows[0]["FrmWhere"].ToString())))
{
    ddlSubdistrict.Items.FindByText(sqlChk.Tables[0].Rows[0]["FrmWhere"].ToString()).Selected = true;
}

Posted 7-Jan-15 1:00am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Comments

ankitsrist 8-Jan-15 3:29am

thanks @tadit

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-Jan-15 3:41am

Most welcome buddy. :)

SRS(The Coder) · Accepted Answer · 2015-01-07T01:12:00

Hi ankitsrist,

You are trying to set the text for the current selected item so if the current selected item is something different then it will change the display text for that selected item.

Rather you need to set the SelectedValue for the dropdown if you have that.

It seems you have the text value only to select the dropdown, so here is the solution for your problem :-

JavaScript

ddlSubdistrict.SelectedIndex = ddlSubdistrict.Items.IndexOf(ddlSubdistrict.Items.FindByText(sqlChk.Tables[0].Rows[0]["FrmWhere"].ToString()));

Hope this will definitely of help to you.