Read last entered alphanumeric id from database

Question

i want to read last entered alphanumeric ID from database and add one to its numeric part.

sandhya Patel · Answer

Thank you ....

Vulpes · Answer

For SQL Server the code would be something like this: string id = "TPIFP0001"; SqlConnection conn = new SqlConnection(connectionString); SqlCommand comm = new SqlCommand(); comm.CommandText = "select top 1 * from SomeTable order by GatepsNO desc"; comm.Connection = conn; conn.Open(); SqlDataReader reader = comm.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { id = reader["GatepsNO"].ToString(); int number = int.Parse(id.Substring(5)); id = "TPIFP" + (number + 1).ToString("D4"); } } reader.Close(); conn.Close();

Sivaraman Dhamodaran · Answer

TPIFP 0001 ToDo: 1) Take left of the string counting 5 through sub-string manipulation 2) Take Right of the String counting 5, and convert this as number, add 1, convert back to string. 3) Join left and right Since I do not what DB you are using, I gave the Idea like above

sandhya Patel · Answer

column name is GatepsNO value is like TPIFP0001 first time i entered it through insert cmnt. from 2nd onwards i want to read it from table and increment by1

Sivaraman Dhamodaran · Answer

Show some sample data. What is column Name? How the data is formatted? This is just to know where numeric part comes in your alphanumeric data. Say for example, Column Name: Vehicle_Reg_No. Data: TN 52 -CJ6656 TN 52 -CJ6657 TN 52 -CJ6658 In the above case you want to increment last portion of Number. Like the above example, Can you please provide your data. This will help you in getting the answer.

Read last entered alphanumeric id from database

Answers (5)