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!

Categories