ASp.net employee id automatic generation using sql

Question

Hi,
In my application i have empid column,,,in that id should come as max(empid)+1 from database automatically,my database is sql server can u plz suggest the query for my problem,,,

Thanx in Advance,

Regards,
Sathish Pabbathi

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(); } }

Rasadul Alam Rashed · Answer

See this : http://cybarlab.com/great-or-good-primary-key http://cybarlab.com/random-number-in-sql

Sathish Pabbathi · Answer

Hi Satya Priya, I Had one more problem,,i used the above code in my application, as autogenerated() function is there in the page load method when i refresh the page manully(without Submitting),then also Id Automatically Incrementing,How can i overcome this problem?,,, and iam using server side validations in Submit Button,,,so when im saving the values its checking for validations after values are saved..if i refresh the page then automatically Id Goes on Incrementing as that method is in page load,,this is my actual problem

Sathish Pabbathi · Answer

Thanx it almost fulfill my requirement..

Jay S · Answer

So, to query your sql server and pass it back through to the text/label you need to be able to use some type of where statement.. Whether the person has a login username thats stored, or something like that to be able to query. Or if you use the create employee page and then pass it through a querystring..

Jay S · Answer

How are you creating your new record?

Jay S · Answer

You have a table with 1000 + empID ..how are you going to pick out the right one you want to display?

Jay S · Answer

How are you going to get that ID...what "where" clause can you pass through from your front end.. E.G SELECT ID FROM tbl WHERE StaffName = ' Sathish '

Jay S · Answer

In your table on your ID col why not used an Identity Specification, so every new record is ID + 1?

ASp.net employee id automatic generation using sql

Answers (9)