JavaScript for read data from XML file

var XmlReq;
function CreateXMLReq()
{
try
{
XmlReq= new ActiveXObject("Msxml2.XMLHTTP");
}
catch(ExXML)
{
try
{
XmlReq= new ActiveXObject("Microsoft.XMLHTTP");
}
catch(ExActivex)
{
XmlReq= null;
}
}

if(!XmlReq && typeof XMLHttpRequest != "undefined")
{
XmlReq = new XMLHttpRequest(); //Mozila Firefix Browser
}
}

function parseXML()
{
//load xml file
// code for IE
var urllink="SaffronMenu.xml";
CreateXMLReq();

if(XmlReq)
{
if (XmlReq.overrideMimeType)
XmlReq.overrideMimeType('text/xml');

XmlReq.onreadystatechange=function () { if (XmlReq.readyState==4)
if(XmlReq.status==200)
{
getMenuData("starters_menu", "divStartersMenu");
getMenuData("chicken_delicacies_menu", "divChickenDelicacies");
getMenuData("lamb_specialities_menu","divLambSpecialities");
getMenuData("duck_specialities_menu", "divDuckSpecialities");
getMenuData("vegetable_main_course_menu", "divVegetableMainCourse");
getMenuData("tandoori_khazana_menu","divTandooriKhazana");
getMenuData("seafood_specials_menu", "divSeafoodSpecials");
getMenuData("all_time_favourites_menu", "divAllTimeFavourites");
getMenuData("biriani_dishes_menu","divBirianiDishes");
getMenuData("vegetable_side_menu", "divVegetableSide");
getMenuData("sundries_menu", "divSundries");
}
//else alert("There was a problem during retrieving News." );
}
XmlReq.open("GET",urllink,true);
XmlReq.send(null);
}
//else { alert('Your browser cannot handle our java script'); }
}



