public static DataTable EdgeGen(DB_Manager dbm, DataTable Vertex, String first, String second) { DataTable group = dbm.mysql_query(String.Format("SELECT {0},{1} FROM networkvis.allinone GROUP BY {2};", first, second, first)); DataTable result = new DataTable(); result.Columns.Add("FromID", typeof(int)); result.Columns.Add("ToID", typeof(int)); for (int id = 0; id < group.Rows.Count;id++) { DataRow row = group.Rows[id]; String Content = row[second].ToString(); for (int id2 = 0; id2 < id; id2++) { DataRow data = group.Rows[id2]; //Console.WriteLine(data[second].ToString() + " " + Content); if (Content.Equals(data[second].ToString())) { DataRow edge = result.NewRow(); edge["FromID"] = id; edge["ToID"] = id2; result.Rows.Add(edge); break; } } } return result; }
public PreviewVertex(DB_Manager dbm) { String[] fields = dbm.list_post_schema(); list_set = new ListViewItem[fields.Length]; for (int i = 0; i < fields.Length; i++) { list_set[i] = new ListViewItem(fields[i], 0); append(dbm.mysql_query(String.Format("select {0} from networkvis.allinone WHERE ({1} is not null and {2} != '') limit 10", fields[i], fields[i], fields[i]))); } list_set[0].Selected = true; }
private void button1_Click(object sender, EventArgs e) { DB_Manager db = new DB_Manager("networkvis"); DataTable dt = db.mysql_query(String.Format("SELECT DISTINCT NetworkID FROM networkvis.nodes WHERE NetworkID = '{0}'", textBox1.Text)); if (dt.Rows.Count > 0) { return; } else { this.Close(); inputGet(this, new statusEventHandler(1, textBox1.Text)); } }