469,336 Members | 5,980 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

ReadOnlyException while trying to update a subquery column using TableAdapter

Hi,

I've been struggling subqueries/joins and table adapters for some time and
can't find a clear answer.

I have a stored procedure that returns columns from 2 tables. Two columns
from the second table are returned by subquery. All this is done in a
stored procedure.

I also have a stored procedure that takes most of the params from the select
proc and updates both tables.

The problem is that columns from the second table (i.e. from a subquery)
seem to be read-only in the auto-generated table adapter.

I'm stuck and don't really know how to proceed. It seems like an extremely
simple thing to do outside of asp.net. Unfortunately I'm relatively new to
asp.net and not quite sure how to deal with it.

So, how do I pass parameters to the stored procedure that updates both
tables?

I'd appreciate _any_ suggestions.
Thanks,
Bogdan
Jun 27 '08 #1
3 1561
As a general rule you should not be updating queries that are results of
Join operation...
Instead issue UPDATE command yourself...

Actually that is how it works behind the scene anyway.

George.

"Bogdan" <Bo****@company.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
Hi,

I've been struggling subqueries/joins and table adapters for some time and
can't find a clear answer.

I have a stored procedure that returns columns from 2 tables. Two columns
from the second table are returned by subquery. All this is done in a
stored procedure.

I also have a stored procedure that takes most of the params from the
select proc and updates both tables.

The problem is that columns from the second table (i.e. from a subquery)
seem to be read-only in the auto-generated table adapter.

I'm stuck and don't really know how to proceed. It seems like an
extremely simple thing to do outside of asp.net. Unfortunately I'm
relatively new to asp.net and not quite sure how to deal with it.

So, how do I pass parameters to the stored procedure that updates both
tables?

I'd appreciate _any_ suggestions.
Thanks,
Bogdan


Jun 27 '08 #2
Thanks for the reply. Could you please explain what you meant by "issue
UPDATE command yourself..."?

Thanks,
Bogdan

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:Ob**************@TK2MSFTNGP05.phx.gbl...
As a general rule you should not be updating queries that are results of
Join operation...
Instead issue UPDATE command yourself...

Actually that is how it works behind the scene anyway.

George.

"Bogdan" <Bo****@company.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
>Hi,

I've been struggling subqueries/joins and table adapters for some time
and can't find a clear answer.

I have a stored procedure that returns columns from 2 tables. Two
columns from the second table are returned by subquery. All this is done
in a stored procedure.

I also have a stored procedure that takes most of the params from the
select proc and updates both tables.

The problem is that columns from the second table (i.e. from a subquery)
seem to be read-only in the auto-generated table adapter.

I'm stuck and don't really know how to proceed. It seems like an
extremely simple thing to do outside of asp.net. Unfortunately I'm
relatively new to asp.net and not quite sure how to deal with it.

So, how do I pass parameters to the stored procedure that updates both
tables?

I'd appreciate _any_ suggestions.
Thanks,
Bogdan



Jun 27 '08 #3
I mean if you need to update record in the database just do something like
(psedocode)
con.Execute("UPDATE table SET field1 = 10 WHERE id=5")

Something like that....

George.
"Bogdan" <Bo****@company.comwrote in message
news:O6**************@TK2MSFTNGP02.phx.gbl...
Thanks for the reply. Could you please explain what you meant by "issue
UPDATE command yourself..."?

Thanks,
Bogdan

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:Ob**************@TK2MSFTNGP05.phx.gbl...
>As a general rule you should not be updating queries that are results of
Join operation...
Instead issue UPDATE command yourself...

Actually that is how it works behind the scene anyway.

George.

"Bogdan" <Bo****@company.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
>>Hi,

I've been struggling subqueries/joins and table adapters for some time
and can't find a clear answer.

I have a stored procedure that returns columns from 2 tables. Two
columns from the second table are returned by subquery. All this is
done in a stored procedure.

I also have a stored procedure that takes most of the params from the
select proc and updates both tables.

The problem is that columns from the second table (i.e. from a subquery)
seem to be read-only in the auto-generated table adapter.

I'm stuck and don't really know how to proceed. It seems like an
extremely simple thing to do outside of asp.net. Unfortunately I'm
relatively new to asp.net and not quite sure how to deal with it.

So, how do I pass parameters to the stored procedure that updates both
tables?

I'd appreciate _any_ suggestions.
Thanks,
Bogdan




Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.