Auto Generate in DropDownList

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.

If this post helps you mark it as answer

Thanks

Hi


Try this...


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Dynamic_increment_using_Dropdown._Default" %>





   


   

   

                 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