generate empid automatically in asp.net c#

Question

Hi to all I want code and design for automatically generate an empid while we give data into the textboxs.then by clicking submit button the data what we entered are stored in database and generate a empid automatically and by considering that empid as a username and password.Please solve my problem. Thanks in advance

Ravi Ranjan Kumar · Answer

Try This CREATE TABLE tbEmployee ( Emp_Id INT NOT NULL IDENTITY(11) PRIMARY KEY Emp_Code AS 'EMP' + RIGHT('0000'+ CONVERT(VARCHAR(5)EmpId)5) PERSISTED OtherColumns.... ) Emp_Code automatically insert Uniquely Identity code as per based Emp_ID

Francis · Answer

If I delete in between one record in employee table next auto generate id gives duplicate value (Previous value). Please give me the solution. Yes ofcourse. So I would suggest instead of go with manual increment you can go with the Identity in SQL Server. There you can eliminate this issue. https://msdn.microsoft.com/en-IN/library/ms186775.aspx Hope this helps!

jeeva elango · Answer

If I delete in between one record in employee table next auto generate id gives duplicate value (Previous value). Please give me the solution.

Balu Mate · Answer

it's working Thanks................!

Satyapriya Nayak · Answer

Untitled Page Text=Insert Data /> using System; 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; 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) { autogenerated(); } } void autogenerated() { SqlConnection con = new SqlConnection(strConnString); str = select count(*) from employee; com = new SqlCommand(str con); con.Open(); count = Convert.ToInt16(com.ExecuteScalar()) + 1; txt_empid.Text = count.ToString(); txt_empid.Enabled = false; con.Close(); } protected void btn_insert_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee values(' + txt_empid.Text.Trim() + '' + txt_empname.Text.Trim() + ' + txt_sal.Text.Trim() + ); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); Label4.Text = Records successfully Inserted; txt_empname.Text = ; txt_sal.Text = ; autogenerated(); } } Thanks If this post helps you mark it as answer