Error in Auto increment ID in C#?

Sakthis

I am success while increment the id 1 to 10 after that it can't increment, i mean after the 10 while i increment the id it comes 10 only again and again and stored multiple 10 in sql table? i dont know how to resolve it can anyone?

Here enclosed my code :

private void btnAutoID_Click(object sender, EventArgs e)

{

SqlConnection sqlcon = new SqlConnection("Data Source=sakthi\\sqlexpress; Initial Catalog=LoginDetails; Integrated Security=True;");

SqlCommand sqlcmd = new SqlCommand("select isnull(max(empcode), 0) from emp", sqlcon);

{

sqlcon.Open();

object obj = sqlcmd.ExecuteScalar();

sqlcon.Close();

txtEmpCode.Text = (int.Parse(obj.ToString()) + 1).ToString();

}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
Accepted answer
ok

try
private void btnAutoID_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection("Data Source=sakthi\\sqlexpress; Initial Catalog=LoginDetails; Integrated Security=True;");
SqlCommand sqlcmd = new SqlCommand("select isnull(max(Cast(empcode as int)), 0) + 1 from emp", sqlcon);
{
sqlcon.Open();
object obj = sqlcmd.ExecuteScalar();
sqlcon.Close();
txtEmpCode.Text = obj.ToString();
}
}
hope this will help you.
0
Sakthis13y ago
Come on Buddy.. thats work fine.. thanks buddy..
0
Sakthis13y ago
Varchar
0
Jignesh Trivedi13y ago
what is data type of empcode field?
0
Sakthis13y ago
No, i work out but same problem like 10's again..
0
Jignesh Trivedi13y ago
hi,

your code look ok. this can also achieve with in query.....
try

private void btnAutoID_Click(object sender, EventArgs e)
        {
            SqlConnection sqlcon = new SqlConnection("Data Source=sakthi\\sqlexpress; Initial Catalog=LoginDetails; Integrated Security=True;");
            SqlCommand sqlcmd = new SqlCommand("select isnull(max(empcode), 0) + 1 from emp", sqlcon);
            {
                sqlcon.Open();
                object obj = sqlcmd.ExecuteScalar();
                sqlcon.Close();
                txtEmpCode.Text = obj.ToString();
            }
        }
hope this will help you.
0