function getMenuData(tagName, divName)
{
var ItemNode,loopi,litdata;
var backImg;
ItemNode=XmlReq.responseXML.documentElement.getElementsByTagName(tagName);

loopi=0;
litdata = "";
for(loopi=0;loopi {
if (ItemNode[loopi].getAttribute("desc") != null)
{
litdata =litdata+ ""
+ ""
+ "";
}

if (ItemNode[loopi].getElementsByTagName("item_name")[0].firstChild == null)
continue;

litdata =litdata+ "";

if (ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild != null)
{
if (ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild.data == 1)
backImg = "" + backImg + "";

if (ItemNode[loopi].getElementsByTagName("price")[0].firstChild != null)
litdata = litdata + " £ " + ItemNode[loopi].getElementsByTagName("price")[0].firstChild.data + "";

if(ItemNode[loopi].getElementsByTagName("description")[0].firstChild != null)
{
litdata =litdata+ ""
+ ""
+ "";
}

litdata = litdata + ""
}
litdata = litdata + "

" + ItemNode[loopi].getAttribute("desc")+ "
"; else backImg = "	"; } else backImg = "	"; litdata = litdata + backImg; if (ItemNode[loopi].getElementsByTagName("image_path")[0].firstChild != null) litdata = litdata + " + ItemNode[loopi].getElementsByTagName("image_path")[0].firstChild.data + "')\" onmouseout=\"hideTip()\">" + ItemNode[loopi].getElementsByTagName("item_name")[0].firstChild.data; else litdata = litdata + "" + ItemNode[loopi].getElementsByTagName("item_name")[0].firstChild.data; litdata =litdata + " " if (ItemNode[loopi].getElementsByTagName("chilli_image_path")[0].firstChild != null) litdata =litdata + " "; litdata = litdata + ""; // if (ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild != null) // { // if (ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild.data = "1") // litdata = litdata + " class = \"dotimage\""; // } litdata = litdata + "
" + ItemNode[loopi].getElementsByTagName("description")[0].firstChild.data + "

";
if (ItemNode.length>0)
document.getElementById(divName).innerHTML = litdata;
else
document.getElementById(divName).innerHTML = "";

document.getElementById(divName).innerHTML =litdata;
}


/*
function getMenuDataOld2(tagName, divName)
{
var ItemNode,loopi,litdata;
ItemNode=XmlReq.responseXML.documentElement.getElementsByTagName(tagName);

loopi=0;
litdata = "";
for(loopi=0;loopi {
if (ItemNode[loopi].getElementsByTagName("item_name")[0].firstChild == null)
continue;

litdata =litdata+ " if (ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild != null)
{
//if (ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild.data = "1")
// litdata = litdata + "";
if (ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild.data = "1")
litdata = litdata + " class = \"dotimage\"";
}
litdata = litdata + ">";

if(ItemNode[loopi].getElementsByTagName("description")[0].firstChild != null)
{
litdata =litdata+ ""
+ ""
+ "";
}
}
litdata = litdata + "

"; if (ItemNode[loopi].getElementsByTagName("image_path")[0].firstChild != null) litdata = litdata + " + ItemNode[loopi].getElementsByTagName("image_path")[0].firstChild.data + "')\" onmouseout=\"hideTip()\">" + ItemNode[loopi].getElementsByTagName("item_name")[0].firstChild.data + ""; else litdata = litdata + ItemNode[loopi].getElementsByTagName("item_name")[0].firstChild.data + " "; //litdata = litdata + "	"; if (ItemNode[loopi].getElementsByTagName("chilli_image_path")[0].firstChild != null) litdata =litdata + ""; litdata = litdata + "	"; if (ItemNode[loopi].getElementsByTagName("price")[0].firstChild != null) litdata = litdata + "£" + ItemNode[loopi].getElementsByTagName("price")[0].firstChild.data + "
" + ItemNode[loopi].getElementsByTagName("description")[0].firstChild.data + "

";
if (ItemNode.length>0)
document.getElementById(divName).innerHTML = litdata;
else
document.getElementById(divName).innerHTML = "";

document.getElementById(divName).innerHTML =litdata;
}

function getMenuData()
{
var ItemNode,loopi,litdata;
ItemNode=XmlReq.responseXML.documentElement.getElementsByTagName("starters_menu");

loopi=0;
litdata = "";
for(loopi=0;loopi {
litdata =litdata+ ""
+ ""
+ ""
+ ""
+ ""
+ "";
if(ItemNode[loopi].getElementsByTagName("description")[0].firstChild.data != "")
{
litdata =litdata+ ""
+ ""
+ "";
}
}
litdata = litdata + "

" + ItemNode[loopi].getElementsByTagName("item_name")[0].firstChild.data + "	" + ItemNode[loopi].getElementsByTagName("no_of_chilli_image")[0].firstChild.data + "	" + ItemNode[loopi].getElementsByTagName("display_Dotted_Line")[0].firstChild.data + "	" + ItemNode[loopi].getElementsByTagName("price")[0].firstChild.data + "
" + ItemNode[loopi].getElementsByTagName("description")[0].firstChild.data + "

";
if (ItemNode.length>0)
document.getElementById("divStartersMenu").innerHTML = litdata;
else
document.getElementById("divStartersMenu").innerHTML = "";

document.getElementById("divStartersMenu").innerHTML =litdata;
} */

Export Data From dataTable to csv file and save to local PC

public static void ExportDataToCSVFile(string filename, DataTable getExportData)
{
DataTable toCSVFile = getExportData.Copy();
HttpContext context = HttpContext.Current;
context.Response.Clear();

foreach (DataColumn column in toCSVFile.Columns)
{
context.Response.Write(column.ColumnName + ",");
}

context.Response.Write(Environment.NewLine);
foreach (DataRow row in toCSVFile.Rows)
{
for (int i = 0; i < toCSVFile.Columns.Count; i++)
{
context.Response.Write(row[i].ToString().Replace(",", string.Empty) + ",");
}

context.Response.Write(Environment.NewLine);
}

context.Response.ContentType = "text/csv";
context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ".csv");
context.Response.End();
}

Binding Navigator in C#.net

SqlCommand query = new SqlCommand("SELECT * from TableName", myConn);
SqlDataAdapter adrQuery = new SqlDataAdapter(query);
DataSet dsQuery = new DataSet();
adrQuery.Fill(dsQuery);

BindingNavigator _bindnav = new BindingNavigator(true);
_bindsrc.DataSource = dsQuery;
_bindnav.BindingSource = _bindsrc;
DataGridView.DataSource = _bindsrc;

New User Account in your PC With C#.net

DirectoryEntry AD = new DirectoryEntry("WinNT://" + Environment.MachineName + ",computer");
DirectoryEntry NewUser = AD.Children.Add("TestUser1", "user");
NewUser.Invoke("SetPassword", new object[] { "#12345Abc" });
NewUser.Invoke("Put", new object[] { "Description", "Test User from .NET" });
NewUser.CommitChanges();
DirectoryEntry grp;

grp = AD.Children.Find("Guests", "group");
if (grp != null) { grp.Invoke("Add", new object[] { NewUser.Path.ToString() }); }
Console.WriteLine("Account Created Successfully");
Console.ReadLine();