Posts

Crystal Report FAQ Error and Fixes

-
CrystalReports Crystal Report Versions: CrystalReports.com CrystalReports.com/download/ Crystal Reports, Developer for Visual Studio Downloads Common Errors for runtime version: 13.0.22.2668 Error: Failed to load database information. Details: Error in File rpt*** 17596_15752_{FC2EA1BF-082D-4345-947E-BE235A441BFD}.rpt: Failed to load database information. Details: System . Web . HttpExceptionThe file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist . System . Web . HttpException ( 0x80004005 ) : The file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist . at System . Web . UI . Util . CheckVirtualFileExists ( VirtualPath virtualPath ) at System . Web . Compilation . BuildManager . GetVPathBuildResultInternal ( VirtualPath virtualPath , Boolean noBuild , Boolean allowCrossApp , Boolean allowBuildInPrecompile , Boolean throwIfNotFound , Boolean ensureIsUpToDate ) at System . Web . Com...
Post a Comment
Read more

MS Sql Server Local DB

-
Web.Config file: <add connectionstring="Data Source=(LocalDb)\MSSqlLocalDB; Initial Catalog=[database-name]; Integrated Security=True" name="ConnectionString" providername="System.Data.SqlClient" /> Connect to Local DB: Open Visual Studio: Menu: Tools > Connect to Server > Left navigation bar > New Data Connection: Server Name: (LocalDb)\MSSqlLocalDB drop database "myDB";  create database "myDB"; -- Check the logical file name (1st column) after running this query RESTORE FILELISTONLY FROM DISK = 'E:\Ismail\Projects\VPT_TVL\vpt\database\VPT.bak'; -- Place the Logical file name after MOVE statement, and a path where database files will be created RESTORE DATABASE "myDB" FROM DISK = 'D:\database\myDB.bak' WITH MOVE 'myDB_Data' TO 'E:\database\TVL_PT_Data.mdf',      MOVE 'myDB_Log' TO 'E:\database\TVL_PT_Log.ldf', REPLACE;
Post a Comment
Read more

Oracle Cheats Sheet

-
Oracle Cheats Sheet Managing Server Switch to oracle user # root # su oracle Start DB oracle$sqlplus /nolog SQL> conn sys/password as SYSDBA #to start database SQL> startup #to shutdown database immediately SQL> shutdown immediate SQL> exit Start Listner #oracle$LSNRCTL >start - to start >status - to check current status >stop Start Enterprise Manager Url: http://iPAdress:5500/em oracle$$ORACLE_HOME/bin/./emctl start dbconsole Start iSqlplus Url: http://iPAdress:5560/isqlplus oracle$$ORACLE_HOME/bin/./isqlplusctl start http://localhost:5560/isqlplus use "system" as user name and password given during installation How to connect to a remote Oracle server using Oracle Client: C:\Documents and Settings\User.Domain>sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 25 13:13:36 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: userName/password@iP...
Post a Comment
Read more

Export DataTable or DataSet to CSV or XML

-
using System ; using System.Collections.Generic ; using System.Configuration ; using System.Data ; using System.Data.SqlClient ; using System.IO ; using System.Linq ; using System.Text ; using System.Web ; using System.Web.UI ; using System.Web.UI.WebControls ; using System.Xml.Serialization ; public partial class ExportReservationInfo : System . Web . UI . Page { #region Events protected void Page_Load ( object sender , EventArgs e ) { lblMsg . Text = "" ; if ( Page . IsPostBack ) { } } protected void btnExportToCSV_Click ( object sender , EventArgs e ) { string strReservationId = txtReservationId . Text . Trim (); DataSet ds ; try { int ReservationId = Convert . ToInt32 ( strReservationId ); ds = ExecuteQuery ( ReservationId ); //Export to CSV ExportToSpr...
Post a Comment
Read more