Create maximum attempts For Login in asp.net

Hi Garav

Follow these steps
1. add a column "active" in your register table 
2.when a user register into ur site set this active column to true
3. in login button click

protect void btnlogin_Click()
{

if(viewstate["attempt"]==null)
{
viewstate["attempt"]=0;
}

  SqlDataAdapter da = new SqlDataAdapter("select * from registration where email=@email and password=@password", Con);

           

            DataSet dt = new DataSet();

            da.Fill(dt)

if( dt.Rows.Count>0 )
{
string status =dt.Rows[0]["active"].Tostring();
if(status=="true")
{
//redirect
}
else
{
// u r blocked msg
}

}
else
{
viestatte["attempt"]=Convert.ToInt32( viestatte["attempt"] )+1;
// login faild message
}
if( Convert.ToInt32( viestatte["attempt"] ) >3)
{
// write code to update the active column value to false
}


hope this will help u