ASP.NET

protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
    {
        if (CheckAuthenticate(Login1.UserName, Login1.Password))
        {
            Session["Username"] = Login1.UserName;
            Session["Password"] = Login1.Password;
            Session["Authentication"] = "1";
            //---- Create cookies
            if (Login1.RememberMeSet)
            {                
                Response.Cookies["AuthenCookies"]["User"] = Login1.UserName;                
                Response.Cookies["AuthenCookies"].Expires = DateTime.Now.AddMonths(1);           
            }
            e.Authenticated = true;
            
            FormsAuthentication.RedirectFromLoginPage((string)Session["Username"]
                                                    , false);
           
        }
        else
        {
            Session["Authentication"] = "0";
            e.Authenticated = false;
        }
        
    }

protected void Page_Load(object sender, EventArgs e)
    {
        //---- No cache : prevent user access previous page after logged out
        Response.Cache.SetCacheability(HttpCacheability.NoCache);

        //Clear Session
        Session["Username"] = null;
        Session["Password"] = null;
        Session["Authentication"] = null;       
        Session.Abandon();

        FormsAuthentication.SignOut();
        FormsAuthentication.RedirectToLoginPage();
        
    }

Response.Cache.SetCacheability(HttpCacheability.NoCache);

//------- Check Authentication
string LoginPass = (string)Session["Authentication"];
if (LoginPass == "0" || LoginPass == null)
    Response.Redirect("LogIn.aspx");
//-------------------------------

CREATE FUNCTION [dbo].[waste] ()  <br />
RETURNS table<br />
<br />
AS  <br />
declare @a int<br />
declare @b int<br />
BEGIN <br />
	declare cur cursor for select a1,a2 from a<br />
	open cur<br />
	fetch next from a into @a,@b<br />
	while @@FETCH_STATUS =0<br />
		BEGIN<br />
			SELECT @a as a1 , @b as a2<br />
			fetch next from a into @a , @b<br />
		END<br />
	close cur<br />
	deallocate cur<br />
	return<br />
END