private void bind_colmnames(TreeNode node) { string tablename = getTableName(node.Text); DataTable dt = OP_DBClient.GetDbColmData(tablename); TreeNode[] nodes = new TreeNode[dt.Rows.Count]; for (int i = 0; i < nodes.Length; i++) { nodes[i] = new TreeNode(dt.Rows[i][0].ToString() + " (" + dt.Rows[i][1].ToString() + "|" + dt.Rows[i][2].ToString() + ")"); nodes[i].ImageIndex = 24; } node.Nodes.AddRange(nodes); }
private void bind_dbnames(TreeNode[] hismz) { DataTable[] tableArray = new DataTable[6]; try { tableArray[0] = OP_DBClient.GetDbData(DataTypeName.表); tableArray[1] = OP_DBClient.GetDbData(DataTypeName.视图); tableArray[2] = OP_DBClient.GetDbData(DataTypeName.存储过程); tableArray[3] = OP_DBClient.GetDbData(DataTypeName.索引); tableArray[4] = OP_DBClient.GetDbData(DataTypeName.函数); tableArray[5] = OP_DBClient.GetDbData(DataTypeName.触发器); TreeNode[] nodes = new TreeNode[tableArray[0].Rows.Count]; for (int i = 0; i < nodes.Length; i++) { nodes[i] = new TreeNode(tableArray[0].Rows[i][1].ToString()); nodes[i].Tag = 4; nodes[i].ImageIndex = 22; bind_colmnames(nodes[i]); } hismz[0].ImageIndex = 23; hismz[0].Nodes.AddRange(nodes); TreeNode[] nodeArray2 = new TreeNode[tableArray[1].Rows.Count]; for (int j = 0; j < nodeArray2.Length; j++) { nodeArray2[j] = new TreeNode(tableArray[1].Rows[j][1].ToString()); nodeArray2[j].Tag = 1; nodeArray2[j].ImageIndex = 22; bind_colmnames(nodeArray2[j]); } hismz[1].ImageIndex = 23; hismz[1].Nodes.AddRange(nodeArray2); TreeNode[] nodeArray3 = new TreeNode[tableArray[2].Rows.Count]; for (int k = 0; k < nodeArray3.Length; k++) { nodeArray3[k] = new TreeNode(tableArray[2].Rows[k][1].ToString()); nodeArray3[k].Tag = 2; nodeArray3[k].ImageIndex = 22; } hismz[2].ImageIndex = 23; hismz[2].Nodes.AddRange(nodeArray3); TreeNode[] nodeArray4 = new TreeNode[tableArray[3].Rows.Count]; for (int m = 0; m < nodeArray4.Length; m++) { nodeArray4[m] = new TreeNode(tableArray[3].Rows[m][1].ToString()); nodeArray4[m].ImageIndex = 22; } hismz[3].ImageIndex = 23; hismz[3].Nodes.AddRange(nodeArray4); TreeNode[] nodeArray5 = new TreeNode[tableArray[4].Rows.Count]; for (int n = 0; n < nodeArray5.Length; n++) { nodeArray5[n] = new TreeNode(tableArray[4].Rows[n][1].ToString()); nodeArray5[n].Tag = 3; nodeArray5[n].ImageIndex = 22; } hismz[4].ImageIndex = 23; hismz[4].Nodes.AddRange(nodeArray5); TreeNode[] nodeArray6 = new TreeNode[tableArray[5].Rows.Count]; for (int num6 = 0; num6 < nodeArray6.Length; num6++) { nodeArray6[num6] = new TreeNode(tableArray[5].Rows[num6][0].ToString()); nodeArray6[num6].ImageIndex = 22; } hismz[5].ImageIndex = 23; hismz[5].Nodes.AddRange(nodeArray6); } catch (Exception exception) { MessageBox.Show(exception.Message, "连接数据库配置不正确", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }