|
public mysql_query ( string sql ) : |
||
| sql | string | |
| return | ||
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));
}
}