Comments by mahakaal (Top 26 by date)

Thanks for your quick reply Sir.
i am trying to understand it and after your suggestion. i will try my best to understand it myself.

dear i had already tried your solution but it's not working .

i have the solution to server my purpose.
which is as following if i simply use the below code instead of using the code mentioned in my problem

protected void Button2_Click1(object sender, EventArgs e)
{
string filePath = Label117.Text;
FileInfo file = new FileInfo(filePath);

if (file.Exists)
{

Response.Redirect("~/ExcelFiles/" + file.Name);

}


}

but i want to know why this problem is coming if i use previous mentioned code.

i did what you said but still the problem is same.

if i remove the fileupload control than it works fine.

font is installed on the server. where the project is actually stored.

if i open the project in visual studio and run the program. Then downloads the pdf for a jobno then it is showing barcode on that pdf.

but when on the same sever after publishing the website i access it and again download the job card it doesn't show the bacode it shows like *12344* where 12344 is the job no.

In both cases i am accessing it from the same server not from any other machine.

font is installed on the server. where the project is actually stored.

if i open the project in visual studio and run the program. Then downloads the pdf for a jobno then it is showing barcode on that pdf.

but when on the same sever after publishing the website i access it and again download the job card it doesn't show the bacode it shows like *12344* where 12344 is the job no.

In both cases i am accessing it from the same server not from any other machine.

have your solved this problem or still working on it.

Thanks Talit

i have checked the link but after the download user will have to manually get back to the page from where they had made request.

after download they are not reloading the page. they are just sending file to browser.

thanx, i got it.. i will try this method..

it's working... but should i continue with this logic or should i give a try to 1st solution which you had shared.

but i couldn't get the first solution. how to do that ...

Talit, i haven't try the 1st fmethod. but after trying the second method. i thought of doing this with the help of timer. which is serving my purpose. but i would want your suggestion on that. Below is the logic i have used for it.

on submit button
1. i am saving information into database
2. Saving the jobno into session variable session["temp_jobno"] and then reloading the page
3. on page load event if session["temp_jobno"] value is not null than calling a timer with interval of 1 sec.
4. on tick event of timer i am saving session value into a string variable(which is acutally jobno) and setting session["temp_jobno"]=null as well as disabling the timer control then sending the pdf to browser for dowload.

either in chrome or firefox..
i had tried the second one.

hi Tadit,

First of all thanks, as you always responds to my query.

in my last query you have provide me the solution but it was not working on all browsers.
now i am trying to do it with the help of timer.
it's working but what will be the drawbacks if i use timer and do the same.

pdf export can be done easily but how will i reload the page after pdf export. as
Response.AddHeader("Refresh", "3; url=index.html"); is not working on all browsers.

Tadit, the solution you gave me is working but not on all internet browsers.

one way to achieve this is by using timer control.

private string name;
public string name
{
get { return name; }
set { name= value; }
}


//what is benefit of get set, if i do the same thing in this way

private string name:
public string name ()
{ return name;}
public name (aString)
{ name = aString;}

= PDFName;
CrExportOptions = printJ.ExportOptions;
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
printJ.Export(CrExportOptions);
printJ.Dispose();
printJ.Close();
GC.Collect();
Response.ContentType = "application/pdf";
Response.AddHeader("Refresh", "3; url=joblogin.aspx");
Response.AppendHeader("Content-Disposition", "attachment; filename="+Request.QueryString["jobid"].ToString()+".pdf");

Response.TransmitFile(PDFName);

}

}

it's not actually a different approach. Right know i am saving the pdf generated from crystal report on my server than i am sending it to browser.. Can i directly send the pdf to browser without saving it..

Below is my code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.Shared;
using CrystalDecisions.Web;
using CrystalDecisions.Reporting;
using CrystalDecisions.ReportSource;
using System.Data.SqlClient;
using System.Configuration;
using System.Threading;
public partial class SaveJobCard : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

string PDFName,temp;
if (Request.QueryString["jobid"].ToString() != "")
{
PDFName = Request.QueryString["jobid"].ToString();
temp = PDFName;
PDFName=PDFName.ToString();
PDFName = Environment.GetFolderPath(Environment.SpecialFolder.Desktop)+"\\temp\\"+ PDFName + ".pdf";
}
else
{
PDFName = "report";
}
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["dsd"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Delete from JobCard";
cmd.ExecuteNonQuery();
cmd.CommandText = "INSERT INTO JobCard(jobno,job_name,Bill_noBill,job_type,department,login_date,dispatch_dateTime,dmode,company_name,Client_department,contact_person,contact_no,Email_id,Delivery_addl1,Delivery_addl2,Delivery_addl3,Delivery_City,Delivery_State,Delivery_Pin,PMethod,PO_Date,PO_No,Paper_type,Paper_size,Grammage,qty,LPrint_Remark,lBind_Remark,LDispatch_Remark,dispatched,delivered,challan_ready,SONo,acc_remarks,challan_no,Tran_Id,guid,printdoneby,printdonetime,bindingdonetime,bindingdoneby,loginby,Diff_Location,DLocation_path,Verify,Binding_remark,Cordinator_PrintingRemark,Dispatch_done_remark,Delivery_done_remark,Need_Form38,modify,consulted_person,C_media,Modification_remark,old_dispatch_date,overflow,PendingFromBinding,PendingFromPrinting,PendingFromChallan,BindingDoneRemarks,PrintingDoneRemarks,ItemRate,TotalAmount) SELECT jobno,job_name,Bill_noBill,job_type,department,login_date,dispatch_dateTime,dmode,company_name,Client_department,contact_person,contact_no,Email_id,Delivery_addl1,Delivery_addl2,Delivery_addl3,Delivery_City,Delivery_State,Delivery_Pin,PMethod,PO_Date,PO_No,Paper_type,Paper_size,Grammage,qty,LPrint_Remark,lBind_Remark,LDispatch_Remark,dispatched,delivered,challan_ready,SONo,acc_remarks,challan_no,Tran_Id,guid,printdoneby,printdonetime,bindingdonetime,bindingdoneby,loginby,Diff_Location,DLocation_path,Verify,Binding_remark,Cordinator_PrintingRemark,Dispatch_done_remark,Delivery_done_remark,Need_Form38,modify,consulted_person,C_media,Modification_remark,old_dispatch_date,overflow,PendingFromBinding,PendingFromPrinting,PendingFromChallan,BindingDoneRemarks,PrintingDoneRemarks,ItemRate,TotalAmount FROM login where JobNo='" + Request.QueryString["jobid"].ToString() + "'";
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}


ReportDocument printJ = new ReportDocument();

// string FileName = "test.rpt";

//Session["file"] = "yes";
printJ.Load(Server.MapPath("JobCard.rpt"));
printJ.SetDatabaseLogon("sa", "Perfact@1234", "192.168.1.7", "DispatchStatus");
printJ.Refresh();
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName

Tadit, thanks as your suggestion has worked for me.. but would you help me if i will try to solve the same issue with different approach...

Thanx Prasad for your sharing valuable info...