SQL procedure error?

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.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!