How to open a Print view from excel;

         




        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=GridViewToExcel.xls");
        Response.ContentType = "application/excel";
        StringWriter sWriter = new StringWriter();
        HtmlTextWriter hTextWriter = new HtmlTextWriter(sWriter);
        HtmlForm hForm = new HtmlForm();
        RegionalGrid.Parent.Controls.Add(hForm);
        hForm.Attributes["runat"] = "server";
        hForm.Controls.Add(RegionalGrid);
        hForm.RenderControl(hTextWriter);
        Response.Write(sWriter.ToString());
        Response.End();

Filering values in a Dataset

Hi all,
 Today I'm going to tell you about filtering values from a Dataset where the data get from SQl and stored in a dataset.
 Later on you need to filter the values for a given criteria from the dataset you have.
 you can do that by:

 DataSet DSpocode=new DataSet();
 DSpocode="Dataset select from SQL"
 DataTable table = DSpocode.Tables[0];
 for (int i = 0; i < DSpocode.Tables[0].Rows.Count; i++)
 {
 string expression = " substr('PD_CODE',3) like'%" + 65600+ "%'";
 DataRow[] foundRows = table.Select(expression);
 int rowCount = foundRows.Length;
}
 // PD_CODE is the coliumn name in the dataset.
 //I got the count where PD code like 65600. Likewise you can alter this to fulfill your requirement.

Thanks.

Date Difference

DateTime dt1 = Convert.ToDateTime(stDate); // Start Date
DateTime dt2 = Convert.ToDateTime(endDate);  // End date

TimeSpan ts = dt1 - dt2;  // Get Difference

int days = ts.Days;

How to Disable text box using Javascript for DDL events

script type="text/javascript"
function PAChange()

debugger
var ChangeSelect=document.getElementById("ddl_pachng").selectedIndex;
if((ChangeSelect==1) (ChangeSelect==2))
{
document.form1.txtpacd.disabled=false;
}
if(ChangeSelect==3)
{
document.form1.txtpacd.disabled=true;
}
}
script



////==================================call the above javascript inbody onload and dropdownlist change event

body onload="JavaScript:PAChange();"

How Open Browser Print From Word

Response.Clear();
Response.Buffer = true;
Page.EnableViewState = false;
Response.ContentType = "application/msword";
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();