Populating dropdown from SQL Server with ajax and MVC

kris7i

New member
Joined
Aug 14, 2020
Messages
1
Programming Experience
Beginner
I dont get any result at all at my dropdown field.
AJAX script

Ajax code:
script type="text/javascript">
    $(document).ready(function () {
        $.ajax({
            type: "GET",
            url: "/Dokument/GetTipi",
            data: "{}",
            success: function (data) {
                var s = '<option value="-1">Selektoni Tipin</option>';
                for (var i = 0; i < data.length; i++) {
                    s += '<option value="' + data[i].Id_Tipi + '">' + data[i].Emri_llojit + '</option>';
                }
                $("#tipiDropdown").html(s);
            }
        });
    });
</script>

Controller method:
public ActionResult Dokument()
{
    return View();
}
// GET: NgarkoDokument

public ActionResult GetTipi()
{
    Test_kristiEntities db = new Test_kristiEntities();

    return Json(db.Tipi.Select(x => new
    {
        Id_Tipi = x.Id_Tipi,
        Emri_llojit = x.Emri_llojit
    }).ToList(), JsonRequestBehavior.AllowGet);

    // return View();
}
Model im using, the object of my tables:
namespace Archieve1.Models
{
    public class NgarkoDokument
    {
        public Dokumenti Dokumenti { get; set; }
        public Fusha_Indeksimit FushaIndeksimit { get; set; }
        public Vendndodhja_Fizike Vendndodhja_fizike { get; set; }
        public IEnumerable<Tipi> Tipi { get; set; }

       
    }
}

HTML:
<select title="Lloji i dokumentit" name="lloji" class="form-control col-md-3 box" id="tipiDropdown"> </select>
 
Last edited:
What kind of debugging have you done so far? Is the web service being called? Is the web service returning data? Is the AJAX call getting back data?
 
Back
Top Bottom