Problem in updating multiple rows of a single column of a single table using Update Command from C#

[C# Programming]

Hi

My problem is that i have a column Position in my database. when i try to update this column by assinging different values at the same time using update command only one row is updated.my front end is C# and back end is MS SQL Server 2000 personal edition. plz let me know that how we can update multiple rows of a single column at the same time by assinging different values.

Thanks

Usman Ahmad