ASP.NET

Update.......

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2009

Posts: 5

Reputation: mca.mdebnath is an unknown quantity at this point

Solved Threads: 0

mca.mdebnath mca.mdebnath is offline

Offline

Newbie Poster

Update.......

Nov 3rd, 2009

plz help me ,i have to update a table "temp" where a temp_id is dyanamically change by 1 everytime and there are another table "Master" which contains id(int) and user_id(varchar). User_id is like 'FMS00' and the temp_id is dynamicaly change using code ..... and store into 'id' also and the user_id is changed to FMS001 , FMS002 and so on...

This has to be done using ASP.NET using C#.

Plz give me some coding for that.

•

Join Date: Apr 2009

Posts: 229

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 36

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Nov 4th, 2009

Write sql in the following way:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
SELECT MAX(CONVERT(INT,RIGHT(user_id,3)))+1 from master
SELECT MAX(CONVERT(INT,RIGHT(user_id,3)))+1 from master

Will give you the incremented number Now pad FMS & 0 if required by using length of your max func return value.