How to add data into an unordered list from database in mvc4

Question

1.00/5 (1 vote)

See more:

Hi,
I have a menu which contain an unordered list. i have to get data into this unordered list from database. Please any one help me.

In my controller:

C#

DataTable dtc = registerDAL.CategoryRetrieve();ArrayL
ist category = new ArrayList();
          foreach (DataRow dr in dtc.Rows)
          {
              category.Add(dr);
          }

In my view:
i need to get these categories an display as a list.
What can i do?

Posted 17-Jul-13 20:10pm

Minnu Sanju

Updated 2-Jul-16 1:34am

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)

Jameel VM · Answer 1 · 2013-07-17T22:04:00

Herei am demonstrate a simple example for loading list.Please follow the steps

Create a Model

C#

public class YourList
{
public ArrayList Category{get;set;}
}

Create a Controller and ActionResult

C#

public ListController:Controller
{
public ActionResult Index()
{
DataTable dtc = registerDAL.CategoryRetrieve();ArrayL
ist category = new ArrayList();
          foreach (DataRow dr in dtc.Rows)
          {
              category.Add(dr);
          }
var list=new YourList();
list.Category=category;
return View(list)
}
}

Create a view by right clicking the index view and loop through the category

C#

@model YourList
{
<ul>
  @foreach (var item in Model.Category)
            {
                <li>@item</li>          
            }
</ul>
}

Hope this helps

Balaram224 · Answer 2 · 2016-07-02T01:34:00

how to bind my entity data to dropdown bootstarp dropdown in MVC app
Playlist is my data table from entity database and
connection name playlist entity
below is my code

HTML

<div class="row">
    <div class="container">
        <div class="col-md-2 col-md-offset-10">
            <div style="float:right;">
                <ul class="nav-dp navdpbar-nav">
                    <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown">My Playlists <span class="caret"></span></a>

                        <ul class="dropdown-menu">
                           

                        </ul>
                    </li>
                </ul>
            </div>
        </div>
    </div>
</div>

share what i have to do changes in my code

How to add data into an unordered list from database in mvc4

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0