How to generate auto id based upon selection from dropdown

Question

Hi I want to know how to generate auto id based upon selection from dropdown list having list items of CityName. When select city from the dropdown list then there respective auto id will be generated. suppose I have given city id for Mumbai is 01 then the generated code will be combination of citycode current date and some number(0001). Ex: 01 210116 0001 How this is possible with linq. thank you..

Mani Kandan · Answer

Hi Pradeep Kumar int value = Convert.ToInt32(0001) + 1; var addcityID = Your city id + DateTime.Now.ToString(ddMMyy) + value.ToString().PadLeft(4 '0'); if (!IsPostBack) { DropDownList1.Items.Add(new ListItem(Mumbai addcityID true)); DropDownList1.DataBind(); } For getting city name to set dropdown value from database using Linq. Given below var ddlvalue = (from dd in db.PRODUCTs select dd.pr_product).Distinct().ToList(); after you can add 'ddlvalue' variable to dropdownlist like this if (!IsPostBack) { DropDownList1.Items.Add(new ListItem(ddlvalue  addcityID true)); DropDownList1.DataBind(); } Try this one hope this will help you!!!