aspnet_regiis.exe -iru
private void buildTree()
{
List cml;
cml = cmf.GetAll();
TVcategory.Nodes.Clear();
AddNodes(0, TVcategory.Nodes, cml);
}
void AddNodes(int id, TreeNodeCollection tn, List cml)
{
foreach (Categorymaster cm in cml.Where(s => s.Parentid == id))
{
//TreeNode sub = new TreeNode("" + cm.Category_name + "", cm.Category_id.ToString());
TreeNode sub = createTree(cm);
tn.Add(sub);
AddNodes(Convert.ToInt32(sub.Value), sub.ChildNodes, cml);
}
}
private TreeNode createTree(Categorymaster cm)
{
TreeNode tn = new TreeNode("" + cm.Category_name + "", cm.Category_id.ToString());
if (catid > 0)
{
if (cm.Category_id == catid)
{
tn.Selected = true;
}
}
return tn;
}
;WITH Descendants AS (
SELECT p.category_name
, p.category_id
, 0 AS HLevel
FROM dbo.categorymaster p
WHERE category_id = '7'
UNION ALL
SELECT p.category_name
, p.category_id
, H.HLevel+1
FROM dbo.categorymaster p
INNER JOIN Descendants H
ON H.category_id=p.parentid
)
SELECT category_id, REPLICATE(' ', Hlevel) + category_name AS category_name
FROM Descendants d
;WITH Ancestors AS ( SELECT p.category_name , p.category_id , parentid , 1 AS HLevel FROM dbo.categorymaster p WHERE category_id = 9 UNION ALL SELECT p.category_name , p.category_id , p.parentid , H.HLevel+1 FROM dbo.categorymaster p INNER JOIN Ancestors H ON H.parentid=p.category_id ) SELECT category_name, category_id, HLevel FROM Ancestors c
XmlDocument doc = new XmlDocument(); doc.LoadXml(stringxml); Response.Clear(); //optional: if we've sent anything before Response.ContentType = "text/xml"; //must be 'text/xml' Response.ContentEncoding = System.Text.Encoding.UTF8; //we'd like UTF-8 doc.Save(Response.Output); //save to the text-writer Response.End();
private void Page_Load(object sender, System.EventArgs e)
{
MailMessage mail = new MailMessage();
mail.To = "me@mycompany.com";
mail.From = "you@yourcompany.com";
mail.Subject = "this is a test email.";
mail.Body = "Some text goes here";
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1"); //basic authentication
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "my_username_here"); //set your username here
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "super_secret"); //set your password here
SmtpMail.SmtpServer = "mail.mycompany.com"; //your real server goes here
SmtpMail.Send( mail );
}