Click here to Skip to main content
15,881,173 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
My controller Page
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using _24X7Hires.Models;

namespace _24X7Hires.Controllers
{
    public class DealerController : Controller
    {

        public ActionResult VariantCreation()
        {
            return View();

        }
        public JsonResult GetDealer(string id)
        {
            List<DealerController> products = new List<DealerController>();

            string query = string.Format("SELECT  [VARIANTID], [VARIANTNAME], [VEHICLENAME] " +
                " FROM [VARIANT].[dbo].[Dealer] WHERE CategoryID = {0}", id);

            using (SqlConnection con = new SqlConnection("Valraj"))
            {
                using (SqlCommand cmd = new SqlCommand(query, con))
                {
                    con.Open();
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        Dealer.Add(
                            new Dealer
                            {
                                VARIANTID = reader.GetValue(0).ToString(),
                                VARIANTNAME = reader.GetString(1),
                                VEHICLENAME = reader.GetString(2),
                            }
                        );
                    }
                }
            }

            return Json(VARIANT, JsonRequestBehavior.AllowGet);
        }

        public object VARIANT { get; set; }
    }
}


My class Page
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace _24X7Hires.Models
{
    public class Dealer
    {
        public IList<SelectListItem> VariantName { get; set; }
        public IList<SelectListItem> VehicleName { get; set; }

        public string VARIANTID { get; set; }

        public string VARIANTNAME { get; set; }

        public string VEHICLENAME { get; set; }

        internal static void Add(Dealer dealer)
        {
            throw new NotImplementedException();
        }
    }
   
}




My View Page


@model _24X7Hires.Models.Dealer

<script src="~/Scripts/jquery-1.7.1.min.js"></script>
<script type="text/javascript">
    $("#ddlCountry").change(function () {
        $.ajax({
            type: "GET",
            url: "@Url.Action("GetCountryName")",
            data: { ddltext: $("#ddlCountry option:selected").text() },
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            success: function (response) {
                $('#txtcountryname').val(response);

            },
            failure: function (msg) {
                alert(msg);
            }

        });
    });
</script>
@{
    ViewBag.Title = "Dealer";
}

        @using (Html.BeginForm())
        {
            @Html.AntiForgeryToken()
            @Html.ValidationSummary(true)

            <fieldset>
                <legend>Dealer</legend>
                <center>
                    <div class="editor-label">
                        @Html.LabelFor(Model => Model.VariantName)
                    </div>
                    <div class="editor-field2">
                       @Html.DropDownList("VariantName", Model.VariantName, "Select VariantName") 
                    </div><br/>
                    <div class="editor-label">
                        @Html.LabelFor(Model => Model.VehicleName)
                    </div>
                    <div class="editor-field2">
                        @Html.DropDownList("VehicleName", Model.VehicleName, "Select VehicleName")
                    </div>
                    </center>
               
                <center>
                    <p>
                        <button type="button" onclick="location.href='@Url.Action("groupsearch", "groupimage")'">Submit</button>
                    </p>
                </center>
            </fieldset>
        }


What I have tried:

HOW TO GET ANSWER
pls check and give solution
Posted
Updated 22-Dec-17 19:56pm
v3
Comments
Suvendu Shekhar Giri 20-Sep-16 3:13am    
What is the question by the way?
Member 12714650 20-Sep-16 3:26am    
i could not able to get drop down values
Member 12714650 20-Sep-16 3:29am    
i am new in mvc 4
Member 12714650 20-Sep-16 3:32am    
how to bind the data from my database to drop down list using mvc4 c#

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900