Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // query string opstellen
- string SQLstring = "SELECT DISTINCT Neighborid FROM `tiwat`.`Neighbors` WHERE Nodeid = (SELECT idNode FROM `tiwat`.`Node` WHERE Name = '" + Name + "')";
- MySqlCommand SQLCommand = new MySqlCommand(SQLstring, connection);
- MySqlDataReader reader = SQLCommand.ExecuteReader();
- reader.Exe
- list neighbors;
- if (reader.Read())
- {
- SQLstring = "SELECT Name FROM `tiwat`.`Node` WHERE idNode = " + reader[0];
- while (reader.Read())
- {
- SQLstring += " OR idNode = " + reader[0];
- }
- }
- reader.Close()
- SQLCommand = new MySqlCommand(SQLstring, connection);
- reader = SQLCommand.ExecuteReader();
- while (reader.Read())
- {
- neighbors.add(reader[0]);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement