delete primary key
-
i have a table EmployeeInfo in sql 2000 that have two attributes say EmpID & EmpName i am displaying the EmpName only in a datagridview but when i delete it it give error that cannot delete the key blah blah so how to delete the whole row from sql2000 please note that i am only displaying the EmpName in the data grid sas
-
i have a table EmployeeInfo in sql 2000 that have two attributes say EmpID & EmpName i am displaying the EmpName only in a datagridview but when i delete it it give error that cannot delete the key blah blah so how to delete the whole row from sql2000 please note that i am only displaying the EmpName in the data grid sas
There should be a property of the DataGrid called DataKeyField. Try setting this to the employee id and see if that works.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway