Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

SQL Server DataGridView - Automatic update of Keys

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?
0
symman
Asked:
symman
1 Solution
 
symmanAuthor Commented:
I did find the following article and had good luck by starting with a fresh form and table after setting identity values in SQLServer.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22497641.html?sfQueryTermInfo=1+ident+sql
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now