primary key error

Question

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

hrungdak · Answer

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 Wegierski · Answer

First: Should be I think: this.dSet.Tables[0].Rows.Find( txt1. T ext.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.