ASp.net employee id automatic generation using sql

Question

Hi In my application i have empid columnin that id should come as max(empid)+1 from database automaticallymy 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 problemi 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 IncrementingHow can i overcome this problem? and iam using server side validations in Submit Buttonso 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 loadthis 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?