tutup connection crystal report dlm asp.net - vb.net

aks_berhad · Post time 5-2-2009 12:46 PM

aku dah mati akal...tak tau camana nak tutup connection yg dibuka oleh crystal report.

Aku buat code utk convert dari format crystal report ke pdf....code tu jadik, tapi masalahnya connection yg dicreate oleh crystal report tu tak boleh tutup. Nie code yg aku buat :-

      Dim crLogonInfo As CrystalDecisions.Shared.TableLogOnInfo
      Dim rptSource As New ReportDocument
      Dim a As String

      'Stop buffering the response
      Response.Buffer = False
      'Clear the response content and headers
      Response.ClearContent()
      Response.ClearHeaders()

      'Response.Write(Server.MapPath("prtmyiKEWtry.rpt"))
      'a = Server.MapPath
      rptSource.Load(Server.MapPath("prtmyiKEW.rpt"))
      crLogonInfo = rptSource.Database.Tables(0).LogOnInfo
      crLogonInfo.ConnectionInfo.ServerName = "*****"
      crLogonInfo.ConnectionInfo.UserID = "****"
      crLogonInfo.ConnectionInfo.Password = "****"
      crLogonInfo.ConnectionInfo.DatabaseName = "****"
      rptSource.Database.Tables(0).ApplyLogOnInfo(crLogonInfo)
      rptSource.Refresh()
      rptSource.SetParameterValue(UCase("sElmCode"), "*****"))
      rptSource.SetParameterValue(UCase("sStartDate"), "26/01/2009")
      rptSource.SetParameterValue(UCase("sEndDate"), "26/01/2009")
      rptSource.SetParameterValue(UCase("sIC"), "*****") 'CStr(info(0)))
      rptSource.SetParameterValue(UCase("sName"), "Ahmad")
      rptSource.SetParameterValue(UCase("sNoStaf"), "Ahmad")
      rptSource.SetParameterValue(UCase("sPTJ"), "Ahmad")
      rptSource.SetParameterValue(UCase("sBankName"), "Ahmad") 'info(4))
      rptSource.SetParameterValue(UCase("sAccNo"), "Ahmad") 'CStr(info(5)))
      rptSource.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, True, "Customers")
      rptSource.Dispose()
      rptSource.DataSourceConnections.Clear()

      GC.Collect()
      GC.WaitForPendingFinalizers()

tlg advice...
tq

aks_berhad · Post time 10-2-2009 09:35 AM

adeh....takder sapa2 ke yg bole tolong?

naikAntena · Post time 12-2-2009 01:24 PM

ko xbuat pon path filedestinationoption.. imports crystaldecisions.shared...

response ????

response.charset =""
response.writefile(crDiskFileDestinationOptions.DiskFileName)
response.flush()
response.close()

tp btol ke coding atas tuh jd bila eksport..... errorr kuar apa tuh..... aku xtahu kikiki.....

aks_berhad · Post time 14-2-2009 01:38 AM

naikAntena..
code tu jadik...tapi bila aku tgk kat processes dlm sybase admin, ada crystal tu tak close connection tu. bayangkan kalo 1000 org akses page aku tu, so maknanya 1000 conn yg akan dicreate.

arghhh tension...skang nie tepaksala user print form je la dulu sampai aku boleh solve prob tu.

aks_berhad · Post time 14-2-2009 01:42 AM

sebelum nie aku guna code lain dan berjaya close connectio tu...so dgn bangganyer aku bgtau bos aku kejayaan aku tu...so beliau pon nak aku launch system asap.

tapi bile nak sampai date tu, aku dah upgrade version sybase aku tu coz nak solve satu pob yg dah aku tinggalkan 1 thn lamanya. hasilnya ; prob lama selesai, create prob baru

naikAntena · Post time 17-2-2009 03:16 PM

hahahahaha... mcm2 ko nih.. besa arr tuh.. selalunyaa apa yg kita siap buat mengundang lebih banyak request ngan problemm... kuikui.. saborr je larrr....