Click here to Skip to main content
15,891,674 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Multiple Access Pin
Christian Graus9-Apr-08 11:42
protectorChristian Graus9-Apr-08 11:42 
Generalconverting and updated converted pages Pin
Gus'O.9-Apr-08 11:09
Gus'O.9-Apr-08 11:09 
QuestionIs it possible to place a hyperlink within a ASP.NET textbox control? Pin
Infernojericho9-Apr-08 10:43
Infernojericho9-Apr-08 10:43 
AnswerRe: Is it possible to place a hyperlink within a ASP.NET textbox control? Pin
pmarfleet9-Apr-08 10:51
pmarfleet9-Apr-08 10:51 
GeneralRe: Is it possible to place a hyperlink within a ASP.NET textbox control? Pin
Infernojericho9-Apr-08 10:53
Infernojericho9-Apr-08 10:53 
GeneralRe: Is it possible to place a hyperlink within a ASP.NET textbox control? Pin
pmarfleet9-Apr-08 11:21
pmarfleet9-Apr-08 11:21 
GeneralCrystel Report ..Change Database Location at runtime Pin
Amr M. K.9-Apr-08 9:51
Amr M. K.9-Apr-08 9:51 
GeneralRe: Crystel Report ..Change Database Location at runtime Pin
Darsh_311-Apr-08 2:18
Darsh_311-Apr-08 2:18 
Imports System.Data
Imports System.Io
Imports System.Data.OleDb
Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.CrystalReports.Engine.ReportDocument
Imports CrystalDecisions.Web

Partial Class Test_rpt
Inherits System.Web.UI.Page
Dim cn As New ConnectionInfo
Dim con As New OleDbConnection

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Website1\App_Data\Database_Name.mdb;Persist Security Info=True"

Call showreport()
End Sub
Sub showreport()
With cn
.DatabaseName ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Website1\App_Data\Database_Name.mdb;Persist Security Info=True"


or
.DatabaseName ="Database_Name.mdb"

End With
Dim rpt As New ReportDocument
rpt.Load(Server.MapPath("report_name.rpt"))

Dim ParamFields As ParameterFields = Me.CrystalReportViewer1.ParameterFieldInfo()
Dim ParamField As New ParameterField
Dim ParamField_Value As New ParameterDiscreteValue

ParamField.Name = "prj"
ParamField_Value.Value = Session("prjnm")
ParamField.CurrentValues.Add(ParamField_Value)
rpt.ParameterFields("prj").CurrentValues.Add(ParamField_Value)
ParamFields.Add(ParamField)

ParamField = New ParameterField
ParamField_Value = New ParameterDiscreteValue
ParamField.Name = "dt"
ParamField_Value.Value = Session("dt")
ParamField.CurrentValues.Add(ParamField_Value)
rpt.ParameterFields("dt").CurrentValues.Add(ParamField_Value)
ParamFields.Add(ParamField)

ParamField = New ParameterField
ParamField_Value = New ParameterDiscreteValue
ParamField.Name = "sno"
ParamField_Value.Value = Session("maxsrno")
ParamField.CurrentValues.Add(ParamField_Value)
rpt.ParameterFields("sno").CurrentValues.Add(ParamField_Value)
ParamFields.Add(ParamField)

Me.CrystalReportViewer1.ParameterFieldInfo = ParamFields
Me.CrystalReportViewer1.HasRefreshButton = False
Me.CrystalReportViewer1.HasPageNavigationButtons = False
Me.CrystalReportViewer1.HasGotoPageButton = False
Me.CrystalReportViewer1.HasToggleGroupTreeButton = False

For Each cnInfo As TableLogOnInfo In Me.CrystalReportViewer1.LogOnInfo
cnInfo.ConnectionInfo = cn
Next

Dim ms As System.IO.MemoryStream
ms = CType(rpt.ExportToStream(ExportFormatType.PortableDocFormat), System.IO.MemoryStream)
rpt.Close()
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "Application/pdf"
Response.AppendHeader("Content-Disposition", "attachment; filename=" & Session("inno1") & ".PDF")
Response.Buffer = True
Response.BinaryWrite(ms.ToArray())
Response.End()



End Sub
End Class
GeneralWeird behavior of FindControl Pin
AlexeiXX39-Apr-08 8:01
AlexeiXX39-Apr-08 8:01 
GeneralRe: Weird behavior of FindControl Pin
MrPlankton9-Apr-08 11:32
MrPlankton9-Apr-08 11:32 
GeneralRe: Weird behavior of FindControl Pin
AlexeiXX39-Apr-08 11:47
AlexeiXX39-Apr-08 11:47 
GeneralRe: Weird behavior of FindControl Pin
MrPlankton10-Apr-08 5:39
MrPlankton10-Apr-08 5:39 
QuestionHow to send cookies with httpwebrequest Pin
raha20029-Apr-08 6:56
raha20029-Apr-08 6:56 
AnswerRe: How to send cookies with httpwebrequest Pin
led mike9-Apr-08 7:17
led mike9-Apr-08 7:17 
GeneralRe: How to send cookies with httpwebrequest Pin
raha20029-Apr-08 8:56
raha20029-Apr-08 8:56 
GeneralRe: How to send cookies with httpwebrequest Pin
led mike10-Apr-08 5:41
led mike10-Apr-08 5:41 
QuestionLost selection from dropdownlist after postback??? Pin
JimFeng9-Apr-08 6:21
JimFeng9-Apr-08 6:21 
AnswerRe: Lost selection from dropdownlist after postback??? Pin
ChrisKo9-Apr-08 10:38
ChrisKo9-Apr-08 10:38 
GeneralRe: Lost selection from dropdownlist after postback??? Pin
JimFeng10-Apr-08 5:24
JimFeng10-Apr-08 5:24 
GeneralDates Problem Pin
macca249-Apr-08 5:09
macca249-Apr-08 5:09 
AnswerRe: Dates Problem Pin
Jesse Squire9-Apr-08 5:24
Jesse Squire9-Apr-08 5:24 
GeneralRe: Dates Problem Pin
Darsh_310-Apr-08 8:50
Darsh_310-Apr-08 8:50 
Questionhow to give input data at runtime in a table format after button click saving Pin
vardhanmm@gmail.com9-Apr-08 3:41
vardhanmm@gmail.com9-Apr-08 3:41 
AnswerRe: how to give input data at runtime in a table format after button click saving Pin
Ashish Sehajpal9-Apr-08 3:59
Ashish Sehajpal9-Apr-08 3:59 
GeneralRe: how to give input data at runtime in a table format after button click saving Pin
Paddy Boyd9-Apr-08 4:44
Paddy Boyd9-Apr-08 4:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.