How to update rows in a gridview by joining two tables

Question

0.00/5 (No votes)

See more:

UPDATE Admin_Branch set BranchName=@BranchName where BranchCode=@BranchCode

UPDATE Admin_Tier set TierName=@TierName where TierCode=@TierCode

How can I join these two update statement into one.I want to use these in a gridview to update rows. thanks

Posted 8-Apr-13 23:03pm

babli3

Add a Solution

Comments

satheshjan 9-Apr-13 5:17am

is there any common field for two tables

babli3 9-Apr-13 6:10am

yes ,there is TierCode common in both

satheshjan 9-Apr-13 6:21am

May be it ll correct...try

babli3 9-Apr-13 6:31am

Thanks a lot but I am getting this error. Please help

System.Data.SqlClient.SqlException: Incorrect syntax near ','.

Thanks

satheshjan 9-Apr-13 6:35am

Try to copy the query from here and run it in SQL Server Management Studio. It will give you an idea on what syntax is incorrect.

babli3 9-Apr-13 6:39am

i did run on sql server the errror is on update a,b . Thanks

4 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)

satheshjan · Answer 1 · 2013-04-09T00:18:00

Solution 2

update a,b set a.BranchName=@BranchName ,b.TierName=@TierName from Admin_Branch a inner join
Admin_Tier b on a.commonclunname=b.commonclunname where a.BranchCode=@BranchCode and b.TierCode=@TierCode

Posted 9-Apr-13 0:18am

satheshjan

satheshjan · Answer 2 · 2013-04-09T01:16:00

Solution 3

other wise u can do it in single qtype only

UPDATE Admin_Branch
SET a..BranchName=@BranchName
FROM Admin_Branch a, Admin_Tier b
WHERE a.BranchCode=@BranchCode
and b.TierCode=@TierCode

UPDATE Admin_Tier
SET b.TierName=@TierName
FROM Admin_Branch a, Admin_Tier b
WHERE a.BranchCode=@BranchCode
and b.TierCode=@TierCode
try this may be correct

Posted 9-Apr-13 1:16am

satheshjan

Comments

babli3 9-Apr-13 7:48am

I already tried the single querty and its working fine.
But problem is i am placing this update command in Gridview for updating rows
and i cant keep two update commands together .
so i wanted to join these two tables and update

satheshjan 9-Apr-13 7:52am

i think it's not possible ...but i ll try to resolve and ll send u

babli3 9-Apr-13 7:58am

Thank you so much for your help

satheshjan 9-Apr-13 8:00am

its ok...No problem

satheshjan · Answer 3 · 2013-04-09T01:49:00

Solution 4

DECLARE @MyTable TABLE (id int);
BEGIN TRANSACTION
UPDATE Table1
SET Table1.Name = 'Test'
OUTPUT INSERTED.id INTO @MyTable
WHERE T1.field = 'Your Value';
UPDATE Table2
SET Table2.YourColumnName = 'Your Value'
FROM Table2
JOIN @MyTable m on m.id = Table2.id;

COMMIT;

Posted 9-Apr-13 1:49am

satheshjan

Rekhash · Answer 4 · 2013-04-09T03:01:00

Solution 5

http://forums.asp.net/t/1875587.aspx/1?GridView+record+update+help+needed[^]

Posted 9-Apr-13 3:01am

Rekhash