How can i select specific records from database in asp MVC?

Question

In the following code, I want to retrieve all those records whose Q_ID equals to the ID. Currently, I Select whole records instead of few. Please help me to solve this problem

    public ActionResult Solution(int ID)
    {
        Answers ans_obj = new Answers();

        List<Ans_Table> dbobj= db.Ans_Table.ToList();

        List<Answers> ansobj = dbobj.Select(x => new Answers
        {
            Answer = x.Answer,
            Q_ID=x.Q_ID,
            U_ID=x.U_ID

        }).ToList();

        return View();
    }

Marco · Accepted Answer · 2017-11-06 13:23:48Z

1

Have you tried a simple Where()?

public ActionResult Solution(int ID)
{
    List<Ans_Table> dbobj = db.Ans_Table.Where(x => x.Q_ID == ID).ToList();

    List<Answers> ansobj = dbobj.Select(x => new Answers
    {
        Answer = x.Answer,
        Q_ID=x.Q_ID,
        U_ID=x.U_ID
    }).ToList();

    return View(ansobj);
}

Side Note: You need to pass something into your View, or it will not display any data. You should read the basics of Asp.Net MVC

answered Nov 6, 2017 at 13:23

Marco

24.1k13 gold badges81 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

How can i select specific records from database in asp MVC?

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