Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. // query string opstellen
  2. string SQLstring = "SELECT DISTINCT Neighborid FROM `tiwat`.`Neighbors` WHERE Nodeid = (SELECT idNode FROM `tiwat`.`Node` WHERE Name = '" + Name + "')";
  3. MySqlCommand SQLCommand = new MySqlCommand(SQLstring, connection);
  4. MySqlDataReader reader = SQLCommand.ExecuteReader();
  5. reader.Exe
  6. list neighbors;
  7.  
  8. if (reader.Read())
  9. {
  10. SQLstring = "SELECT Name FROM `tiwat`.`Node` WHERE idNode = " + reader[0];
  11. while (reader.Read())
  12. {
  13. SQLstring += " OR idNode = " + reader[0];
  14. }
  15. }
  16.  
  17. reader.Close()
  18. SQLCommand = new MySqlCommand(SQLstring, connection);
  19. reader = SQLCommand.ExecuteReader();
  20.  
  21. while (reader.Read())
  22. {
  23. neighbors.add(reader[0]);
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement