SQL Server DataGridView - Automatic update of Keys

Posted on 2009-02-09
Last Modified: 2013-11-26
Hi Everyone,
I'm movingi from a VB.NET DataGridView based application, supported by  MS ACCESS to the same structure supported by SQLServer 2005 (Developer).

I've had pretty good luck so far but am running into a snag when adding or deleting records via the navigation tool bar.

When pointing at ACCESS, the system seems to know how to update the keys in the underlying table.  When pointing at SQL Server, the system doesn't seem to know how to automatically update the keys.   I'm in the guess and test mode now.  Any ideas?
Question by:symman
    1 Comment

    Accepted Solution

    I did find the following article and had good luck by starting with a fresh form and table after setting identity values in SQLServer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    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

    9 Experts available now in Live!

    Get 1:1 Help Now