SQL procedure error? - Programmers Heaven

Howdy, Stranger!

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

Categories

SQL procedure error?

bruce_waynebruce_wayne Posts: 3Member
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.