how to update recently inserted value

Question

0.00/5 (No votes)

See more:

, +

hi
i have 3 table in my sql database

1.Userinfo
UserID int
UserLoginName varchar
password varchar

2.BankMaster
BankID int
UserID int
BankName varchar
Branchname varchar
AccountNo int
minBalance int

3.Deposite
DepositeID int
bankID int
Amount int
ClosingBalance int

I have written query in aspx.cs page

protected void btnModify_Click(object sender, EventArgs e)

C#

String s = "update BankMaster 
                
           set MinBalance=Deposit.ClosingBalance                  
               
            from BankMaster,Deposit,Userinfo 
               
            where BankMaster.BankID=Deposit.BankID and 
               Userinfo.Loginname='" + Session["uname"] + "'";

my task is update BankMaster table minBalance from the table Deposit according to the which particular user login
this above query is updating but i want recently inserted value should update to the particular user login how to do this help me for this

thanks in advance

Posted 12-Apr-11 23:20pm

Akshatha.A

Updated 12-Apr-11 23:24pm

m@dhu

v2

Add a Solution

Comments

Pong D. Panda 13-Apr-11 5:44am

ARRRGH! I cant understand what do you want to accomplish here. Can you further elaborate? You mean the script is working but it updates records not only for the user that is currently logged in?

Akshatha.A 13-Apr-11 5:49am

yes its working but agai when user deposite it update the previous value rather than the currently inserted value

Pong D. Panda 13-Apr-11 6:01am

can you provide a sample data?

2 solutions

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)

Ankit Rajput · Answer 1 · 2011-04-13T01:45:00

Solution 2

Hi,

For this purpose you need to use transactions or Stored Procedures.

Within that You can use Scope_Identity() to get the latest inserted identity in the current transaction.

Now you have the currently inserted ID so you can do whatever you want to do.

Regards
Ankit

Posted 13-Apr-11 1:45am

Ankit Rajput

Prasanta_Prince · Answer 2 · 2011-04-13T00:03:00

Solution 1

by using,-
select * from TableName where ID=@@Identity

After that you will get the current Inserted Row.

Posted 13-Apr-11 0:03am

Prasanta_Prince

Comments

Akshatha.A 13-Apr-11 6:17am

when i use @@identity its inserting twice and increasing the id by 1