private void button6_Click(object sender, EventArgs e)
{
listBox2.Items.Clear();
NSMySQL.URL = "http://ehealth.asus.com/vivobaby/php/MySQLTool.php";
ArrayList tables = NSMySQL.GetTables("vivobaby");
foreach (String table in tables)
{
listBox2.Items.Add(table);
}
}
private void button7_Click(object sender, EventArgs e)
{
if (listBox2.SelectedIndex == -1)
{
MessageBox.Show("Please select a table");
return;
}
String dbname = "vivobaby";
String tablename = listBox2.SelectedItem.ToString();
NSMySQL.URL = "http://ehealth.asus.com/vivobaby/php/MySQLTool.php";
NSMySQLData data = NSMySQL.GetData(dbname, tablename, String.Format("SELECT * FROM {0}", tablename));
if (data.E.Message.Length > 0)
{
MessageBox.Show(data.E.Message);
return;
}
dataGridView1.ColumnCount = data.Columns.Count;
for (int i = 0; i < data.Columns.Count; i++)
{
dataGridView1.Columns[i].Name = (String)data.Columns[i];
}
dataGridView1.Rows.Clear();
foreach (Dictionary <String, String> dict in data.Datas)
{
ArrayList itemList = new ArrayList();
foreach (String title in data.Columns)
{
itemList.Add(dict[title]);
}
dataGridView1.Rows.Add(itemList.ToArray());
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
row.HeaderCell.Value = (row.Index + 1).ToString();
}
}
