How to convert comma seperate string values into list using ASP.NET mvc5

Question

1.00/5 (2 votes)

See more:

List<string> ReportColumnsList = DBFunctionOBj.GetColumnNamesByReportname(Reportname);

in ReportColumnsList values getting like this

Account,EmailTo,Subject,MessageContent

but i need to display values in listbox
Account
EmailTo
Subject
MessageContent

What I have tried:

public List<string> GetColumnNamesByReportname(string Reportname)
       {
           using (var Context = new MCPEntities())
           {
               var ColumnNames = Context.Reports.Where(c => c.ReportName == Reportname).Select(c => c.ColumnNames).ToList();
               return ColumnNames;
             }
       }

  List<string> ReportColumnsList = DBFunctionOBj.GetColumnNamesByReportname(Reportname);
return Json(names, JsonRequestBehavior.AllowGet);

Posted 8-Jun-17 0:00am

VenkataSeshu B

Updated 8-Jun-17 17:27pm

Add a Solution

Comments

F-ES Sitecore 8-Jun-17 6:05am

No-one is going to write your code for you, google how to call an mvc action from jQuery and you'll find code that shows how you get the list in javascript, then google how to create a listbox in jQuery and you'll get the code for that too, then just put the two together.

2 solutions

Solution 1

Use Split[^] to get an array, than use new List()[^] on that array...

Posted 8-Jun-17 0:11am

Kornfeld Eliyahu Peter

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)

Karthik_Mahalingam · Accepted Answer · 2017-06-08T17:27:00

try

public List<string> GetColumnNamesByReportname(string Reportname)
      {
          using (var Context = new MCPEntities())
          {
              List<string> ColumnNames = Context.Reports.Where(c => c.ReportName == Reportname).Select(c => c.ColumnNames).ToList();
              if (ColumnNames.Count == 1)
                  return ColumnNames[0].Split(',').ToList();
              return ColumnNames;
          }
      }