According to me you should use Data reader.
It is easy to handle and fast access
Sample Code :
SqlDataReader dr = login.Get_DataReader("select *from users where uname = '" + txtunm.Text + "'");
try
{
dr.Read();
if (dr["block"].ToString() == "n")
{
if (txtpass.Text == dr["pwd"].ToString())
{
Session["unm"] = dr["Name"];
Session["UId"] = dr["UId"];
Response.Redirect("home.aspx");
}
else
{
lblerr.Text = "Invalid Username or password !!";
}
}
else
{
lblerr.Text = "You are Blocked By iTPO team, Contact T&P Cell";
}
All the Best