Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lotus
Starting Member
14 Posts |
 Posted - 2007-10-30 : 11:05:07
|
| I have project using C# & SQL Server ExpressI modifide the database to make primarykey of one table from uniqueidentifier into int with auto increase property.then when I enter New row in the table it dont give me the new Id , and when I go to save the new rowI have problem " Column 'Player_ID' does not allow nulls."when I don't give value to the primary Key, and i have problem "Cannot insert explicit value for identity column in table 'Player' when IDENTITY_INSERT is set to OFF."so I build new project and used the same this database and i don't have any proplem.so what I must do in the orginal project to work correctly?. please help me in nearest time I am waiting!!! |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 11:17:33
|
| Please generate a script for the DDL for the [broken] table and post it here so we can check it.Kristen |
 |
|
|
Lotus
Starting Member
14 Posts |
Posted - 2007-11-05 : 04:22:54
|
quote:
Originally posted by Kristen
Please generate a script for the DDL for the [broken] table and post it here so we can check it.Kristen
thank you Kristen and Iam sorry,I correct the problem ,by remove the dataset and the connection then i rebuild the project, and then I create the connection and dataset again ..the problem is endedthenk you again |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-05 : 04:57:59
|
| No problem, glad you got it sorted out. |
|
|
|
|
|
|
I have problem blease help me