How to convert Ienumerable() to string?

Question

0.00/5 (No votes)

See more:

, +

Hi all,i having a code like this and iam binding that string value to dropdownlist.

string test = ds.Tables[0].AsEnumerable().Where(x => x.Field<int>("Id") == lbl.Text).Select(z => z.Field<string>("Description")).ToString();

Drpdwn.Items.Add(test);

but when execution it binds like this,

System.Data.EnumerableRowCollection'1[System.String]

How to fix this?Thanks in Advance..

Posted 11-Nov-15 19:13pm

Maniraj.M

Updated 13-Nov-15 19:52pm

v2

Add a Solution

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)

Krunal Rohit · Accepted Answer · 2015-11-11T19:20:00

Solution 1

Loops through the collection and add it to the dropdown items.

C#

var items = ds.Tables[0].AsEnumerable().Where(x => x.Field("Id") == lbl.Text).Select(z => z.Field("Description")).ToList();

foreach(var i in items)
{
    Drpdwn.Items.Add(i.ToString());
}

-KR

Posted 11-Nov-15 19:20pm

Krunal Rohit

Comments

Maniraj.M 12-Nov-15 2:08am

The idea is good but you forget to specify the Type of the Field so it showing compile time error..Is there any possibilities?

Krunal Rohit 12-Nov-15 2:30am

Debug your code and check what are you getting in items.
Post the error message here.

-KR

Matt T Heffron 12-Nov-15 16:40pm

If you're just going to iterate over the result of the Linq statement then the .ToList() is unnecessary.

Maniraj.M 13-Nov-15 1:29am

Then what's the correct one?

Matt T Heffron 13-Nov-15 12:35pm

Just omit the .ToList(). It should behave exactly the same without needing to allocate a List that will be dropped on the floor right after the foreach.

Maniraj.M 14-Nov-15 0:22am

Ya its working..!Thank u matt