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