ITORIAN BLOG

Today in the morning when I tried to access my one of the website it displayed titled error. I got socked that why this error coming up. The reason was my Database Host Provider where changed the server and he missed something to activate for my database and this causes the error "Database 'compuzitdb1' cannot be opened due to inaccessible files or insufficient memory or disk space" . When I contacted to DB experts they told me to be relax because it is a normal DB error and can be fixed by trying the following checks. 1) If possible add more hard drive space either by removing of unnecessary files from hard drive or add new hard drive with larger size. 2) Check if the database is set to Autogrow on. 3) Check if the account which is trying to access the database has enough permission to perform operation. 4) Make sure that .mdf and .ldf file are not marked as read only on operating system file system level. I hope this post will help you t

To fix this error: (i) Click on Start > Run > Type 'cmd' and press enter (ii) Now type 'svrmgrl' and press enter (iii) Type 'connect' and press enter (iv) Type Username 'internal' and password 'oracle' and press enter (v) Type 'startup' and press enter (vi) Now it will take about 1min to process and finally click 'edit' to close cmd Now start PLSQL, you error is fixed.

Basically packages is set of procedures, functions, cursors, constraints and exceptions in one unit. To execute the package we write the code as follows: EXECUTE SALARY_PACKAGE.NEW_WORKER('MICE'); In above example SALARY_PACKAGE is package name and NEW_WORKER is procedure name. Creating Package To create package user should have the CREATE PROCEDURE privilege. Two create package two techniques have to be done separetly: (i) Creating package specification A package specification includes list of functions, procedures, variables, constraints,  cursors nd exceptions and will be available for package body. CREATE OR REPLACE PACKAGE <NAME> ------- ------- Above code should be saved in saperate file with saperate name. (ii) Creating package body The name of package body should be equal to name of package specification but file name should be different than above file name.  CREATE OR REPLACE PACKAGE BODY <NAME> -------

Method is block of PL/SQL code used to encapsulate the data access method for an object, it is also specified as part of the abstract datatype specification as (CREATE OR REPLACE TYPE  MARKS_TY AS OBJECT) and their body declaration as (CREATE OR REPLACE TYPE BODY MARKS_TY AS MEMBER FUNCTION TOTMARKS()). Before to learn methods it is recommanded to get overview the abstract datatype teqniques.  Creating specification CREATE OR REPLACE TYPE MARKS_TY AS OBJECT (M1 NUMBER(3), M2 NUMBER(3), M3 NUMBER(3), MEMBER FUNCTION TOTMARKS(M1 IN NUMBER, M2 IN NUMBER, M3 IN NUMBER) RETURN NUMBER); In above example, TOTMARKS is declaration of function which will be used later in function calling to get defined.  Defining function (body declaration) CREATE OR REPLACE TYPE BODY MARKS_TY AS MEMBER FUNCTION TOTMARKS(M1 NUMBER, M2 NUMBER, M3 NUMBER) RETURN NUMBER  IS  BEGIN RETURN(M1+M2+M3); END; END; / Creating table using above abstract datatype MARKS_TY CREATE TA

After long wait now MVC 4 Beta is available for download, released on 15 Feb 2012. If you are still using ASP.NET MVC 3 or prior version, then check out its new version. ASP.NET MVC 4 is a framework for building scalable, standards-based web applications using well-established design patterns and the power of ASP.NET and the .NET Framework. Top Features ASP.NET Web API Refreshed and modernized default project templates New mobile project template Many new features to support mobile apps Recipes to customize code generation Enhanced support for asynchronous methods Find more details here: http://www.asp.net/mvc/mvc4

In this video you will learn how to use @Html.ActionLink() in MVC. You will also learn how to use images in ActionLink().