private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select Content from Data where Category = '" + comboBox2.Text + "' and Item = '" + comboBox3.Text + "'";
DataTable dt = SqliteDB.SqlTable(sql);
richTextBox3.Text = dt.Rows[0][0].ToString();
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedTab.Name == "show")
{
string sql = "select * from Data";
DataTable dt = SqliteDB.SqlTable(sql);
FillTreeView(dt, treeView1);
richTextBox1.Text = "";
}
else if (tabControl1.SelectedTab.Name == "add")
{
string sql = "select distinct Category from Data";
DataTable dt = SqliteDB.SqlTable(sql);
FillComboBox(dt, comboBox1, "Category");
comboBox1.Text = "";
textBox1.Text = "";
richTextBox2.Text = "";
}
else
{
string sql = "select distinct Category from Data";
DataTable dt = SqliteDB.SqlTable(sql);
FillComboBox(dt, comboBox2, "Category");
comboBox2.Text = "";
comboBox3.Items.Clear();
comboBox3.Text = "";
richTextBox3.Text = "";
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select Item from Data where Category = '" + comboBox2.Text + "'";
DataTable dt = SqliteDB.SqlTable(sql);
FillComboBox(dt, comboBox3, "Item");
comboBox3.Text = "";
}
private void Form1_Load(object sender, EventArgs e)
{
string sql = "select * from Data";
DataTable dt = SqliteDB.SqlTable(sql);
if (dt == null)
{
return;
}
FillTreeView(dt, treeView1);
}
private void treeView1_DoubleClick(object sender, EventArgs e)
{
string Name = treeView1.SelectedNode.Name;
string Text = treeView1.SelectedNode.Text;
if (Name == "root")
{
return;
}
string PreText = treeView1.SelectedNode.Parent.Text;
string sql = "select Content from Data where Category = '" + PreText + "' and Item = '" + Text + "'";
DataTable dt = SqliteDB.SqlTable(sql);
richTextBox1.Text = dt.Rows[0][0].ToString();
}
