login and regsitration using stored proedure

[peerraghu]

Hi i want to create login and registration button in web page, by creating a stored procedure in sql server, just help me how to create those procedure and how can i give parameters to the login button

thank you
raghu

[dip_developer]

Hi i want to create login and registration button in web page, by creating a stored procedure in sql server, just help me how to create those procedure and how can i give parameters to the login button

thank you
raghu

a simple stored procedure will look like..........

 
CREATE PROCEDURE sp_UserValidation
(
@Username varchar(50),
@UserPassword varchar(10)
) 
AS
IF EXISTS (SELECT UserName FROM tblLogIn WHERE UserName=@Username and UserPassword=@UserPassword)
BEGIN
return 1
END
ELSE
BEGIN
return 0
END
GO
 

call a function like the following to validate the user...pass the Username and Password to the function.................code is in C#......

 
public int UserValidation(string uname,string pass)
{
int retVal=0;
cmdTrans = new SqlCommand();
cmdTrans.Connection = myConnection;
cmdTrans.CommandType = CommandType.StoredProcedure;
cmdTrans.CommandText="sp_UserValidation";
SqlParameter param1=new SqlParameter("@Username",SqlDbType.VarChar,50);
param1.Value=uname;
SqlParameter param2=new SqlParameter("@UserPassword",SqlDbType.VarChar,10);
param2.Value=pass;
SqlParameter param3=new SqlParameter("@Return",SqlDbType.Int,4);
param3.Direction=ParameterDirection.ReturnValue;
cmdTrans.Parameters.Add(param1);
cmdTrans.Parameters.Add(param2); 
cmdTrans.Parameters.Add(param3);
cmdTrans.ExecuteNonQuery();
retVal = (int) param3.Value;
if (!(myConnection == null)) 
{
myConnection.Close();
}
return retVal;
}

if the user is valid then the function UserValidation() will return 1

hope it will help you.......

[peerraghu]

thank a lot ,I made through you code

[peerraghu]

hi dip
i created the login information in my website but if want to update the profile of paticular login member what r the process just send me sample codding

thank you in advance

[kenobewan]

A better stored procedure will look like..........

 
CREATE PROCEDURE usp_UserValidation
(
@Username varchar(50),
@UserPassword varchar(10)
) 
AS
set nocount on
IF EXISTS (SELECT UserName FROM tblLogIn WHERE UserName=@Username and UserPassword=@UserPassword)
BEGIN
return 1
END
ELSE
BEGIN
return 0
END
GO
 

The value 1 or 0 is returned and I do not see how it is used. Also a try/catch block would be better in case of errors.

Suggest peerraghu you start writing your own code if you want to learn.