Thursday, 22 June 2017

Looping With Cursor SQL Server

Cursor is an database object which is use when there is a need to process table record row by row . you can access each field of your table at record by record.

USE [Girfa_tportal]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
alter procedure [dbo].[GetStudentContact]
as
begin
Declare @phone as varchar(15)
Declare @email as varchar(50)

Wednesday, 21 June 2017

Multiple Return SQL Server Function

Table value function

For return more than value from SQL-Server? To do so you need to make table value function.
A table value function use to return more than one value in the form of table.

USE [Girfa_portal]
GO
/****** Girfa Student Help ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create FUNCTION [dbo].[getBookIssueFineDay]
(
       @roll int
)
RETURNS  TABLE
as

Tuesday, 20 June 2017

SQL Server Function

Function declaration

USE [Girfa_Portal]
GO
/****** Girfa Student Help******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[getBookStock] (@bookcod varchar(50))

RETURNS int
AS

Saturday, 17 June 2017

PHP Hotel Management Project

PHP Hotel Management Project 

Hotel Management  Project Free Download

This project target Hotel Website or computer science student for their project work. Anyone who wants to make a website on Hotel Management or Any student want to submit their project on the topic of Hotel Management then this project is best solution. I have made it simple, Responsive for all device and professional look. Intention of this project is only for learning for earning money so any use of this project for earning money is prohibited. 

Video Shop 




Live Preview

Thursday, 15 June 2017

Delete Data Grid View Row

Delete Data Grid View Row


There is lots of programming condition when we need to delete a row from data grid view. Deleting a record from Datagridview is pretty simple you just need know following point
  • Datagridview event for detect right click of mouse button
  • Context Menu setting

Tuesday, 13 June 2017

Zombie Process

In UNIX or its similar OS environment if a process stops running abnormally but its entry has not removed from process table known as Zombie Process.

Reason


If a process gets stop with exit and meanwhile parent process is sleeping then parent will be able to known the status at sleeping moment and entry of the killed process still in process table which imply Zombie.

Friday, 9 June 2017

C Language NIELIT Exam Paper Solution

NIELIT O Level
C Language  Paper Answer 
January - 2015

1: Objective 


1.1 B
1.2 : C
1.3 : D
Explanation :  Because pointer is not being part of any equation so option a and d is equal.
1.4 : D

Write a C program to modify the constant variable.

Q : Write a C program to modify the constant variable.

Solution : 


#include<stdio.h>
void main()
{
const int a=1;
int *p;

Thursday, 8 June 2017

What is automatic type promotion in c

Q :  In the following declaration statement:

char c=’A’;
Variable c stores one byte of memory space while character constants ‘A’ stores one byte memory space. How one byte variables can stores two byte character constant? What is automatic type promotion in c?

Solution : 


Character constant reserve two byte of memory space to represent octal or hexadecimal character constant but char variable stores only its one byte ASCII value.

In C language, char type is used to store a 1 byte integer. When you assign 'A' to char c, you are not assigning the letter A itself into memory. Rather, you are assigning the number (integer) representing the A character. Each letter has a digit that represent it. . Remember that unlike humans, computers cannot understand letters. That's why we need a way to translate them into digits. To do this we use differnet coding styles like: ASCII, UTF-8, etc If your machine use ASCII coding then the value assigned to char c would be 65 (0x41 hex). As you may notice, 0x41 is one byte and can be stored in your char variable.

Automatic type promotion


Some data types like char , short int take less number of bytes than int, these data types are automatically promoted to int or unsigned int when an operation is performed on them. This is called integer promotion. For example no arithmetic calculation happens on smaller types like char, short and enum. They are first converted to int or unsigned int, and then arithmetic is done on them. If an int can represent all values of the original type, the value is converted to an int . Otherwise, it is converted to an unsigned int.
int main()
{
    char a = 30, b = 40, c = 10;
    char d = (a * b) / c;
    printf ("%d ", d);
    return 0;
}

At first look, the expression (a*b)/c seems to cause arithmetic overflow because signed characters can have values only from -128 to 127 (in most of the C compilers), and the value of subexpression ‘(a*b)’ is 1200 which is greater than 128. But integer promotion happens here in arithmetic done on char types and we get the appropriate result without any overflow.
Consider the following program as another example.

Next Question

Text File Input Through C Language

Q : Write a C program to write a line of string in a text file.

Solution : 

#include<stdio.h>
void main()
{
     FILE *pt;
     char ch[100],c;
     int i;
     pt=fopen("test.txt","w");

Monday, 5 June 2017

Gridview FIll VB.net

Dynamic fill data gridview using VB.net


Public Sub fill_gridview(ByRef dt As DataGridView, ByVal sql As String)
        Dim con As New OleDbConnection(getconstr)
        Dim da As New OleDbDataAdapter(sql, con)
        Dim ds As New DataSet
        Try

Saturday, 3 June 2017

Division Flipper Using CSS


Division Flipper Using CSS

Girfa

Student Help

Full Code : 

<html>
<head>
    <title>Girfa : Flip Effect </title>
    <style>
        .flip-container {
     perspective: 500px;
}
     /* flip the pane when hovered */
     .flip-container:hover .flipper, .flip-container.hover .flipper {
           transform: rotateY(180deg);

Friday, 2 June 2017

Write a C program that displays the recommended actions depending on the color of a traffic light using the switch statement.

Q : Write a C program that displays the recommended actions depending on the color of a traffic light using the switch statement.

Solution : 

void main (void)
{
   char colour;

Thursday, 1 June 2017

Define void data type and write any three use of it.

Q : Define void data type and write any three use of it.

The data type void actually refers to an object that does not have a value of any type. Void is also used to indicate when a function does not return a value or no argument. Such a function is used for its side effect and not for its value. In the function declaration and definition, we have indicated that the function does not return a value by using the data type void to show an empty type, i.e. no value. Similarly, when a function has no formal parameters, the keyword void is used in the function prototype and header to signify that there is no information passed to the function.


What is dangling pointer in C? What is wild pointer in C? Give example.

Q : What is dangling pointer in C? What is wild pointer in C? Give example?

Dangling  Pointer

Dangling or wild card is a pointer which does not point valid object. When a pointer has been declared it must be assign a valid address memory address otherwise it will point some location which is not valid. These are special cases of memory safety violations. More generally, dangling references and wild references are references that do not resolve to a valid destination.

Void main()
{
          int *pt;
          {
                   int c=10;
                   pt=&c;
       
  }
          printf("\n\t%d",*pt);
}

Sunday, 28 May 2017

Setting Combo-box Value and Display Data with VB.Net

I was working on a Brokerage Calculation project where I need to load a table’s data into combo box as in the form of value member and display member because a combo-box store two value ID which not shown at drop down list but reside in combo-box .
We need to Set/Get data through value because it’s mostly primary key and  display mode for display 
field. Take a look on following code:

Dim con As New OleDbConnection(getconstr)
Dim da As New OleDbDataAdapter(sql, con)

Friday, 26 May 2017

What are merits and demerits of array in C?

Q : What are merits and demerits of array in C?

Why we need an array.

We need array when there is a need to process more than data with similar type. For example 
  • Taking marks of 10 student need of ten integer
  • Taking name need of more than one character
  • Structure record and many more

Write a C program to find size of structure without using sizeof operator.

Q  : Write a C program to find size of structure without using sizeof operator.

#include<stdio.h>
#include<conio.h>
struct stu
{
     int roll;
     char name[20];
     float marks[3];
};

Write a C program to find the square root of a given quadratic equation.

Q1 : Write a C program to find the square root of a given quadratic equation.
#include <math.h>

int main()
{
    double a, b, c, determinant, root1,root2, realPart, imaginaryPart;

    printf("Enter coefficients a, b and c: ");
    scanf("%lf %lf %lf",&a, &b, &c);

    determinant = b*b-4*a*c;

Wednesday, 24 May 2017

Write a C program to print given number of terms of a Fibonacci series.

Q 1 :  Write a C program to print given number of terms of a Fibonacci series.

Solution : 

#include<stdio.h>
void main()
{
    int a,b,c;
   c=1;
   a=0;

Write a C program to read a line and print it reverse using recursive function.

Q : Write a C program to read a line and print it reverse using recursive function.

Solution : 


#include<stdio.h>
#include<string.h>
#include<process.h>
void print(int len,char str[])
{
int n=len;
if(n==-1)
exit(1);

Sunday, 7 May 2017

Call by value Call by reference



Call by value

The call by value method of passing arguments to a function copies the actual value of an argument into the formal parameter of the function. In this case, changes made to the parameter inside the function have no effect on the argument.

Wednesday, 3 May 2017

Customized web page print using Java Script




Printing a webpage is another important aspect of web development. If you skip this section then when your user will be print a page then it will print as it is, which not good for all case because we add a lot of formatting images on webpage. So all the things on the page will get printed that will be worse.

Customizing web page output is good practice to make a webpage. Because what we see on web page we don’t need to take output on paper same format so customization is mandatory.


Following example will print table as with custom header.


Roll Name City
101 Sona Vns
102 Amit Alld
103 Sumi Alld
104 Rakesh Vns
105 Jyoti alld

Saturday, 29 April 2017

Stock and Bill Management Project

Stock and Bill Management Project

I have made this project for your practice only this is live project running in whole sale shoes shop. You can use this project as your course final project because I have seen many students who buy project from market or internet so I made this project online for download every one with free of cost. I also suggest student who’re going to make this project as their course project, please take a look on project and understand what the flow of this project working model are. I don’t want to make use this project as shortcut to only submitting your project. No! This is wrong so try to learn some live coding from this project. 

Commercial use of this project without consent  is prohibited.

Project Description


This helps to manage stock and billing of a whole shale shop. Primary this project was design for a shoes shop but it can be apply the business which sells some company project which has further some sub type. All the entry left blank. So you can create your own entry. Some demo records are in download database for sake for understood of project work flow. One you will be understands work flow then you customize this project as your requirement.

Friday, 28 April 2017

Inheritance OOP


Inheritance OOP Banner

Inheritance (Object Oriented Programming)


In object-oriented programming,Inheritance allows us to define a class which is based on another class, which makes it easier to create and maintain an application. This also provides an opportunity to reuse the code functionality and fast implementation time.The derived class is also called subclass and the base class is also known as super-class. The derived class can add its own additional variables and methods. These additional variable and methods differentiates the derived class from the base class.inheritance saves our money and time both because we use predefined compile and tested class which increase quality of software.

Tuesday, 25 April 2017

Function Pointer



   Function pointer is a type of pointer which points a function or code block. You can assign address of a function to function pointer variable and that function using function pointer variable name.


   I have a bad experience while making Calculator. In my design all the calculation takes place when user pressed equal button. When a user pressed equal button I need to check every time which operator user was pressed , checked by switch case, it become complicated then I increase more function in my calculator because of lots condition for operator check and attached code for particular logic separately.


   Now my work becomes simple because of function pointer because I just need to check operator pressed by user and attached related function code to function pointer. It reduces lots of condition checking and assigns separate code to each section. So function pointer is very useful in some specific scenario.


Advantage of function pointer

  • Implement Callback
  • Useful in event handling
  • One entry point for more than one code block

Monday, 24 April 2017

C language function precedence


Question :


Which of the following is the correct order if calling functions in the below code?a = f1(23, 14) * f2(12/4) + f3();

A) f1, f2, f3
B) f3, f2, f1
C) Order may vary from compiler to compiler
D) None of the above

NIELIT O Level C Language Solve Paper July-15

NIELIT O Level C Language Solve Paper with Answer July-15

1 Objective

1.1 A
Explanation : See operator priority table 
1.2: A
1.3 : C
Explanation : Continue statement transfer control to start of loop and when condition will be wrong else stops loop So string will be printed 0 times because its after else statement.

Sunday, 23 April 2017

Microsoft Word Mail Merge

Microsoft Word Mail Merge

Microsoft Word Mail Merge Tutorial in Hindi

Microsoft word has mail merge feature which enable you to make a letter to a huge number of people in an efficient way. Without using mail merge its very

Tuesday, 11 April 2017

O Level Solve Paper Jan 16

O Level Solved Paper

January, 2016 M4.1-R4: APPLICATION OF .NET TECHNOLOGY

Solved Paper

Objective Type Answer


1.1 : B
1.2 : C
1.3: D
1.4 : A
Explanation : Supports all classes in the .NET Framework class hierarchy and provides low-level services to derived classes. This is the ultimate base class of all classes in the .NET Framework; it is the root of the type hierarchy.
1.5 : D
Explanation : The IHttpHandlerFactory interface creates and manages HTTP handlers for processing requests. Therefore, you can create a class that implements the IHttpHandlerFactory interface, and then use that class as an HTTP handler.

Sunday, 9 April 2017

NIELIT A Level Solve Paper 
Java -July-2016
A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA


PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR”answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 Which of the following class is a superclass that declares the common features of GUI
components in packages java.awt and javax.swing?
A) Component
B) Container
C) Panel
D) Frame

