Loading

primary key error

repkin05

At first I have to find a row and then I have to change it. So I use Rows.Find() method for finding specific row and then I set its 6. col with this code this.dSet.Tables[0].Rows.Find( txt1.text.Trim() )[5] = this.txt5.Text.Trim(); but it gave this error. An unhandled exception of type 'System.Data.MissingPrimaryKeyException' occurred in system.data.dll Additional information: Table doesn't have a primary key. But Tables[0] have primary key. Why it gave this error? pls help

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

hrungdak22y ago
Are you sure that you have got the primary key from the table (in the Select-Statement)? Is it a INNER JOIN? With some INNER JOINS a Update-Statement may not work.
Andrzej Wegierski22y ago
First: Should be, I think: this.dSet.Tables[0].Rows.Find( txt1.Text.Trim() )[5] = this.txt5.Text.Trim(); Are You sure that Tables[0] is thesame, which You want? Are You sure that Find() returns any row? Try to use object names instead numbers. It works slower but is better.