Update.......

Expand Post »

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.

Similar Threads

PS3 firmware update on its way, admits PlayStation bigwig in Apple Rumors and Reports
Error 624: The system could not update the phone book file in Windows NT / 2000 / XP
Update Errors, help for a sec please? in Windows NT / 2000 / XP
update sql server data database in c# in C#
Update query with syntax error in PHP

mca.mdebnath

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Nov 2009

Permalink

Nov 4th, 2009

Re: Update.......

Write sql in the following way:

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.

mail2saion

Reputation Points: 26

Solved Threads: 44

Posting Whiz in Training

Offline

247 posts
since Apr 2009

Permalink

Nov 4th, 2009

Re: Update.......

Thanks a lot....................

mca.mdebnath

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Nov 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Print?

Next Thread in ASP.NET Forum Timeline: Help with insert statement

DaniWeb Message

Cancel Changes

User Name
Password