Auto Generated Code

[pratitripathi]

Hi ,
I'm having problem in generating auto generated Code whose format is 'PRM-0000' .And it should be incremented by one everytime when new Id is generated.the value will be stored in database.

Please Help me as soon as posible.

[giveDsolution]

SELECT ISNULL(MAX(Conv ert(int,SUBSTRI NG(Colname,4, LEN(Colname)))) , 0) + 1 FROM Tablename

This query will generate the next number...... Then add it to the

PRM-"- - -"

[pratitripathi]

I've witten my code in the following way:

Public Sub IDGenerate()

strparam = Left("PRM", 3) + "-000" + Convert.ToStrin g(rowaffected_i nt)
txtGenerateId.T ext = strparam
MsgBox("Generat ed Parameter Code is " & strparam, MsgBoxStyle.OkO nly, "Msg")
Return

End Sub

Public Sub Save()
Try

Dim str As String = "insert into GenerateID(ID,N ame) values('" & txtGenerateId.T ext & "','" & txtName.Text & "')"
sqlobj = obj.connect()
sqlobj.Open()
Dim insert As New Data.SqlClient. SqlCommand(str, sqlobj)
insert.Connecti on = sqlobj
MsgBox("Records Inserted", MsgBoxStyle.OkO nly, "Msg")
insert.ExecuteN onQuery()
sqlobj.Close()
Catch e As Exception
MsgBox("not inserted")
End Try
End Sub

Protected Sub Click_Click(ByV al sender As Object, ByVal e As System.EventArg s) Handles Click.Click
Call IDGenerate()
Call Save()
End Sub

but don't know how to increment it..

Please Help..