marlin

I got the following error message on the line that declared a ReportDocument. In addition, when I tried to open any Crystal Reports that I created in Visual Studio 2005, I got "Crystal Reports ActiveX Designer: Failed to open document." and "Microsoft Visual Studio: Failed to create the Crystal Query Engine." error message. I uninstalled and reinstalled Visual Studio 2005. I had some problem during the uninstallation and installation process. After I finally got VS installed, things seemed to work fine for a short while. When I rebuilt my Setup project for the third time, I got this same error message again. Is there any way that I can fix this problem? Thanks. Retrieving the COM class factory for component with CLSID {11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 80040154. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 80040154. Source Error: Line 16: ' ***** Load a report to ReportDocument Object. Line 17: 'Dim rptBatchCoverPage As ReportDocument = New ReportDocument Line 18: Dim rptBatchCoverPage As ReportDocument = New ReportDocument Line 19: Dim strReportFilePath As String = Server.MapPath("..\Reports\crBatchCoverPage.rpt") Line 20: rptBatchCoverPage.Load(strReportFilePath) Source File: C:\Inetpub\wwwroot\CFSP\Batch\BatchCoverPage.aspx.vb Line: 18 Stack Trace: [COMException (0x80040154): Retrieving the COM class factory for component with CLSID {11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 80040154.] CrystalDecisions.CrystalReports.Engine.ReportDocument..cctor() +182 [TypeInitializationException: The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception.] CrystalDecisions.CrystalReports.Engine.ReportDocument..ctor() +0 BatchCoverPage.ConfigureCrystalReports(Object sender, EventArgs e) in C:\Inetpub\wwwroot\CFSP\Batch\BatchCoverPage.aspx.vb:18 BatchCoverPage.Page_Init(Object sender, EventArgs e) in C:\Inetpub\wwwroot\CFSP\Batch\BatchCoverPage.aspx.vb:12 System.Web.UI.Control.OnInit(EventArgs e) +98 System.Web.UI.Page.OnInit(EventArgs e) +9 System.Web.UI.Control.InitRecursive(Control namingContainer) +371 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2029

I just found out that I am supposed to use the RowDataBound event instead of the RowCreated event. I got my program to work fine now.

I would like to have the SELECT button displayed in certain rows depending on the value of a particular column in the GridView control. If the value in that column is true, I would like the SELECT button to be displayed. Other wise, I don't want the SELECT button to show. I have been trying to use the RowCreated event to determine when to display the SELECT button. So far I have no luck in accessing and evaluating the value of that particular column. Is there a way that I can do this? Any help is appreciated. Thank you.

Thank you, Nate.

I have an application that will display data depending on the county that a user chooses. The text "Download file for all facilities in this county in Excel file format" will not be displayed until the user makes a county selection. Once the selection is made, the page will display the data and also show a link to a downloadable file for that county. Everything works really well in IE. The data are displayed on the page and there is a hyperlink on the text "Download file". When clicking on the link, the user gets a download dialog box and is able to either open or save the file. However, when running in FireFox, there is no link on the text "Download file". How can I make the link appear in FireFox like in IE? Any help is greatly appreciated. Thank you. ASP Page ======= <asp:label id="lblDownload" CssClass="DownloadLink" Visible="False" Runat=server><a id="aDownload">Download file</a> for all facilities in this county in Excel file format.</asp:label> Code Behind ========= Dim strStartupScript As String strStartupScript = "<script language=JavaScript>" strStartupScript = strStartupScript & " aDownload.href='" & Application("strFileFolder") & "/" & Session("strFIPSCountyCode") & ".xls'" strStartupScript = strStartupScript & "<" & "/" & "script>" Page.RegisterStartupScript("scriptSetHref", strStartupScript)

I have just done some more testing and finally got my problem resolved. I have an application that has a link to printer-friendly version page. Instead of using RESPONSE.REDIRECT to redirect my page to the printer-friendly page, I used javascript to change DOCUMENT.LOCATION. When I used DOCUMENT.LOCATION, it added two entries in the history instead of one. Therefore, when I clicked on BACK button, I was stuck with the printer-friendly page. Now that I use RESPONSE.REDIRECT, the history looks fine and I can return to the proper page. Thank you for your response.

Is there a way that I can find out if the BACK button has been clicked?

I tried to write client-script code in ASP.NET code behind (as shown in bold below) using Visual Studio.NET, but somehow it keeps on telling me that either RegisterClientScriptBlock or IsStartupScriptRegistered are not members of System.Web.UI.Page. Could anyone please help me with this? Thank you. ========================================================== Public Class LaborDistributionDownload Inherits System.Web.UI.Page #Region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub Protected WithEvents Form2 As System.Web.UI.HtmlControls.HtmlForm Protected WithEvents btnDownload As System.Web.UI.WebControls.Button Protected WithEvents DIV1 As System.Web.UI.HtmlControls.HtmlGenericControl Protected WithEvents LinkButton1 As System.Web.UI.WebControls.LinkButton Protected WithEvents aDownloadNow As System.Web.UI.HtmlControls.HtmlAnchor 'NOTE: The following placeholder declaration is required by the Web Form Designer. 'Do not delete or move it. Private designerPlaceholderDeclaration As System.Object Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub #End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim strStartupScript As String strStartupScript = "<script language=JavaScript>" strStartupScript = strStartupScript & "aDownloadNow.href='" & Session("strReportFolder") & "/" & Session("strFileName") & "" strStartupScript = strStartupScript & "<" & "/" & "script>" If (Not Page.IsStartupScriptBlockRegistered("scriptSetHref")) Then Page.RegisterStartupScriptBlock("scriptSetHref", strStartupScript) End If End Sub End Class

I wrote an asp.net page that submits a query string to SQL Server. The result is then filled in a dataset, and a report in .pdf is generated from the dataset. If the result is limited to a small set of records, the report is displayed. If the result ends up with larger number of records, I got the following error. The query seems to time out in 35 seconds. I'm not quite sure what causes the timeout problem. Any help is appreciated :) . ========================================================== Server Error in '/LaborDistribution' Application. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source Error: Line 103: gdsLaborDistributionResult = New dsLaborDistributionLine 104: gdsLaborDistributionResult.Tables("LaborDistribution").Rows.Clear()Line 105: daLaborDistributionResult.Fill(gdsLaborDistributionResult, "LaborDistribution")Line 106:Line 107: daLaborDistributionResult = Nothing Source File: c:\inetpub\wwwroot\LaborDistribution\LaborDistributionQuery.aspx.vb Line: 105 Stack Trace: [sqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) LaborDistribution.WebForm1.btnSubmit_ServerClick(Object sender, EventArgs e) in c:\inetpub\wwwroot\LaborDistribution\LaborDistributionQuery.aspx.vb:105 System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e) System.Web.UI.HtmlControls.HtmlInputButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain() Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

That works out great!! Thank you so much wayneph. I appreciate it.

Thank you for your response. I am working with the Datatable object which is part of a Dataset object. The Datatable object is created in the code. I programmatically add new data to the Datatable object. What I try to do is to verify that the new data to be added to the Datatable does not already exist in the Datatable. If you have any suggestion, I'll appreciate it. Thanks.

I need to search for a value in the primary key column in a datatable to see if there is a match. If there is a match, I will display a message that this is a duplicate value. How do I search a value in the primary key column, or are there different ways of accomplishing this? Any help is appreciated.

Thank you Thank you so much Robby. I really appreciate your help. :)

I have a datalist that has 3 columns. The user will click on the first column of a record and my application is supposed to pop-up a window that will display comments for that record. Should I use Linkbutton or Hyperlink control for the first column? How can I have a window pop-up with a predefined size? Any help is greatly apprecitated.