bind dropdown in form

Garima Bansal

i tired to bind year dropdown like this

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 = ??

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Yelve3y ago

Accepted 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 <= currentYear; year++)
    {
        years.Add(year);
    }

    // Bind the dropdownlist
    ddlYears.DataSource = years;
    ddlYears.DataBind();
}

protected void Page_Load(object sender, EventArgs e)
{
    Year();
}

protected void Year()
{
    for (int i = 2010; i <= 2050; i++)
    {
        DropDownList1.Items.Add(i.ToString());
    }
    DropDownList1.Items.FindByValue(System.DateTime.Now.Year.ToString()).Selected = true;
}

Aspx page

Vishal Yelve3y ago

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();
            }
        }
}

Naimish Makwana3y ago

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

Garima Bansal3y ago
Vishal Yelve

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