To use a DataReader, you have to tell it to read each line at a time:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT RoleName FROM tblRoles", con))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string roleName = (string) reader["RoleName"];
Console.WriteLine(roleName);
}
}
}
}