Populating Treeview Node using data base in C#

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text.RegularExpressions;
using MySql.Data;
using MySql.Data.MySqlClient;
using MySql.Data.Types;
using System.IO;

public partial class Treeview : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
MySqlDataAdapter daParentNode; //MYSQL Data Adapter For Parent Node
DataSet dsParent; //Data Set For Parent Node

MySqlDataAdapter daChild_1_Node; //MYSQL Data Adapter For Child_1 Node
DataSet dsChild_1; //Data Set For Child_1 Node

MySqlDataAdapter daChild_2_Node; //MYSQL Data Adapter For Child_1 Node
DataSet dsChild_2; //Data Set For Child_1 Node


//Get the data in DA
daParentNode = new MySqlDataAdapter("Select * from tbl_ParentNode", MyConn);
dsParent = new DataSet();
//fill the DS with DA
daParentNode.Fill(dsParent);

if (TreeView1.Nodes.Count == 0)
{

for (int i = 0; i <= dsParent.Tables[0].Rows.Count - 1; i++) //Loop through the data till we find the child nodes
{
//Create a new child node node

TreeNode pnode = new TreeNode();

pnode.Value = dsParent.Tables[0].Rows[i]["ParaentNode_ID"].ToString();
pnode.Text = dsParent.Tables[0].Rows[i]["ParaentNode"].ToString();
// set the blank ULR for Parent node
pnode.NavigateUrl = "Paraent Node URL";


this.NodeTree.Nodes.Add(pnode); // Add child node to parent node

daChild_1_Node = new MySqlDataAdapter("select * from Child1", MyConn);
dsChild_1 = new DataSet();
daChild_1_Node.Fill(dsChild_1);

for (int j = 0; j <= dsChild_1.Tables[0].Rows.Count - 1; j++)
{
TreeNode child1 = new TreeNode();

child1.Value = dsChild_1.Tables[0].Rows[j]["Child1_ID"].ToString();
child1.Text = dsChild_1.Tables[0].Rows[j]["Child1"].ToString();
// set the blank ULR for Child node
child.NavigateUrl = "Chlid1 URL";
pnode.ChildNodes.Add(child1);

daChild_2_Node = new MySqlDataAdapter("select * from Child2", MyConn);
dsChild_2 = new DataSet();
daChild_2_Node.Fill(dsChild_2);

for (int x = 0; x <= dsChild_2.Tables[0].Rows.Count - 1; x++)
{
TreeNode child_2 = new TreeNode();

child_2.Value = dsChild_2.Tables[0].Rows[x]["Child1_ID"].ToString();
child_2.Text = dsChild_2.Tables[0].Rows[x]["Child2"].ToString();

// set the blank ULR for child_1 node
child_2.NavigateUrl = "Child2 URL";
child1.ChildNodes.Add(child_2);

}

}
}

TreeView1.CheckedNodes.Add(pnode);
}
}
}

Update All fields in a table on a given condition (VBA)

Given below function is used to update All fields in a table on a given condition.

Sub ListTableFields(TableName As String)

Dim dbCurr As DAO.Database
Dim tdfCurr As DAO.TableDef
Dim fldCurr As DAO.Field

Set dbCurr = CurrentDb()
Set tdfCurr = dbCurr(TableName)

For Each fldCurr In tdfCurr.Fields

DoCmd.SetWarnings False

If fldCurr.Type = 10 Then
DoCmd.RunSQL ("Update " & TableName & " Set " & fldCurr.Name & " =NEw Values Where " & fldCurr.Name & "=Value To be updated ")

End If

Next fldCurr

Set fldCurr = Nothing
Set tdfCurr = Nothing
Set dbCurr = Nothing

End Sub