Using a SQL View

[Frank Py]

We have a SQL Database that uses DTS to import customer data from an
ODBC database into a few tables. We also have created a related table in
SQL from scratch. The ODBC data updates every half hour. We want the
customers to be able to update data from the Internet for just the SQL
table we created in SQL that has user data.

I was thinking about joining all the tables in a view and just giving
the Internet users access to change the non ODBC data columns in the
view. Is this possible? I knbow you can update data in a view, but can
ASP.Net use a view as a datasource? Help apprecaited. Thanks.

Frank


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows]

Frank Py wrote:

> I was thinking about joining all the tables in a view and just giving
> the Internet users access to change the non ODBC data columns in the
> view. Is this possible?

Yes, but you need to carefully read SQL Books Online to make sure you are
creating updatable views. There are some situations where multiple tables
are involved where updates will not be possible without an Instead Of
trigger (SQL 2000), so make sure you read the relevant sections in BOL.

>I knbow you can update data in a view, but can
> ASP.Net use a view as a datasource?

I'm sure it can, but you should ask on one of the dotnet groups to be sure.
(this group and .asp.general are classic asp groups)

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.