Auto Generate in DropDownList

Question

auto generate in drop down list example E0001 etc..,

Satyapriya Nayak · Answer

Hi Try this... Untitled Page Width="100px"> Text="Insert Data" /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Dynamic_increment_using_Dropdown { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; int count; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownList1.Items.Add("Select"); SqlConnection con = new SqlConnection(strConnString); str = "select count(*) from employee"; com = new SqlCommand(str, con); con.Open(); count = Convert.ToInt16(com.ExecuteScalar()) + 1; DropDownList1.Items.Add("E000" + count); con.Close(); } } protected void btn_insert_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "insert into employee values('" + DropDownList1.SelectedItem.Text.Trim() + "','" + txt_empname.Text.Trim() + "'," + txt_sal.Text.Trim() + ")"; com = new SqlCommand(str, con); com.ExecuteNonQuery(); con.Close(); Label4.Text = "Records successfully Inserted"; } } } Thanks If this post helps you mark it as answer

Senthilkumar · Answer

Hi, If you are not getting the value from the sql server then you need to do it in C#. Sql can have the auto generate number from identity column or ROW_NUMBER() in query. In C#, if you use the datatable then you can set the datacolumn field as identity column. or you can iterate the items that you want to add into dropdown list and the looping number became auto generate number.

Satyapriya Nayak · Answer

If this post helps you mark it as answer Thanks

Auto Generate in DropDownList

Answers (3)