i want to retrieve values from database using stored procedure,compare those values to the parameter supplied in the query string...if the value retrieved from the database using stored procedure equals the parameter supplied in the query string an updation should take place and reflect that changes to my database.......


i have 2 columns named activated and user id in my database,using stored procedure user id should be retrieved and compare that value with parameter supplied in query string and if the comparison is successful an updation of column "activated" should be done......... how the whole thing gets done using stored procedure

There are some very good and easy to understand tutorials for what you want to do.

Here's a couple of tutorials on how to get your code to work with stored procedures.

http://www.c-sharpcorner.com/UploadF...procedure.aspx

http://support.microsoft.com/kb/306574

If you get any errors or have any other specific questions regarding what you are trying to do I'm sure there are many people here who would be glad to help you.

u should make procedure first in your database and then pass query string values as parameter to the procedure here is short syntax of procedure

create procedure pname
(
paramenter 1 datatype
paramenter 1 datatype
)
AS
BEGIN
DML STATEMENT
END

__________________
free web directory :yourowndir.com
seo service india : sbglobal.info