Select from one datasource update another
I am using Visual Web Developer to create a form updating my database.
Currently, I fill a gridview based on two drop down lists querying against
a view in my SQL 2008 database. This works fine, but I cannot update a
view directly, so what I need to do is update the main table that supports
the view. So here is the question(s). Can I have a select statement that
says
SELECT * FROM [vw_GridviewSource] WHERE (([Annotation Date] =
@Annotation_Date) AND ([Name] = @Name))
And have an update to another table?
Also can I somehow only allow the user to update certain fields and not
others? I have an instance where the "Annotation Number" is actually
generated by my client and should not be changed, but I do want them to be
able to update notes, business unit etc.
No comments:
Post a Comment