I'm using C# in VS.NET and SQL Server 2000. For some reason, when I try to update via datagrid through dataset, data adapter, the database creates new records with the update rather than updates the one I want to.
For example: CategoryID CategoryName
original: 5 NewCategory
update to: 5 NewTitle

result: 5 NewCategory
6 NewTitle

SQL procedure:
update category set CategoryName=@CategoryName where CategoryID=@CategoryID


Any suggestions would help.