//初始化表格
testItemsDataSet.Tables.Clear();
testItemsDataSet.Tables.Add();
testItemsDataSet.Tables[0].Columns.Add("ACU");
testItemsDataSet.Tables[0].Columns.Add("Test Name");
testItemsDataSet.Tables[0].Columns.Add("Note");
//填充数据
for (int i = 0; i < treeTestItems.Nodes.Count; i++)
{
testItemsDataSet.Tables[0].Rows.Add(treeTestItems.Nodes[i].Text.Substring(0, 6), "", "");
for (int j = 0; j < treeTestItems.Nodes[i].Nodes.Count; j++) testItemsDataSet.Tables[0].Rows.Add("", treeTestItems.Nodes[i].Nodes[j].Text, "");
}
//清空数据库
access.ExecuteSQLNonquery("DELETE FROM testList");
//插入数据
for (int i = 0; i < testItemsDataSet.Tables[0].Rows.Count; i++)
{
string SQLstr = "INSERT INTO testList ([Number], TestName, [Note]) VALUES ('" +
testItemsDataSet.Tables[0].Rows[i].ItemArray[0].ToString() + "','" +
testItemsDataSet.Tables[0].Rows[i].ItemArray[1].ToString() + "','" +
testItemsDataSet.Tables[0].Rows[i].ItemArray[2].ToString() + "'" + ")";
access.ExecuteSQLNonquery(SQLstr);
}
testItemsDataSet.Tables.Clear();
testItemsDataSet.Tables.Add();
testItemsDataSet.Tables[0].Columns.Add("ACU");
testItemsDataSet.Tables[0].Columns.Add("Test Name");
testItemsDataSet.Tables[0].Columns.Add("Note");
//填充数据
for (int i = 0; i < treeTestItems.Nodes.Count; i++)
{
testItemsDataSet.Tables[0].Rows.Add(treeTestItems.Nodes[i].Text.Substring(0, 6), "", "");
for (int j = 0; j < treeTestItems.Nodes[i].Nodes.Count; j++) testItemsDataSet.Tables[0].Rows.Add("", treeTestItems.Nodes[i].Nodes[j].Text, "");
}
//清空数据库
access.ExecuteSQLNonquery("DELETE FROM testList");
//插入数据
for (int i = 0; i < testItemsDataSet.Tables[0].Rows.Count; i++)
{
string SQLstr = "INSERT INTO testList ([Number], TestName, [Note]) VALUES ('" +
testItemsDataSet.Tables[0].Rows[i].ItemArray[0].ToString() + "','" +
testItemsDataSet.Tables[0].Rows[i].ItemArray[1].ToString() + "','" +
testItemsDataSet.Tables[0].Rows[i].ItemArray[2].ToString() + "'" + ")";
access.ExecuteSQLNonquery(SQLstr);
}