Problem DropdwonList selectedValue and DataTable Column Length

Question

0.00/5 (No votes)

See more:

I have a column named productid.It has length equal 10.I have set maxlength of the column equal 10.I load DataTable contains this column into DropDownList.I can not select the item using:

C#

ddl.selectedValue=tbl.Rows[0][0].tostring();
//tbl.Rows[0][0].tostring()='PS001'

after checking the length, I get the ddl's length:10 and tbl.Rows[0][0].tostring()'s lenght:5.SelectValue was attached to the whitespace.
I can't

C#

ddl.selectedValue.trim()=tbl.Rows[0][0].tostring();

I tried not set MaxLength.I still get ddl's length equal 10
How to fix it?

Posted 18-Jun-12 7:30am

giatuan2011

Add a Solution

2 solutions

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)

khangaldi · Answer 1 · 2012-06-18T07:44:00

Solution 1

i didn't understand entirely what you mean but perhaps you are using trim() on the wrong side!
use this instead:

C#

ddl.selectedValue=tbl.Rows[0][0].tostring().Trim();

Posted 18-Jun-12 7:44am

khangaldi

Updated 18-Jun-12 19:46pm

v2

jkirkerx · Answer 2 · 2012-06-18T07:45:00

Solution 2

When you load your ddl, you have to provide a known value, which will become the selectedvalue.

When you set the value, the value you reference has to match one of the known values, or else you can't set the ddl value.

ddl.items.add(new listitem("red", "red"))
ddl.selectedvalue = "red"

I know it doesn't relate to your example, but I'm trying to convey the principal of selectedvalue

When in doubt, check the browser browser source (view source), and find your ddl, and look at the tags, for the format of your values

<option value="red">red</option>

Posted 18-Jun-12 7:45am

jkirkerx

Comments

giatuan2011 18-Jun-12 14:05pm

Sorry,I use DropdownList in GridView.My RowDataBound:
protected void grdContact_RowDataBound(object sender, GridViewRowEventArgs e)
{
ContactTypeTableAdapter contactType = new ContactTypeTableAdapter();
DataTable contactTypes = GetData();
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList cmbType = (DropDownList)e.Row.FindControl("cmbType");
if (cmbType != null)
{
cmbType.DataSource = contactTypes;
cmbType.DataTextField = "ProductName";
cmbType.DataValueField = "ProductId";
cmbType.DataBind();
cmbType.SelectedValue = grdContact.DataKeys[e.Row.RowIndex].Values[0].ToString();
}
//DataKeysName is ProductName.
}
I can get selectedValue when using:
grdContact.DataKeys[e.Row.RowIndex].Values[0].ToString().Insert(5," ");
if Productid is 'PS00000001',It can't get PS001