How to use select query in dropdown? In MVC controller

Question

0.00/5 (No votes)

See more:

I have to much data in my table which I bind in my dropdown, but now I want just those data which i want. Can i implement select query here?
I want some of my data according to my select query, like i want "acc_no" where acc_des="XYZ".

What I have tried:

This is my controller and i bind table like this...

C#

var accounts = db.gl_m_acc.ToList();
            foreach (var item in accounts)
            {
                GetAccountsCH ac = new GetAccountsCH();
                ac.acc_no = item.acc_no;
                ac.acc_des = item.acc_des;
                Gl_t_Vcr_model.acc.Add(ac);
            }

This is my View:

HTML

@Html.DropDownListFor(model => model.acc_no, new SelectList(Model.acc, "acc_no","acc_des"), "<---Select--->", new { @class = "form-control", style = "width: 100%;" })

This is my Model:

C#

public class GetAccountsCH
    {
        public int acc_no { get; set; }

        public string acc_des { get; set; }
    }
 public class Gl_t_vcr
    {
  public List<getaccountsch> acc = new List<getaccountsch>();
      }

Posted 3-Apr-19 1:12am

Member 13146819

Updated 3-Apr-19 5:49am

David_Wimbley

v3

Add a Solution

Comments

#realJSOP 3-Apr-19 7:18am

Your variable and method names absolutely suck.

Just sayin...

1 solution

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)

David_Wimbley · Accepted Answer · 2019-04-03T05:50:00

Your code is too hard to follow due to abbreviations used as variable names. I can't easily tell whats what.

So here is how you can filter data in the controller for use in your view. You'll need to make one or two modifications to your model.

Controller

C#

public ActionResult Index ()
{
    var model = new MyModel();
    var getData = database.MyTable.Where(m=>m.AccountDescription = "Savings");

    foreach(var item in getData)
    {
       //I did not put this code into a compiler, i may have the SelectListItem property names incorrect
       var selectItem = new SelectListItem();
       //Sets what is displayed in the drop down
       selectItem.Text = item.AccountNumber;
       //Sets the value to capture
       selectItem.Value = item.AccountNumber;
       model.DropDown.Add(selectItem);
    }
    return View(model);
}

Model

C#

public class MyModel
{
    public MyModel()
    {
        this.DropDown = new List<SelectListItem>();
    }

    public string AccountNumber {get;set;}
    public List<SelectListItem> DropDown {get;set;}
}

View