Java Solved Paper







NIELIT A Level Solve Paper
Core Java January, 2016
A10.1-R4: INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING THROUGH JAVA

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 Which of the following is valid long literal?
A) 0x99fffL
B) ABCDEFG
C) 0x99fffa
D) 99671246

NIELIT A Level Solve Paper
Core Java Solved July, 2015
A10.1-R4: INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING THROUGH JAVA

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 What does the expression 1.0 / 0.0 return?
A) Double.NaN
B) 0.0
C) Run time exception is generated
D) Double.INFINITY

Friday, 7 April 2017

Java Sample Paper




NIELIT A Level Java Soled Paper
January, 2015
A10.1-R4: INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING THROUGH JAVA


PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)
1.1 Which one of the following is not an AWT Event class?
A) MenuEvent
B) MouseEvent
C) ActionEvent
D) InputEvent

Thursday, 6 April 2017

Java Solved Paper

NIELIT A LEVEL Java Solve Paper
July, 2014
A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which of the following is possible in a class if class is declared as an abstract?
A) Instance block
B) Static block
C) Final method
D) All of the above

Java Solved Paper

NIELIT Java Sample Paper Solved
July, 2013
A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA

PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 Which is a valid key word in Java?
A) Integer
B) unsigned
C) string
D) class

