February 10th, 2005, 01:02 AM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 1
Time spent in forums: 12 m 14 sec
Reputation Power: 0
|
|
|
Exception: Primary key information is not present
AoA Dears,
i m having a problem with inserting value in SQL Server 2000 through C# Code
the table in which i m going to insert values have a composite primary key(combination of 4 DataColumns)
when i load DataSet, i set these four DataColumns as primary key using following C# code
DataColumn[] keys = new DataColumn[4];
keys[0] = dsRole.Tables["SECURITY_GROUP_ROLES"].Columns["GROUP_ID"];
keys[1] = dsRole.Tables["SECURITY_GROUP_ROLES"].Columns["ROLE_TYPE"];
keys[2] = dsRole.Tables["SECURITY_GROUP_ROLES"].Columns["CATEGORY_ID"];
keys[3] = dsRole.Tables["SECURITY_GROUP_ROLES"].Columns["FORUM_ID"];
dsRole.Tables["SECURITY_GROUP_ROLES"].PrimaryKey = keys;
when i update existing record in this table, it works fine. but when i insert new record in this table, it gives an error at Updateing DataSet that
[SqlServerCommandBuilder] ConcreteGetInsertCommand()Primary key information is not present
i have already set primay key but why its giving this error
Can any body tell me the solution of this problem
One point more. DataTable that have a single column as primary key, are working fine. But having composite key is not working fine
waiting for ur urgent reply
Thanks in advance
Maqsood Ahmad
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
