sql.CommandText = "SELECT name FROM users"; read = sql.ExecuteReader(); while (read.Read()) { Response.Write(read["name"].ToString()); }