Comments by Davidemazzuuu (Top 1 by date)

Thanks. In class UserData i have method GetList and Login. is right?

<pre lang="c#">public List<user> GetList()
{
List<user> lst = new List<user>();

using (SqlConnection conn = new SqlConnection(Data.GetConn()))
{
using (SqlCommand cmd = conn.CreateCommand())
{
if (conn.State == ConnectionState.Closed)
conn.Open();

cmd.CommandText = "select UserID,Name from Users";
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
User item = new User()
{
UserID = Convert.ToInt32(rdr["UserID"]),
Name = rdr["Name"].ToString(),
};

lst.Add(item);
}
}
}
}

return lst;

public Boolean DoLogin(string email, string password)
{
}
}</pre>


<pre lang="c#">//For write a list
UserData userD = new UserData();

List<user> itemsU = new List<user>();


itemsU = userD.GetList();


foreach (User itemU in itemsU)
{
Response.Write(itemU.Name);
}
//For login
Boolean aut=0;
aut = userD.DoLogin(Email.Text, Password.Text);
if (aut)
{
}

</pre>