static string fc;
Static OracleConnection Conn = new OracleConnection("bla bla");
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
fc = ((DropDownList)((Page)sender).FindControl("ddl1")).SelectedValue.ToString();
else
{ if (Conn.State != ConnectionState.Open) Conn.Open(); }
}
protected void ddl1_DataBound(object sender, EventArgs e)
{
if ( ! Page.IsPostBack )
fc = ((DropDownList)sender).SelectedValue.ToString();
}
protected void pbFind_Click(object sender, EventArgs e)
{
DateTime dt1 = DateTime.Now;
TreeView1.Nodes.Clear();
TreeNode tn = new TreeNode(ddl1.SelectedItem.ToString());
TreeView1.Nodes.Add(tn);
GetNodes(fc, tn);
DateTime dt2 = DateTime.Now;
TimeSpan ts = dt2 - dt1;
if ( ts.Seconds <= 1 )
Label1.Text = "Time to execute: " + ts.Seconds.ToString() + " second!!";
else
Label1.Text = "Time to execute: " + ts.Seconds.ToString() + " seconds!!";
}
protected void GetNodes(string Parent, TreeNode Tn)
{
string Sql = "select failurecode, failurelist, parent, description from failurecode";
OracleCommand Cmd = new OracleCommand(Sql, Conn);
OracleDataReader Dr;
Dr = Cmd.ExecuteReader();
while (Dr.Read())
{
GridView1.DataSource = Dr;
TreeNode tn = new TreeNode(Dr[0].ToString() + " (" + Dr[3].ToString() + ")", Dr[0].ToString());
Tn.ChildNodes.Add(tn);
if (! string.IsNullOrEmpty(Dr[1].ToString()))
{
Parent = Dr[1].ToString();
GetNodes(Parent, tn);
}
}
Dr.Close();
}
private void btnGo_Click(object sender, EventArgs e)
{
string csvData = "";
BuildCSV(treeView1.Nodes, ref csvData, 0);
using (StreamWriter writer = new StreamWriter(@"C:\ExportedTree.csv"))
{
writer.Write(csvData);
}
}
private void BuildCSV(TreeNodeCollection nodes, ref string csvData, int depth)
{
foreach (TreeNode node in nodes)
{
csvData = csvData + new String(',', depth) + node.Text + "\n";
if (node.Nodes.Count > 0)
BuildCSV(node.Nodes, ref csvData, depth+1);
}
|