auto increment

[baccheekumar]

hi
this is niraj i am doing a code to auto increment the employee number on button click event in a text box ....can any one help me for that.
the format has to be in the form like. 001-08 where 001 is employee code and 08 is the year. and that should be in vb.net

[r035198x]

What have you done so far?

[baccheekumar]

What have you done so far?

on form load i have written the code as follows:
dim x as integer
cmd1 = New SqlCommand
cmd1.Connection = con
cmd1.CommandText = "select max(empno) from employee"
dr1 = cmd1.ExecuteReader
dr1.Read()
x = dr1.Item(0) + 1
dr1.Close()

and on button click :
txtno.Text = x
x = x + 1
but it increment the values like 1,2,3,4................like that

[Curtis Rutland]

OK, let me get this straight:
You want txtno.Text to contain something like 004-08, but x contains 4 right? You need to learn about string formatting. The link is for C#, but all of the concepts apply to VB.NET as well.