How to generate auto id based upon selection from dropdown

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!!!