By Default, the property "Auto Generated Value" is not set, changing this fixes your problem. More info can be found here .
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
Nick Kusters
on
12-20-2007, 12:00 AM
Filed under: SQL Server 2005, Microsoft SQL Server 2005, .NET SQL Server 2005, insert, Database, Default value, SQL 2005 ASP.NET, ADO.NET, Primary Key, sql 2005, Linq, slq 2005, MSSQL, Sql 2005 .NET, error, SQLServer, SQL 2005 Design, sql 2005 DBNull null value types, Database design, sqlserver 2005, New ID, .net 3.5, "SQL Server", language, error messages