Getting Started

Re: Text property of Dropdownlist

pateldevang84 — Thu, 09 Jul 2009 08:37:48 GMT

USE BELOW CODE

--------------------------

SqlDataReader drd;
if (drd.Read())
{
drpcompname.Items.Add(drd.GetValue(0).ToString());

drpcompname.Items.FindByText("drd.GetValue(0).ToString()").Selected = True;
}

May be this help........

Re: Text property of Dropdownlist

pateldevang84 — Thu, 09 Jul 2009 08:33:49 GMT

USE BELOW CODE

--------------------------

SqlDataReader drd;
if (drd.Read())
{
drpcompname.Items.Add(drd.GetValue(0).ToString());
}

May be this help........

Re: Text property of Dropdownlist

Shengqing Yang - MSFT — Thu, 09 Jul 2009 08:13:05 GMT

Hi,

I think the problem is based on the sql query instead of the code "drpclienttype.Text = drd.GetValue(16).ToString();".

I noticed that you add the items to the DropDownList from table client_info, but when you set the DropDownList's Text, you used table addrequirement. You need to know, when we set the string to DropDownList's Text, this string must be contained in the DropDownList itself. Like the two example below, the first one of which is correct but the second one is not.

DropDownList1.Items.Add("1");
DropDownList1.Items.Add("2");
DropDownList1.Items.Add("3");

DropDownList1.Text = "2";

DropDownList1.Items.Add("1");
DropDownList1.Items.Add("2");
DropDownList1.Items.Add("3");

//this is not correct, because there is no "5" in the DropDownList
DropDownList1.Text = "5";

So, I suggest you having a check to make sure that you set the string in the items of the DropDownList to the DropDownList.

Best Regards,
Shengqing Yang

Re: Text property of Dropdownlist

srinivaskotra — Sat, 04 Jul 2009 18:34:46 GMT

hi,

i dont find errors in your code, but plz change this code line

com = new SqlCommand("select compname from client_info where clienttype=' " + drpclienttype.SelectedItem.Text.Trim() + " ' and uid=" + lblamid.Text , con);

and i have observed some times the below syntex will not work.

drpclienttype.Text = drd.GetValue(16).ToString(); change this to like below.

drpclienttype.item.findbyvalue[drd.GetValue(16).ToString()].selected=True;

Thanks :)

Re: Text property of Dropdownlist

rickj1 — Sat, 04 Jul 2009 16:45:21 GMT

Try it with linq I have two ddl that combine the results and select from data base selecting two rows

I used this tutorial and tweeked it to fit my needs

http://www.asp.net/learn/linq-videos/video-233.aspx

protected void btnSelect_Click(object sender, EventArgs e)
    {
        RentagentDataContext db = new RentagentDataContext();
        var userProfile = from u in db.UserProfiles
                          where (u.CityId == Int32 .Parse (ddlCity .SelectedValue ) && (u.CatergoryId == Int32 .Parse (ddlCatergory .SelectedValue )))
                          select u;
        workerAdds.DataSource = userProfile;
        workerAdds.DataBind();
    }

don't forget to mark as answer if this helps

Re: Text property of Dropdownlist

veenag81 — Sat, 04 Jul 2009 09:01:02 GMT

'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

Above error come when u have value in dropdownlist not match with the tabledata. If in your dropdownlist value like "Baroda" and value which u r fetching is "baroda" then also u get above error. so make sure that both r same so u not get error. Also watch for uppercase and lowercase of value also.

Re: Text property of Dropdownlist

Pankaj18 — Sat, 04 Jul 2009 08:09:46 GMT

Hi,
I have a Dropdownlist name drpcompname,which add some items on page_load event. And I have a Button name btnsearch,on which click event ,i want to display a single text matching from database.

My Code as shown below::

Page_Load event Code::

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

com = new SqlCommand("select compname from client_info where clienttype='" + drpclienttype.SelectedItem.Text + "' and uid='" + lblamid.Text + "'", con);

con.Open();

drd = com.ExecuteReader();

while (drd.Read())

{

drpcompname.Items.Add(drd.GetValue(0).ToString());

}

con.Close();

}

And btnsearch Click event::

protected void btnsearch_Click(object sender, EventArgs e)

{

com = new SqlCommand("select * from addrequirement where reqid='" + txtreqid.Text + "'", con);

con.Open();

drd = com.ExecuteReader();

if (drd.Read())

{

drpclienttype.Text = drd.GetValue(16).ToString();

}

con.Close();

}

But it display an error:

'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

Thanks!

Pankaj Singh

Re: Text property of Dropdownlist

Pankaj18 — Sat, 04 Jul 2009 08:04:11 GMT

Page_Load event Code::

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

com = new SqlCommand("select compname from client_info where clienttype='" + drpclienttype.SelectedItem.Text + "' and uid='" + lblamid.Text + "'", con);

con.Open();

drd = com.ExecuteReader();

while (drd.Read())

{

drpcompname.Items.Add(drd.GetValue(0).ToString());

}

con.Close();

}

And btnsearch Click event::

protected void btnsearch_Click(object sender, EventArgs e)

{

com = new SqlCommand("select * from addrequirement where reqid='" + txtreqid.Text + "'", con);

con.Open();

drd = com.ExecuteReader();

if (drd.Read())

{

drpclienttype.Text = drd.GetValue(16).ToString();

}

con.Close();

}

Thanks!

Pankaj Singh

Re: Text property of Dropdownlist

srinivaskotra — Fri, 03 Jul 2009 19:09:45 GMT

Hi,

SqlDataReader drd;
if (drd.Read())
{
drpcompname.Text = drd.GetValue(0).ToString();

}

as per my understanding if you want to select text in drop down which already bind.

drpcompname.items.findbyvalue("drd.GetValue(0).ToString()).selected=true;

data bind code like this

DropDownList1.DataTextField=dr["<column>"].Tostring();

DropDownList1.DataValueField=dr["<column>"]Tostring();

drd.datasource=dr[0].Tostring();

Thanks :)

Re: Text property of Dropdownlist

nijhawan.saurabh — Fri, 03 Jul 2009 18:56:58 GMT

Use:

MyDropDownList.Items.Add(new ListItem("India", "IND"));

Here "INDIA" would be the text and "IND" would be the value.

Hope it works!

Text property of Dropdownlist

Pankaj18 — Fri, 03 Jul 2009 15:03:18 GMT

Hi,

I want to display a text getting from Database, into a Dropdownlist using Text property.

My code::

SqlDataReader drd;
if (drd.Read())
{
drpcompname.Text = drd.GetValue(0).ToString();

}

But it display an error:

'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

Please Help me..

Thanks!

Pankaj Singh

Getting Started

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

Re: Text property of Dropdownlist

Text property of Dropdownlist

'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value

'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value