private void refreshAll() { if (connection.State == ConnectionState.Closed) { connection.Open(); } allContactsBox.Items.Clear(); foreach (IPInfo ip in IPInfo.GetIPInfo()) { //localIP = ip.IpAddress.ToString(); Console.WriteLine(ip.IPAddress.ToString()); if (ip.IPAddress.StartsWith(globalIPStarts)) // 192. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! { SqlCommand command1 = connection.CreateCommand(); //listBox2.Items.Add(ip.IPAddress); command1.CommandText = "SELECT name FROM users WHERE ip=@0 AND online='online'"; command1.Parameters.AddWithValue("@0", ip.IPAddress); string login = ""; try { login = command1.ExecuteScalar().ToString(); } catch (Exception ex) { } if (login != "") { allContactsBox.Items.Add(login); } } } connection.Close(); }
/// <summary> /// Retrieves the IPInfo for the machine on the local network with the specified MAC Address. /// </summary> /// <param name="macAddress">The MAC Address of the IPInfo to retrieve.</param> /// <returns></returns> public static IPInfo GetIPInfo(string macAddress) { var ipinfo = (from ip in IPInfo.GetIPInfo() where ip.MacAddress.ToLowerInvariant() == macAddress.ToLowerInvariant() select ip).FirstOrDefault(); return(ipinfo); }