My SQL Script
create table menu_Script
(ID int primary key identity(1,1),
Title varchar(50),
ParentId int ,
Url varchar(50))
select * from menu_Script
Insert into menu_Script values
('A',Null,'#')
Insert into menu_Script values
('B',Null,'#')
Insert into menu_Script values
('C',Null,'#')
Insert into menu_Script values ('A1',1,'#')
Insert into menu_Script values ('A1',1,'#')
Insert into menu_Script values ('A1',1,'#')
Insert into menu_Script values ('B1',2,'#')
Insert into menu_Script values ('B2',2,'#')
Insert into menu_Script values ('B3',2,'#')
Insert into menu_Script values ('B1(Subpart)',7,'#')
Insert into menu_Script values ('B1(Subpart)',7,'#')
Insert into menu_Script values ('B1(Subpart)',7,'#')
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace Example_cascading.Controllers
{
public class HomeController : Controller
{
//
// GET: /Home/
public ActionResult Index()
{
List<SelectListItem> CountryList = new List<SelectListItem>();
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = "select Title,ID from menu_Script where ID Between 1 and 3";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
CountryList.Add(new SelectListItem
{
Text = sdr["Title"].ToString(),
Value = sdr["ID"].ToString()
});
}
}
con.Close();
}
};
ViewBag.CountryList = CountryList;
return View();
}
public JsonResult GetStates(string id)
{
List<SelectListItem> statesList = new List<SelectListItem>();
statesList.Add(new SelectListItem { Text = "---Select---", Value = "-1" });
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = "select Title,ID from menu_Script where ParentId=" + id;
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
statesList.Add(new SelectListItem
{
Text = sdr["Title"].ToString(),
Value = sdr["ID"].ToString()
});
}
}
con.Close();
}
};
return Json(statesList, JsonRequestBehavior.AllowGet);
}
public JsonResult GetCities(string id)
{
List<SelectListItem> citiesList = new List<SelectListItem>();
citiesList.Add(new SelectListItem { Text = "---Select---", Value = "-1" });
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = "select Title,ID from menu_Script where ParentId=" + id;
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
citiesList.Add(new SelectListItem
{
Text = sdr["Title"].ToString(),
Value = sdr["ID"].ToString()
});
}
}
con.Close();
}
};
return Json(citiesList, JsonRequestBehavior.AllowGet);
}
[HttpPost]
public ActionResult Index(FormCollection formCollection)
{
return new EmptyResult();
}
}
}
I want Its ID and Tilte Store into Next Table