Friday 7 December 2018

Last Created Store Procedure SQL Server


SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo'
order by last_altered desc


Thursday 29 November 2018

Solved : January, 2012 M4.2-R4: INTRODUCTION TO MULTIMEDIA

Multiple Choice


1.1 : C
1.2 : A
1.3 : D
1.4 : A

Monday 26 November 2018

Get input type file size in KB


HTML

<input type="file" class="upload" onchange="readURL(this)" id="file" accept="image/x-
png,image/jpeg" />

<input type="button" value="Upload" class="btn btn-default" style="margin:auto;display:block" onclick="checksize(this)" />

Java Script

Get File Name in JavaScript:
document.getElementById('file').files[0].name
Get File Size in JavaScript:

Saturday 10 November 2018

Alter Table SQL Server

Making Unique key


Syntax :

alter table your_table add constraint constraint_Name  unique(yourcolumn);

Tuesday 30 October 2018

2013 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice


1.1 : A
1.2 : C
1.3 : B
1.4 : C
1.5 : A
1.6 ; B
1.7 : A
1.8 : A

Wednesday 24 October 2018

Jquery Preloader


Girfa Student Help

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specim

Monday 15 October 2018

Solved July, 2013 M4.2-R4: INTRODUCTION TO MULTIMEDIA

1  Multiple Choice


1.1 : D
1.2 : B
1.3 : A
1.4 : D
1.5 : D
1.6 : A

1.7 : D
1.8 : A
1.9 : D
1.10 : B

2 True/False

2.1 : T
2.2 : T
2.3 : T

Tuesday 2 October 2018

January, 2014 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice


1.1 : B
1.2 : A
1.3 : B
1.4 : C
1.5 : B
1.6 : D
1.7 : A

Monday 1 October 2018

HTML Tag CSS

