[RESOLVED] Insert, update and delete by datagridview

[newpat]

Hello everyone,
I am using vs 2005 and MYSQL .NET CONNECTOR, not I have a dataset.xsd and create a tableadapter in it.
here is an update query

UPDATE        emp
SET                  empNo = ?empNo, eName = ?eName, password = ?password, 
                          position = ?position, pwd_expire = ?pwd_expire, lastLogin = ?lastLogin

when I try to update the first column of value as the following pic, the exception come out!

Duplicate entry '0000000001' for key 'PRIMARY'




Can any tell me what is wrong with my query?

[nmadd]

Aren't you missing a WHERE clause in your query? Here is the documentation on MySQL's UPDATE.

[newpat]

Thx nmadd, I think it is.

Should the code be this way?

UPDATE        emp
SET                  empNo = ?empNo, eName = ?eName, password = ?password, 
                          position = ?position, pwd_expire = ?pwd_expire, lastLogin = ?lastLogin
WHERE         (emoNo = ?empNo)

But how do I get the column that I have been corrected it?

I have an emp table:
Me.SlmcDataSet1.emp.empNoColumn

[nmadd]

Sorry, I'm not sure I understand your question nor do I have experience in MySQL. But the documentation linked to above says this about what UPDATE returns:

UPDATE returns the number of rows that were actually changed. 
The mysql_info() C API function returns the number of rows that were matched 
and updated and the number of warnings that occurred during the UPDATE.

Good luck.