Windows Forms updating Views?

Posted on 2011-10-25
Last Modified: 2012-05-12
I am a complete novice to Visual Studio 2010/SQL Server 2008, after migrating from Microsoft Access.

Currently we are using SQL server as the backend, with 2 different Access frontends, one for the Manager, the other for the Engineers.

We have a form Called frmJobReports, which has a subform called frmJobReportsSub

The frmJobReports is the detail of the Job, the subform frmJobReportsSub is basically the worksheet for that Job, which could be assigned to multiple engineers.

The Manager inputs the job detail onto the main form and then assigns the Jobs to the engineers using the subform.

The engineers received “their” Jobs based on a View created in SQL which uses the tblJobReports and tblJobReportsSub (the sub is used to filter the records to the logged-in engineer (from terminal services login)).

We want to allow the engineers to update the main form, which is possible in Access, but in Visual studio Windows Forms, this does not seem possible? I gather Views cannot be updated.

Is there a way around this? Many thanks in anticipation.
Question by:SparkyP
    LVL 28

    Expert Comment

    Views in SQL can be updated under certain conditions. You can find those details here:

    Author Comment

    I have read the article and still cannot understand why I cannot get the Update, Insert or Delete Statements in the the TableAdaptor configuration Wizard for the View (which combines the main table and the subtable). Yet I can get all those statements when I run the wizard on the individual tables.
    LVL 83

    Accepted Solution

    I think you may have to write queries yourself as the view combines multiple tables


    Author Closing Comment

    This was just what I needed. Not easy for me, but have learned a great deal.

    Many Thanks
    LVL 83

    Expert Comment

    Glad to help :-)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
    Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now