Friday, April 26, 2013

How to hide a row conditionally in crystal report

Crystal Reports ----->Report----->Selection Formula---->Record

write the following formula

{DataTable1.IssueQty}<>0;

It means If the value of IssueQty is not equal to 0 the a row will be visible otherwise visible is false

Saturday, April 20, 2013

Windows Vista and Windows Server 2008 and later Adding Firewall Exception to Allow remote Database Access

To open a port in the Windows firewall for TCP access

  1. On the Start menu, click Run, type WF.msc, and then click OK.
  2. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.
  3. In the Rule Type dialog box, select Port, and then click Next.
  4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next.
  5. In the Action dialog box, select Allow the connection, and then click Next.
  6. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.
  7. In the Name dialog box, type a name and description for this rule, and then click Finish.

Microsoft.ACE.OLEDB.12.0 provider is not registered in windows server 8

Basically, if you're on a 64-bit machine, IIS 7 is not (by default) serving 32-bit apps, which the database engine operates on. So here is exactly what you do:

1) ensure that the 2007 database engine is installed, this can be downloaded at: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

2) open IIS7 manager, and open the Application Pools area. On the right sidebar, you will see an option that says "Set application pool defaults". Click it, and a window will pop up with the options.

3) the second field down, which says 'Enable 32-bit applications' is probably set to FALSE by default. Simply click where it says 'false' to change it to 'true'.

4) Restart your app pool (you can do this by hitting RECYCLE instead of STOP then START, which will also work).

5) done, and your error message will go away.

Monday, April 8, 2013

Asp.net Menu Item Not Shown In internet Explorer

In the Head Section  of Pages or Master pages Just write the following Code

<
meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />

Sunday, April 7, 2013

Element or class LIKE selector for JQuery

  • [class*=main] will select elements whose classname contains 'main'
  • [class~=main] will select elements whose classname has the word 'main' (delimited with spaces)
  • [class$=main] will select elements whose classname ends in 'main'
  • $("[class^=main]") will select all elements whose classname starts with 'main'