<a> style change
    a.menu:link {color:black;}      /* unvisited link */
    a.menu:visited {color:black;}  /* visited link */
    a.menu:hover {color:#CCFF99;}  /* mouse over link */
    a.menu:active {color:yellow;}  /* selected link */

    a.menu:link{text-decoration: none} /* Hide Underline of link */

Example : <a class="menu">Link test</a>

Next Example

Wednesday 22 August 2018

Setup locale date time zone


SQL server saves date in local region format, for example if you’re in india and hosting your site with godaddy and choose Asia server then your date will be 12 hour forward compare to current region.

Sunday 19 August 2018

July, 2014 M4.2- R4: INTRODUCTION TO MULTIMEDIA Solved


Multiple Choice


1.1 : C
1.2 : A
1.3 : C
1.4 : B
1.5 : C
1.6 : C
1.7 : A
Explanation : Old 2D cel animation and stop-motion animation both fall under the category of traditional animation,  both may use digital methods of filming in the end. The matters is the method of producing the animation itself. Cel animation uses hand-drawing, hand-inking, and hand-painting thousands of frames on clear cels that are displayed against painted backgrounds and photographed in rapid sequence, on the other end stop-motion animation involves working with physical models and objects captured on camera one frame at a time.

This hands-on method requires a team of artists, cleanup artists, painters, directors, background artists, and camera crews, along with the storyboard artists and scriptwriters to work out the original concepts. For large-scale projects, the amount of time, labor, and equipment involved is staggering.

1.8 : B

Monday 13 August 2018

January 2015 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice


1.1 : D
1.2 : A
1.3 : C
1.4 : A
1.5 : B
1.6 : B

Friday 3 August 2018

July, 2015 M4.2-R4: INTRODUCTION TO MULTIMEDIA Solved

Multiple Choice


1.1 : C
1.2 : D
1.3 : A
1.4 : D

Friday 27 July 2018

M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN-July-12 Solved

Multiple Choice


1.1 : A
1.2 : B
1.3 : D
1.4 : A
1.5 : A
1.6 : D
1.7 : B
1.8 : C

Wednesday 25 July 2018

M2-R4 INTERNET TECHNOLOGY AND WEB DESIGN-Jan-13 Solved

Multiple Choice


1.1 : C
1.2 : C
1.3 : B
1.4 : A
1.5 : B
1.6 : D
1.7 : D
1.8 : C
1.9 : B
1.10 : D

Sunday 22 July 2018

Input type pattern





Form tag is one of the key tags of HTML through which users data are sent on server. While making a form there are lots of validation implemented to allow valid data only. As a developer we all know about importance of validation and we do lots of JS code for validation. Working with JS is not an easy task for beginner.

HTML 5 introduce built in validation using regular expression using pattern property. If you are using patter regular expression then this will save your time and it is supported by all model browsers. So using pattern, you do not to worry about browser compatibility.

Following code will help you to understand basics of pattern. Ones you will implement basics then after using regular expression you will be able to implement complicated validation rule.

Name :

Six Digit Pin :

Email :


Monday 16 July 2018

INTERNET TECHNOLOGY AND WEB DESIGN July, 2013 Solved

Multiple Choice


1.1 : C
1.2 : B
1.3 : B
1.4 : B
1.5 : C

Thursday 12 July 2018

M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN January, 2014 Solution

Multiple Choice


1.1 : D
1.2 : C
1.3 : C
1.4 : A
1.5 : A
1.6 : C

Tuesday 3 July 2018

Solved July, 2014 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice


1.1 : B
1.2 : C
1.3 : B
1.4 : A
1.5 : C
1.6 : B

Tuesday 26 June 2018

Solved July, 2015 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice


1.1 : C
1.2 : A
1.3 : B
1.4 : D
1.5 : C
1.6 : A
1.7 : A
1.8 : C

Solved January, 2015 M2-R4: INTERNET TECHNOLOGY AND WEB DESIGN

Multiple Choice

1.1 : C
1.2 : A
Explanation : Shortest Seek Time First
1.3 : D
Explanation : 
Seek time: Say you're reading some data from the (0,4). You receive instructions to read from track (2,5). The time it takes for you to move from track 0 to track 2 is seek time.

Sunday 24 June 2018

M1-R4: IT TOOLS AND BUSINESS SYSTEMS July 2011 Solution

Multiple Choice


1.1 : A
1.2 : B
1.3 : B
1.4 : A
1.5 : C
1.6 : D
1.7 : D

Friday 22 June 2018

Paper IT Tools and Business Systems January 2011 Solution

Multiple Choice

1.1 : D
1.2 : D
1.3 : B
1.4 : A
1.5 : D
1.6 : B
1.7 : B

Wednesday 20 June 2018

IT Tools and Business Systems -July-2010 Solution

Multiple Choice


1.1 : B
1.2 : B
1.3 : B
1.4 : D
1.5 : B
1.6 : A
1.7 : B
1.8 : A
1.9 : C

Sunday 17 June 2018

IT TOOLS AND BUSINESS SYSTEMS Jan-12 Solved

Multiple Choice


1.1 : B
1.2 : B
1.3 : C
1.4 : D
1.5 : C
1.6 : A
1.7 : B

July, 2012 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solution

Multiple Choice


1.1 : D
1.2 : D
1.3 : D
1.4 : D
1.5 : D

Monday 11 June 2018

Paper M1-R4: IT TOOLS AND BUSINESS SYSTEMS-jan-13 Solution

Multiple Choice


1.1 : A
1.2 : C
1.3 : B
1.4 : D
1.5 : A
1.6 : B
1.7 : D
1.8 : A
1.9 : D
1.10 : C

Saturday 9 June 2018

July, 2013 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Solution

Multiple Choice

1.1 : C
1.2 : D
1.3 : B
1.4 : C
1.5 : A
1.6 : D
1.7 : C
1.8 : B
1.9 : B
1.10 : C

Wednesday 6 June 2018

CSS Selector



This page will help you to learn how you can user CSS on various types of HTML tag. If you have knowledge of CSS selector then you can make big changes of fo

Sunday 3 June 2018

July-2014 M1-R4: IT TOOLS AND BUSINESS SYSTEMS Answer

Multiple Choice


1.1 : C
1.2 : B
1.3 :  D
1.4 : B
1.5 : D
1.6 : D

Wednesday 30 May 2018

Image zoom inside of div






HTML

<div class="con">
<img src="1.jpg" class="test"/>
</div>

CSS

.test
{
       height:200px;
       width:200px;

Monday 28 May 2018

Solution : July, 2015 M1-R4: IT TOOLS AND BUSINESS SYSTEMS

Multiple Choice :


1. D
2.C
3.D
4.:A
5:C
6: B

Saturday 26 May 2018

import multiple CSS using single link

CSS file

File A1

.r1
{
       color:red;
}
File A2

.r2
{
       color:green;
}

File A3

.r2

Wednesday 16 May 2018

Get Date Time (dd/mm/yyyy)


<script>
       var d = new Date();
       document.write(d.getDate() + '/' + (d.getMonth() + 1) + '/' + d.getFullYear());

Tuesday 8 May 2018

Rules to declare a valid variable

List out the rules to declare a valid variable in ‘C’ program. Evaluate the following expression and show the hierarchy of operations:
( 2 + 4 ) / 3 + 2%3 * 2 – 5

Solution : 

Read List out the rules to declare a valid variable 

Expression Solve Steps

  • (2+4)/3+2%3*2-5
  • 6/3+2%3*2-5

Sunday 6 May 2018

Humanoid Robot MBA Project

Humanoid  Robot MBA Project

Humanoid
Robot

Table of Content

    1. Acknowledgement
    2. Certificate
    3. Student  declaration
    4. Introduction

Friday 4 May 2018

Structure Programming



Structure programming is a programming approach in which all the programming task is achieved through function/Methods that is sometimes it’s called modular programming. Structure programming uses procedure approach to solve a program using top down methodology. 

One big advantage of structure programming language is simplicity because we have to design programming task in modules which are connected to each other and can be called from any functions. We have all the modern powerful programming stuff like loop, switch-case, if-else etc that help to reduce the uses of goto statement because goto statement makes our program unstructured due to random move to any other statements.

Monday 30 April 2018

While Loop with example

Q : Write and explain the action of WHILE statement. Develop a program in ‘C’ language to compute the average of every third integer number lying between 1 and 100. Include appropriate documentation.

Solution : 


Array Input using function

A, B and C are three 3x3 matrices containing real elements. Write a ‘C’ function to input from user appropriate values into matrices A and B. Use suitable loops. Make use of pointers if necessary.

Solution : 

/*==============================
Girfa Student Help
Program : 3x3 Array input using function
More Program : http://girfahelp.blogspot.in/p/2-d-array-programming.html
================================*/
#include<stdio.h>
#include<conio.h>
#define MAX 3
void input(int [][MAX]);
void print(int [][MAX]);

Wednesday 25 April 2018

HTML Sample Paper



Internet & Web Design (HTML)

Note : each Question carry one marks of part and only three question need to attempt in part two, each carry 10 marks . No negative marks penalty for wrong answer.
Name : __________________                                                                                                                   Time : 45  Minute


Part 1
Multiple Choice
1. ………. Is Self-close tag .
A) strong   B) pre   C)img   D) None
2. Each property of HTML tag is separated by
A) Double quote   B) Single quote   C) /   D)None
3.  Special character code in HTML start with ….
A) &    B)@     C)#    D)None
4.  tag doesn't usually appear in your document. But identify the page's author, keywords used for searching.
A) <head>    B) <title>   C) <meta>    D)<script>
5. Which of the following is odd one for a form.

