Can we replace data tables with stored procedures in ADO.NET? Explain with a small Example?

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.