How to show LINQ data in view in asp.net mvc?

Question

I am using a action called scrap as

public ActionResult Scrap()
 {
    var webGet = new HtmlWeb();
    var document = webGet.Load(Url);
    var wikians = from info in document.DocumentNode.SelectNodes("//div[@id='results']")
                  from link in info.SelectNodes("p//a").Where(x => x.Attributes.Contains("href"))
                  from content in info.SelectNodes("p").Where(y => y.HasAttributes != true)
                  select new
                    {
                      LinkURL = link.Attributes["href"].Value,
                      Text = content.InnerText                             
                    };

 return View();
}

Now I want to show all LinkURL and Text in view. For that I tried to use a model called WikiModel as

public class WikiModel
{
  public string url { get; set; }
  public string content { get; set; }
}

Now how can I go further so that I can show all infomation in my view. We can do so using the wikimodel but how to add all scrap action's data in this wikimodel? I don't know how to manipulate his select new of LINQ to save data in model.

Oded · Accepted Answer · 2012-05-28 17:40:35Z

2

To start with, you need to return list of your WikiModel objects from your query:

 var wikians = from info in document.DocumentNode.SelectNodes("//div[@id='results']")
                  from link in info.SelectNodes("p//a").Where(x => x.Attributes.Contains("href"))
                  from content in info.SelectNodes("p").Where(y => y.HasAttributes != true)
                  select new WikiModel
                    {
                      url = link.Attributes["href"].Value,
                      content = content.InnerText                             
                    };

You can pass this through to the view as the Model:

return View(wikians);

In your view, you now have access to this list via the Model.

answered May 28, 2012 at 17:40

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kapil Khandelwal · Accepted Answer · 2012-05-29 03:28:46Z

0

public ActionResult Scrap()
 {
    var webGet = new HtmlWeb();
    var document = webGet.Load(Url);
    var wikians = from info in document.DocumentNode.SelectNodes("//div[@id='results']")
                  from link in info.SelectNodes("p//a").Where(x => x.Attributes.Contains("href"))
                  from content in info.SelectNodes("p").Where(y => y.HasAttributes != true)
                  select new WikiModel

                    {
                      LinkURL = link.Attributes["href"].Value,
                      Text = content.InnerText                             
                    };

 return View(wikians);
}

edited May 29, 2012 at 3:28

answered May 28, 2012 at 17:43

Kapil Khandelwal

16.2k3 gold badges49 silver badges55 bronze badges

2 Comments

Oded Over a year ago

Why are you casting to List<WikiModel>?

Man8Blue Over a year ago

yeah creating problem related to casting

Collectives™ on Stack Overflow

How to show LINQ data in view in asp.net mvc?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related