Thursday 5 April 2018

Structure sorting,searching with array

Define a structure that describes a hotel. It should have members that include the name, address, grade, average room charge and number of rooms.

Write a function to perform the following tasks.

i) To print all hotels details of a given grade in order of charges.
ii) To print hotel details with room charges less than given values.

Solution :
/********************************
     Program : Structure sorting,searching with array
     for more program visit :http://girfahelp.blogspot.in/p/c-language-structure-programming.html
**********************************/
#include<stdio.h>
#include<conio.h>
#include<string.h>
#define MAX 10
typedef struct ht
{
     char name[30];
     char address[40];
     char grade;
     int room;
     int charge;
}hotel;
void input(hotel*,int);
void print(hotel *);
void printbyRate(hotel *,int,int);
void printByGrade(hotel *str,char,int s);
void main()
{
     int i,opt,rate;
     hotel rec[MAX];
     char ch;
     clrscr();
     printf("How many record you want to insert>> ");
     scanf("%

Thursday 29 March 2018

Get Single value from database using ajax



Store Procedure


USE [Girfa_StudentHelp]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER proc [dbo].[GetPhone]
(
   @id int

Thursday 22 March 2018

Get Data from server Using ajax

Target Audience


Beginners who are learning C# MVC and want to get record from SQL server to browser using jquery  ajax.

Store Procedure

USE [Girfa_StudentDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter proc [dbo].[GetStudentList]
AS
BEGIN
     SET NOCOUNT ON;
           select roll,name,city from dbo.Student

     SET NOCOUNT OFF;
END

View

<input type="button" value="Get Data" onclick="GetData()"/>
<table>
    <thead>

Tuesday 20 March 2018

Internet & Web design Sample paper set 2

I
Internet & Web Design

Time: 1 hour                                                                                           Name: ______________

Note: All question of part-1 is mandatory and each question is carrying one marks. 2 questions are compulsory out of 4 from part-2.

(Part one)
Multiple Choices

1.  Effectiveness of data communication is depend on
a)      Delivery   b) Accuracy   c)Timeliness   d)All

