ASP.NET

harish mehra wrote:

when i open & then saved this excel it showed
"save as type" "web page

/* Function Name: Download()
        Purpose: Downloads the Excel file*/

     private void Download()
    {
        /* Set necessary properties to for the response object to render excel document.*/

        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
        Response.ContentType = "application/vnd.xls";
        Response.Charset = "";
        this.EnableViewState = false;

        /* Creating a string writer object */
        System.IO.StringWriter objStringWriter = GenerateExcelBody();

        /* Content written to the HtmlTextWriter (StringWriter) is written to the Response object.*/

        Response.Write(objStringWriter.ToString());
        Response.End();

    }

/* Function Name: GenerateExcelBody()
      Purpose: Creates the Excel body */

    private System.IO.StringWriter GenerateExcelBody()
    {
        /* Instantiate a HtmlTextWriter with a System.IO.StringWriter object */

        System.IO.StringWriter objStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter objHtmlTextWriter = new System.Web.UI.HtmlTextWriter(objStringWriter);

	string strVal =string.Empty;

       
            /* Page wise Looping thru the grid */
            for (int i = 0; i < grEims.Rows.Count; i++)
            {
               
                    if (i % 2 == 0)
                    {
                        strVal += "<tr bgcolor='white'><td>" + grEims.Rows[i].Cells[0].Text + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[1].Text + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[2].Text.ToString() + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[3].Text.ToString() + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[4].Text.ToString() + "&nbsp;" + grEims.Rows[i].Cells[5].Text.ToString() + "</td></tr>" + Environment.NewLine;

                    }
                    else
                    {
                        strVal += "<tr bgcolor='white'><td>" + grEims.Rows[i].Cells[0].Text + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[1].Text + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[2].Text.ToString() + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[3].Text.ToString() + "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + grEims.Rows[i].Cells[4].Text.ToString() + "&nbsp;" + grEims.Rows[i].Cells[5].Text.ToString() + "</td></tr>" + Environment.NewLine;
                    }
            }
       

       

        /* Formating the Excel body */

        objHtmlTextWriter.WriteLine("<table width='100%'>" +
            "<tr><td align=center bgcolor='#ccccff'><h4>List Of Interviews Conducted </h4></td></tr>" +
            "<tr><td bgcolor='gray'><b>NO &nbsp; EMP NO.&nbsp;FIRST NAME&nbsp;LAST NAME&nbsp;RECORD RECEIVED ON &nbsp;&nbsp;INTERVIEW</b></td>" +
            "</tr>" + strVal + "</table>");

        return objStringWriter;
    }

protected void Page_Load(object sender, EventArgs e)
{
        if (!IsPostBack)
        {
            Download();
            
        }
}

benams wrote:

it's not working...

Member 2102804 wrote:

If I directly try on the browser, it works fine and giving the below response:



<status>ERROR

Member 2102804 wrote:

But If I use webclient class, the response is different, and is not posting the data at all:



<status>HTTP/1.0 200 OK
Content-Type: text/xml
Content-Length: 100



<status>SUCCESS

public DataTable FunctionGetTable()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("PartNumber");
        dt.Rows.Add("PartNumber1");
        dt.Rows.Add("PartNumber5");
        dt.Rows.Add("PartNumber6");
        dt.Rows.Add("PartNumber3");
        dt.Rows.Add("PartNumber3");
        dt.Rows.Add("PartNumber6");
        dt.Rows.Add("PartNumber3");
        dt.Rows.Add("PartNumber5");
        dt.Rows.Add("PartNumber5");
        return dt;
    }

private ArrayList RemoveDuplicatePartNumbers(DataTable dtParts)
 {
        ArrayList lstparts = new ArrayList();

        var query = (from c in dtParts.AsEnumerable()
                     orderby c.Field<string>("PartNumber")
                     select c).Distinct(DataRowComparer.Default);

        foreach (var d in query) lstparts.Add(d); 
        return lstparts;       
}

protected void Button1_Click(object sender, EventArgs e)
    {
       ArrayList RequiredList = new ArrayList();
       RequiredList = RemoveDuplicatePartNumbers(FunctionGetTable());
    }

engbahramZarin wrote:

when I am trying to upload file on to my web server every time it's prompting window for user name password of my domain .