MVC Retrieving Data From DB and Displaying it in View

Question

I am not 100% how to tackle this.

I have a basic controller who retrieves data from a table called transactions

CONTROLLER private NWBA_DBEntities db = new NWBA_DBEntities();

    public ActionResult Index()
    {
        var statements = db.Transactions.ToList();
        return View(statements);

    }

I have basic model:

public class StatementModel
{

    [StringLength(50)]
    [Display(Name="Transaction Type: ")]
    public string TransactionType { get; set; }

    [StringLength(50)]
    [Display(Name = "AccountNumber")]
    public string AccountNumber { get; set; }



}

My problem is at the View, i cant seem to display the values in a table:

@model Login.Models.StatementModel

@{
    ViewBag.Title = "Statements";
}


<h2>Index</h2>

<table>
    <tr>
        <th>
            @Html.DisplayNameFor(model => model.TransactionType)
        </th>
        <th>
            @Html.DisplayNameFor(model => model.AccountNumber)
        </th>

        <th></th>
    </tr>

    @foreach (var item in Model) 
    {
    <tr>

    </tr>
}
</table>

Can some one please help

you are not saving the values in the Statement model in the Action method in the controller. — Manikandan Sigamani
– Manikandan Sigamani, Commented Sep 29, 2013 at 7:29

Manikandan Sigamani · Accepted Answer · 2013-09-29 07:45:13Z

4

public ActionResult Index()
    {
        var statementModel = from s in db.Transactions
                            select new StatementModel
                            {
                                TransactionType  = s.TransactionType,
                                AccountNumber = s.AccountNumber
                            }
        return View(statementModel);

    }

answered Sep 29, 2013 at 7:45

Manikandan Sigamani

1,9941 gold badge15 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

MVC Retrieving Data From DB and Displaying it in View

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related