Jquery UI autocomplete inside MVC3 application

Question

Hello i have this code in the controller :

   ViewBag.localitate = db.Localitatis.OrderBy(p => p.Localitate).ToList();

and on the view i try to get it via:

<script type="text/javascript">
    $(function () {
        var availableTags = [
         @foreach (var item in ViewBag.localitate)
              {
                       @item.Localitate 
             }


    ];
        $("#destination").autocomplete({
            source: availableTags
        });
    });
</script>

I din't know how to format this in order to get an array like in the jquery demo example :

"ActionScript",
        "AppleScript",
        "Asp",
        "BASIC",
        "C",
        "C++",
        "Clojure",
        "COBOL",
        "ColdFusion",
        "Erlang",
        "Fortran",
        "Groovy",
        "Haskell",
        "Java",
        "JavaScript",
        "Lisp",
        "Perl",
        "PHP",
        "Python",
        "Ruby",
        "Scala",
        "Scheme"

in order to make the autocomplete work with my values from database,

thank you

Andrew Whitaker · Accepted Answer · 2012-08-30 22:31:46Z

2

<script type="text/javascript">
    $(function () {
        $("#destination").autocomplete({
            source: @Html.Raw(Json.Encode(ViewBag.localitate))
        });
    });
</script>

If you have lots of data, consider using a server-side controller action to perform the filtering.

answered Aug 30, 2012 at 22:31

Andrew Whitaker

126k32 gold badges296 silver badges308 bronze badges

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

Comments

StriplingWarrior · Accepted Answer · 2012-08-30 22:35:03Z

0

First, set your view data to only have the actual names you want:

ViewBag.localitate = db.Localitatis.Select(p => p.Localitate).OrderBy(p => p).ToList();

Then the simplest way to render this in javascript would be:

var availableTags = [" @String.Split("\,\"", ViewBag.localitate) "];

But I'd recommend using a JSON parser like JSON.NET instead. This way you don't have to worry about cross-site scripting attacks and such, since things are escaped for you.

var availableTags = @(JsonConvert.Serialize(ViewBag.localitate));

edited Aug 30, 2012 at 22:35

answered Aug 30, 2012 at 22:29

StriplingWarrior

158k29 gold badges261 silver badges326 bronze badges

Collectives™ on Stack Overflow

Jquery UI autocomplete inside MVC3 application

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related