How to update a view with two detail table

  • Thread starter Thread starter ad
  • Start date Start date
A

ad

I have a view, it is create by one primary table and two detail tables, like

SELECT St.GuyID,
WH.Weight,WH.Height,
Sight.SightL, Sight.SightR
FROM St,WH, Sight where
WH.GuyID = St.GuyID and Sight.GuyID = St.GuyID

I was use this select statement in a SqlDataSource.
How can I write the update statement for it?
 
Ad,

That is very much dependend what you do with this select.

If you use it in a datareader than you will have to use another way of
updating than that it is with a datatable dataadapter.

In any case wizards will not help you and you have to find that out
yourself, because what is created is as you showed a joined view and not a
kind of regular updatable datatable.

I would not know how to update a view in a datatable to datatables in a
database, however if that is what you want, than maybe you can tell this.
You never know who has done this (often is told here that it is impossible
by the way).

It does not help much, however maybe can you declare how you use it.

Cor
 
Back
Top