Get name of day in SQL server

SELECT DATENAME(WEEKDAY, GETDATE())

Tree view recursion method

private void AddNodetoComponentTree(UltraTreeNode node)
{
node.Expanded = true;
List childNodes = new List();
childNodes = GetChildNodes(Convert.ToInt32(node.Key));
foreach (ComponentData childNode in childNodes)
{
AddNodetoComponentTree(node.Nodes.Add(childNode.ComponentId.ToString(), childNode.Name));
}
}

private List GetChildNodes(int componentId)
{
List childNodes = new List();
foreach (ComponentData childNode in componentsData)
{
if (childNode.ParentId == componentId && childNode.ComponentId != componentId)
{
childNodes.Add(childNode);
}
}
return childNodes;
}