bind dropdown in form

Question

i tired to bind year dropdown like this

<div class="col-sm-7">
<select id="dropdown">
<option value="">-Select-</option>
</select>
</div>

let dateDropdown = document.getElementById('dropdown');

let currentYear = new Date().getFullYear();
let earliestYear = 1970;

while (currentYear >= earliestYear) {
let dateOption = document.createElement('option');
dateOption.text = currentYear;
dateOption.value = currentYear;
dateDropdown.add(dateOption);
currentYear -= 1;
}

and its shows dropdown of year,

but my problem is how can i bind or fetch in backend code

revivalForm.Year = ??

Vishal Yelve · Answer

Hi Garima, from backend C# public void PopulateYears(int startYear) { List years = new List (); int currentYear = DateTime.Now.Year; for (int year = startYear; year OR protected void Page_Load(object sender, EventArgs e) { Year(); } protected void Year() { for (int i = 2010; i Aspx page

Naimish Makwana · Answer

Hello Garima, You can fetch selected dropdown value as below and make ajax calll to send this value to backend. EX: let dateDropdown = document.getElementById('dropdown'); let selectedYear = dateDropdown.value; $.ajax({ type: 'POST', url: '/your/backend/endpoint', //Your API/Controller Action data: { year: selectedYear }, success: function(data) { // Do something with the response data, if desired } }); In C# .net controller you can create method like below: [HttpPost] public ActionResult YourAction(int year) { // Use the year value in your C# code // ... return Json(new { success = true }); } Thanks Naimish Makwana

Vishal Yelve · Answer

On save click protected void Save(object sender, EventArgs e) { string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("INSERT INTO TblYear(Year) VALUES(@Year)")) { cmd.Connection = con; cmd.Parameters.AddWithValue("@Year", dropDown.SelectedItem.Text); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } }

Garima Bansal · Answer

Vishal Yelve list of year in dropdown shows my problem how can i store in database