use this code for Authentication:
con.Open();
cmd = new SqlCommand("Select * from Registration where Email='"+Email+"' And Password='"+Pass+"'"), con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Session["UserId"] = dt.Rows[0]["UserId"].ToString();
return RedirectToAction("Index", "Dashboard");
}
else
{
return RedirectToAction("Index", "Login");
}
con.Close();