Wednesday, 5 April 2017

Java Solved Paper

NIELIT A Level Solve Paper

January-2013

A10.1-R4: INTRODUCTION TO OBJECT-ORIENTED PROGRAMMING THROUGH JAVA


PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)
1.1 The basic design strategies embedded in object-oriented programming is/are
A) Abstraction
B) Composition
C) Generalization
D) All of the above

Tuesday, 4 April 2017

NIELIT A Level Java Solve Paper Jan-14

 January, 2014
A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA


PART ONE

(Answer all the questions)


1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “OMR” answer sheet supplied with the question paper, following instructions therein. (1x10)


1.1 Methods used to obtain information about an object are known as

A) accessor methods

B) setter methods

C) mutator methods

D) none of the above

NIELIT A Level Java Solve Paper July-12

 July, 2012
A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA


PART ONE
(Answer all the questions)

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

1.1 In UML diagram of a class
A) state of object cannot be represented
B) state is irrelevant
C) state is represented as an attribute
D) state is represented as a result of an operation

Monday, 3 April 2017

What is MAN

NIELIT O Level Solved Paper
Internet and Web Technology


Q: Define MAN. Write down three important features that discriminate MAN from WAN.

A metropolitan area network (MAN) is a network that connect users with computer resources in a geographic area or region larger than that covered by even a large local area network (LAN) but smaller than the area covered by a wide area network (WAN). The term is applied to the interconnection of networks in a city into a single larger network (which may then also offer efficient connection to a wide area network). It is also used to mean the interconnection of several local area networks by bridging them with backbone lines. The latter usage is also sometimes referred to as a campus network.

