|Look at your query:
You have two
select * from login where userid=@userid, password=@password, confirmpassword=@confirmpassword where loginid=@loginid is same
where clauses, which is not valid. And as far as I can see, that
is same on the end is also not valid. And putting a comma between conditions is also not valid - you need to use
Aside from that, you have four parameters:
Now look at the parameters you are passing to the command:
You are passing TWO parameters:
Either fix you query to use the parameters you are passing, or fix your code to pass the parameters required by the query.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."