How to get Printable Contents and Non Printable Contents in Javascript

<script language="javascript" type="text/javascript">

function PopPrint() {

var originalContents = document.body.innerHTML;

var prtContent = document.getElementById('<%=Receipt.ClientID %>');

var printContents = prtContent.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

</script>

How to Get Filenames from Directory

DirectoryInfo di = new DirectoryInfo(@"E:\Empphoto\");

FileInfo[] files = di.GetFiles();

foreach (FileInfo f in files)

{

con.Open();

string Qry = "Insert into TblEmpPhoto(ImgNameWithExt,ImgName,ImgExt) Values (@ImgNameWithExt,@ImgName,@ImgExt);";

SqlCommand cmd = new SqlCommand(Qry, con);

cmd.Parameters.AddWithValue("@ImgNameWithExt", f.Name.ToString().ToUpper());

cmd.Parameters.AddWithValue("@ImgName", f.Name.Split('.')[0].ToString().ToUpper());

cmd.Parameters.AddWithValue("@ImgExt", f.Name.Split('.')[1].ToString().ToUpper());

cmd.ExecuteNonQuery();

con.Close();

}

Get FileName from Filepath

private string GetFileName(string hrefLink)

{

string[] parts = hrefLink.Split('/');

string fileName = "";

if (parts.Length > 0)

fileName = parts[parts.Length - 1];

else

fileName = hrefLink;

return fileName;

}

Linq IsNull for DateTime

var
result = from r in Dsdod.Tables[0].AsEnumerable()where r.IsNull("startdate") != true && r.IsNull("expirydate") != true && r.IsNull("category") != true && CurrentIST >= (r.Field<DateTime>("startdate")) && CurrentIST < (r.Field<DateTime>("expirydate"))select new { Id = r.Field<Int32>("adid"), PromoCode = r.Field<string>("category") };

How to Add Hyperlink in Girdview Hader Row in Asp.Net

protected void GrdScheduler_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.Header)

{

if (e.Row.RowType == DataControlRowType.Header)

{

for (int m = 1; m < e.Row.Cells.Count; m++)

{

HyperLink hlControl = new HyperLink();

hlControl.ForeColor = System.Drawing.Color.White;

hlControl.Text = e.Row.Cells[m].Text.Split('|')[0];

hlControl.NavigateUrl = "~/ToolTip/FrmCountDetails.aspx?Name=" + e.Row.Cells[m].Text.Split('|')[0] + "&Id=" + e.Row.Cells[m].Text.Split('|')[1] + "&Date=" + RDPFromDate.Text + "";

hlControl.Attributes.Add("OnClick", "var w=window.open(this.href, 'ViewCount', 'height=350, width=600,top=40,left=100,toolbar=no,menubar=no,location=no,resizable=no,scrollbars=yes,status=no');w.focus(); return false;");

hlControl.ToolTip = "Click Here to view Details of " + e.Row.Cells[m].Text.Split('|')[0];

e.Row.Cells[m].Controls.Add(hlControl);

}

}

}

}

How to Read XML String and Create XML File in Asp.net

SqlCommand cmd = new SqlCommand("Select top 10 * from TblAppointment", con);
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);

        XmlDocument doc = new XmlDocument();

        foreach (var XML in ds.Tables[0].AsEnumerable())
        {
            doc.LoadXml(XML.Field<string>("AppointmentTransXml"));

            doc.Save(Server.MapPath("XML") + "//" + XML.Field<string>("Patientname") + ".xml");
        }

XML in LINQ ( Get Values from XML Using LINQ )

public
{
WeatherData GetCityTemprature(string city)XElement xe = XElement.Load(@".\WeatherForecast\City.xml");

var query = from xElem in xe.Elements("City")
where xElem.Element("Name").Value == city

select new WeatherData{
City = (string)xElem.Element("Name"),
State = (string)xElem.Element("State"),
MaxTemprature = Convert.ToDouble(xElem.Element("MaxTemp").Value),
MinTemprature = Convert.ToDouble(xElem.Element("MinTemp").Value),
};

}

WeatherData wd = query.First();return wd;