What is Topology

Nielit O Level Solved Paper
Internet and Web Design

Q: Explain in brief: Bus, Star and Ring Network Topologies

Physical and logical arrangement of devices with a network is known as Topology.


Bus Topology

A bus topology is a network setup in which each computer and network device are connected to a single cable or backbone.A signal from the source is broadcasted and it travels to all workstations connected to bus cable. Although the message is broadcasted but only the intended recipient, whose MAC address or IP address matches, accepts it. If the MAC /IP address of machine doesn’t match with the intended address, machine discards the signal.

Saturday, 1 April 2017

Microsoft Word Table Index

Microsoft Word Table Index Hindi Tutorial

Microsoft Word Table Index,Table of content and reference Tab in HIndi

Microsoft word has reference tab which enable you to male table of index,table of content,Figure Index and many more cover in this video.

Friday, 31 March 2017

Describe the ISDN

Q 5 (a). Describe the ISDN ?

Describe the ISDN ?


Integrated Services Digital Network (ISDN)

Integrated Services Digital Network (ISDN) is a telephone system network. It is a wide area network which is widely available. Before to the ISDN, the telephone system was viewed as a way to transport only voice, with some special services available for data. The key feature of the ISDN is that it integrates speech and data on the same lines, adding features that were not available in the classic telephone system.

