yes, we can change the datatables with stored procedures.

if we want to cahnge the password in any website login page we can write stored procedure for that

ex:

create procedure changepassword(@ userid 1varchar(20),@pwd 1varchar(20))

as

begin

update table

set pwd=@ pwd1 where userid=@ userid1

end

we can write the procedure name in command object of ado.net using parameters. we can cahnge pwd.