62,041
社区成员
发帖
与我相关
我的任务
分享
this.TreeView2.Clear();//清TreeView的节点
public OleDbDataReader ExecuteQueryReturnReader(string sql, string connStr)
{
OleDbConnection conn = new OleDbConnection();
OleDbDataReader reader = null;
try
{
conn = new OleDbConnection(connStr);
conn.Open();
OleDbCommand command = conn.CreateCommand();
command.CommandText = sql;
reader = command.ExecuteReader();
}
catch(Exception ex)
{
}
finally
{
//if (conn != null)
//conn.Close();
}
return reader;
}
string TableName = "";
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DataBase;
ExecSql con = new ExecSql();
string ID = string.Format("select NodeID from config where Name='{0}'",e.Node.Text);
OleDbDataReader p = con.ExecuteQueryReturnReader(ID, strConnection);
if(p == null)
{
MessageBox.Show("222");
}
if (p != null)
{
while (p.Read())
{
TableName = p[0].ToString();
}
p.Close();
}
else
{
}
string sql = string.Format("select FaID from {0}",TableName);
OleDbDataReader p2 = con.ExecuteQueryReturnReader(sql, strConnection);
if(p2 != null)
{
while(p2.Read())
{
for(int i=0;i<p2.FieldCount;i++)
{
if (string.Compare(p2[i].ToString(),"0",true) == 0)
{
string Name = string.Format("select Name from {0} where FaID={1}", TableName, "0");
OleDbDataReader N = con.ExecuteQueryReturnReader(Name, strConnection);
if(N != null)
{
while (N.Read())
{
string NodeName = N[0].ToString();
EvebtTree2AddData(NodeName);
}
N.Close();
}
}
else if (string.Compare(p2[i].ToString(),"101",true) == 0)
{
string Name = string.Format("select Name from {0} where FaID={1}", TableName, "101");
OleDbDataReader N = con.ExecuteQueryReturnReader(Name, strConnection);
while (N.Read())
{
string NodeName = N[0].ToString();
SerialNodes = new TreeNode();
SerialNodes.Text = NodeName;
rootnode2.Nodes.Add(SerialNodes);
}
N.Close();
}
else if (string.Compare(p2[i].ToString(),"102",true) == 0)
{
string Name = string.Format("select Name from {0} where FaID={1}", TableName, "102");
OleDbDataReader N = con.ExecuteQueryReturnReader(Name, strConnection);
while (N.Read())
{
string NodeName = N[0].ToString();
TreeNode NewNodes = new TreeNode();
NewNodes.Text = NodeName;
SerialNodes.Nodes.Add(NewNodes);
}
N.Close();
}
else
{
}
}
}
p2.Close();
}
this.treeView2.ExpandAll();
}