2. Which of the following is not considered as network performance criteria?
a) Performance    b) Reliability   c)Security   d) Brand

3. Application of data communication is
a) Marketing & Sales   b)Manufacturing c) EDI  d) All

Sunday 18 March 2018

Longest common sequence


Given sequences say “MNOP” and NPA

Longest common sequence of LCS is a sequence that appears in the same relative order in both the given sequence but not necessarily in a continuous manner.

See the example

M
N
O
P

Saturday 17 March 2018

Time Complexity

Time Complexity

O(expression) is the set of functions that grow slower than or at the same rate as expression. It indicates the maximum required by an algorithm for all input values. It represents the worst case of an algorithm's time complexity.

Thursday 15 March 2018

ROW_NUMBER SQL Server


When SQL query has been run a query for create some output then sql server track number row on per partition returned. Which you can show using row number on the basis of following example


Syntax:

SELECT ROW_NUMBER() OVER (Order by Column_name) AS RowNumber,Col1,Col2,…
FROM dbo.newadmission

Monday 12 March 2018

Cyclic Redundancy check



CRC (Cyclic Redundancy check)




CRC is error detecting technique which is used to detect an error occurred during transmission. CRC technique used in networking, cd, dvd and many other types of memory devices. CHKDSK check disk error using CRC algorithms to find any error. 

A pattern of 0s and 1s can be represented as a polynomial with coefficient of 0 and 1. The power of each term shows the value of the bit. 

Algorithm



  • Take Bit stream for transfer. 
  • Divide your bit stream with a divisor which used both sender and receiver. Divisor may have any bit stream 0 or 1 but used the same for both end. 
  • Divisor can also be represent using polynomial series as following rule.

Monday 5 March 2018

Single Row Access MVC Razor

This post target when there is a need to get only single row and display them on a cshtml view.


@model Britanic_MIS.Models.CustomerModel

Wednesday 28 February 2018

Generate HTML control using Razor

Generate HTML control using Razor

MVC Razor is a powerful technique to generate HTML controls. So I have created this post to demonstrate you to how can you generate simple HTML controls using razor code.

Textbox

Razor        

@Html.TextBox("Test",null, new { placeholder=@Model.FullName, @class = "form-control",@onclick="test()" })

Generated Code