Autocomplete Textbox from database MVC 5

Question

I have my textboxfor field which select the data from role table from the database i need this textboxfor field make a autocomplete with starting character.

Sample:

MVC code:

This JsonResult in the UsersControl

 public JsonResult GetRoles(string Prefix)
    {
        var RoleListVal = db.Roles.Where(r => r.Deleted == false)
            .Where(r => r.Name.ToUpper().StartsWith(Prefix))
            .Select(r => new { Name = r.Name, ID = r.RoleID }).Distinct().ToList();
        return Json(RoleListVal, JsonRequestBehavior.AllowGet);
    }

cshtml Code:

This the JS and the HTML5 TextBoxFor:

$("#keywords-manual").autocomplete({
        source: "/Users/GetRoles",
        minLength: 1
    })

<div class="form-inline">
            @Html.Label("Role :")
            @Html.TextBoxFor(model => model.Roles.FirstOrDefault().Name, new { @class = "form-control", @id = "keywords-manual" })
</div>

I don't why isn't working!

Your server side method is hitting or not when you type in autocomplete? If it is hitting then RoleListVal is filled with values ? — Sometimes Code
– Sometimes Code, Commented Sep 28, 2016 at 11:14

Divyang Desai · Accepted Answer · 2016-09-28 12:58:25Z

2

Here your controller side method looks good.

But issue is while you calling method.

    $("#keywords-manual").autocomplete({
        source: function (request, response) {
            $.ajax(
                    {
                        type: "POST",
                        url: '@Url.Action("GetRoles","Users")',
                        data: { Prefix: $('#keywords-manual').val() },
                        dataType: "json",
                        success: function (data) {
                            response($.map(data, function (item) {
                                return {
                                    value: item.Name,
                                    description: item
                                }
                            }))
                        },
                        error: function (error) {
                            console.log(error);
                        }
                    });
        },
        minLength: 1,
        select: function (event, ui) {

        }
    });

edited Sep 28, 2016 at 12:58

answered Sep 28, 2016 at 11:28

Divyang Desai

7,89414 gold badges56 silver badges83 bronze badges

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

5 Comments

Ahmed Hossam Alhansy Over a year ago

Not make anything also

Ahmed Hossam Alhansy Over a year ago

Not hit the method

Ahmed Hossam Alhansy Over a year ago

Is it must add any reference to the html page ?

Ahmed Hossam Alhansy Over a year ago

the link attributes depend on what ?

Mihai Alexandru-Ionut Over a year ago

Use [HttpPost] for hitting the method

Haitham Shaddad · Accepted Answer · 2016-09-28 11:48:18Z

-1

This is how you configure the Autocomplete plug in

On HTML Side:

$(function () {
            $("#keywords-manual").autocomplete({
                source: "@Url.Action("GetRoles","Users")",
                minLength: 1
            })
                   });

On the controller side:

public JsonResult GetRoles(string term)
    {
        var RoleListVal = db.Roles.Where(r => r.Deleted == false)
            .Where(r => r.Name.ToUpper().StartsWith(term))
            .Select(r => new { label = r.Name, id = r.RoleID,value=r.RoleID }).Distinct().ToList();
        return Json(RoleListVal, JsonRequestBehavior.AllowGet);
    }

answered Sep 28, 2016 at 11:48

Haitham Shaddad

4,4662 gold badges16 silver badges23 bronze badges

3 Comments

Haitham Shaddad Over a year ago

@Div the autocomplete plugin does that automatically

Haitham Shaddad Over a year ago

@AhmedHossamAlhansy It may have a syntax error, but you should be able to fix it, if not, just put the error message and I will let you know how

Haitham Shaddad Over a year ago

@AhmedHossamAlhansy Open the dev toolbar, then type something in the textbox, check the network tab and see if it fires a request to the backend or not and inspect the requested URL and query string parameter, check also if the backend method in the controller is called or not and if it is called, check the results and also make sure the console tab in the dev toolbar is not showing any errors, if it shows any error, please copy it here

Collectives™ on Stack Overflow

Autocomplete Textbox from database MVC 5

Sample:

2 Answers 2

5 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Sample:

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related