Tuesday, 28 March 2017

Database relationship

Database relationship

Microsoft Access is an example of relational database. In relational data base we can join a table to more than one table which makes relationship. With this capability our access database becomes more powerful than non-relational data base category. Consistency of database become easy and easily achieve by database on automatically.  If you want to make relationship in access database then you need at least two tables and one field must be common in both tables. For example, we are going to make relationship between two tables’ student and canteen. Student table store record of student and canteen stores what the products students are having. So in this type of relationship student is master table and canteen is related table. So student table need a primary key which uniquely identified a record from student table. Canteen table must have a key which match the data type of student table primary key which further known as foreign key.

Monday, 27 March 2017

January 2016 M2-R4 INTERNET TECHNOLOGY AND WEB DESIGN

January 2016  INTERNET TECHNOLOGY AND WEB DESIGN

Answer Key

Core Java Assignment 25

Core Java Assignment 25


A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA.

Assignment 25


Some combined bath-showers have two faucets and a lever for controlling the flow of the
water. The lever controls whether the water flows from the showerhead or directly into the
tub. When the water is first turned on, it flows directly into the tub. When the lever is

Core Java Assignment 24

Core Java Assignment 24

A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA.

Assignment 24



A simple digital watch has a display and two buttons to set it, the “A” button and the “B”
button. The watch has two modes of operation, display time and set time. In the display
time mode, hours and minutes are displayed, separated by a flashing colon. The set time
mode has two sub-modes, set hours and set minutes. The “A” button is used to select

Core Java Assignment 23


Core Java Assignment 23


A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA.

Assignment 23


The direction control for some of the first toy electric trains was accomplished by
interrupting the power to the train. Prepare state diagrams for the headlight and wheels of
the train, corresponding to the following scenario:

Power is off, train is not moving.
Power is turned on, train moves forward and train headlight shines.
Power in turned off, train stops and headlight goes out.

Core Java Assignment 22

Core Java Assignment 22


A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA.

Assignment 22



Prepare a class diagram from the instance diagram in the following figure

Core Java Assignment 21

Core Java Assignment 21


A10.1-R4: INTRODUCTION TO OBJECT ORIENTED PROGRAMMING THROUGH JAVA.

Assignment 21


The following is a partial taxonomy of rotating electrical machines. Electrical machines may
be categorized for analysis purposes into alternating current (ac) or direct current (dc).
Some machines run on ac, some on dc, and some will run on either. An ac machine may
be synchronous or induction. A few examples of electrical machines include large
synchronous motors, small induction motors, universal motors, and permanent magnet
motors. Most motors found in the homes are usually induction machines or universal
motors. Universal motors are typically used in where high speed is needed such as in
blenders or vacuum cleaners. They will run on either “AC” or “DC”. Permanent magnet
motors are frequently used in toys and will work only on dc.