updating last row of sql database table from c# asp.net page

Question

3.00/5 (2 votes)

See more:

C#

hi guys
m trying to update sql table which has highest id.......can somebody help me.

Posted 16-Apr-11 18:52pm

punk123

Add a Solution

Comments

dan!sh 17-Apr-11 1:08am

Where exactly are you stuck?

Sandeep Mewara 17-Apr-11 1:23am

trying to update sql table which has highest id.
Can you elaborate your scenario?

R. Giskard Reventlov 17-Apr-11 11:02am

Why all the 1 votes and where is the question worthy of a 5?

5 solutions

Solution 4

UPDATE table_name 

SET cloumn_name = "Value"

WHERE id = (SELECT id FROM table_name ORDER BY id LIMIT 1,1)

Posted 16-Apr-11 21:51pm

usernametakenalready

Solution 5

UPDATE Table_Name SET Column_Name = 'Column_Value' WHERE ID = @@Identity

Posted 17-Apr-11 5:55am

Prasanta_Prince

Solution 1

Something along the lines of this:

update [table]
set [column1] = @Param
where id = (select max(id) from [table])

Posted 16-Apr-11 20:15pm

R. Giskard Reventlov

Solution 2

I guess this is what you are expecting, but you could also elaborate your question for more help. This is assuming MAX operation works on ID column, i.e. one possibility is ID is an integer.

UPDATE Table_Name SET Column_Name = 'Column_Value' WHERE ID = (SELECT MAX(ID) FROM Table_Name)

Posted 16-Apr-11 20:18pm

Karthik. A

v2

Comments

punk123 21-Apr-11 4:11am

it is showing error "near ID"

punk123 21-Apr-11 4:13am

ya ID is integer.......

punk123 21-Apr-11 4:56am

thanks buddy..................

Member 12594268 23-Jun-16 6:47am

This work! SUPERB ANSWER.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-04-16T20:20:00

Assuming you use a numeric ID system, the following should work:

SQL

UPDATE myTable SET myField='NewValue' WHERE iD= (SELECT MAX(iD) FROM myTable)

However, be aware that if this is multi-user system, you do not know what record you are updating.

If you want to use this to update the record you recently created, that may not happen!