Friday 14 July 2017

Variable to SQL Query

Sometimes there is a need to store a SQL query output to a variable in store procedure. This feature gives programming flexibility to apply more action while generating output.
For example, you can apply more group option in a simple way which was complicated in a single query or if you want to concatenate the output of some query etc.

USE [Girfa_Portal]
GO
SET ANSI_NULLS ON

Thursday 13 July 2017

Register Variable

Register Variable C Language


Register is a special type of storage medium for making variables in c language. When there is a need of access any variable very frequently like inside of loops. For increase of access time of a variable it can be take place direct on register. If a variable is on a register then its take less time compare to access a variable form memory because register is a part of CPU.

Wednesday 12 July 2017

Multiple Condition with parameter in sql server

Multiple Condition with parameter in sql server


USE [Girfa_Portal]
GO
--=========== Condition with concatenate =========================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Girfa]
(@arg varchar(500))

Tuesday 11 July 2017

Auto variable

Auto variable "C" Language


Auto or local variable in c language is a type of variable which space allocate and deallocate space automatically and static in by nature. An auto variable is invisible from outside of a function or block. So an auto variable can be access within the block where it is defined. By default all variable in a block or function is auto by nature. Auto keyword is used to make auto variable which is optional.

Auto int a;

Or

Int a


#include<stdio.h>
void main()
{
     int a=10;

Putch

Putch "C" Function 

Print a single alphanumeric character. This function can  print only one character at a time.

Syntax :

Putch(Var_name)

Example :                  


#include<stdio.h>
void main()

CSS Animation


Father of CSS Animation

CSS Animation

tada

Main CSS Code


@charset "UTF-8";

/*!
 * animate.css -http://daneden.me/animate
 * Version - 3.5.2
 * Licensed under the MIT license - http://opensource.org/licenses/MIT
 *
 * Copyright (c) 2017 Daniel Eden
 */

Monday 10 July 2017

Putchar

Putchar 'C 'Output Function 

Putchar write a character to standard output (monitor). It takes argument as character and returns its integer form without sign. If a writing error occurs, EOF is returned and the error indicator (ferror) is set.
#include<stdio.h>
void main()
{
     char ar[]={"Girfa"};

Sunday 9 July 2017

Getchar

Getchar Function

Getchar takes input a character from standard input (stdin) and return integer value without sign.

int main(void)
{
   int c;

   /* Note that getchar reads from stdin and

Saturday 8 July 2017

getche

Getche function

Getche is same as getch function, both takes input from keyboard the difference is return type.
  • Getch does not echo given character only return integer value
  • Getche  echo and return integer code of given character

#include<stdio.h>
void main()
{
    char n;

Getch

Getch takes input a character from keyboard.  Getch is different from scanf because user need to press enter explicitly to complete input process but getch intensely return pressed key ASCII.

Some people used getch  to hold program output because when getch excuted it wait for a character and until user press a character next statement would not get executed.

Friday 7 July 2017

Switch Case C Language

Switch Case


A switch case is uncomplicated solution/alternate of complicated nested if-else. It is useful when there is a need check to arise multiple possibility on single variable like print day of the week name based on the given day number. Best for long if statements that compare a variable to several "integral" values ("integral" values are simply values that can be expressed as an integer, such as the value of a char).

Switch case syntax

Above figure is showing syntax of switch case. In syntax break and default are in bracket, which means they are optional. You can use more than one case without using break. If break is omitted, then all the ca

Thursday 6 July 2017

Java Script Date dd/mm/yyyy format

Get Java Script Date dd/mm/yyyy format

<html>
<head>
    <title>Girfa Student Help</title>
    <script>
        function GetDate()
        {
            var d = new Date();

Lucas Series

Lucas Numbers similar to the Fibonacci series that often occurs when working with the Fibonacci series. Edouard Lucas (1842-1891) (who gave the name "Fibonacci Numbers" to the series written about by Leonardo of Pisa) studied this second series of numbers: 2, 1, 3, 4, 7, 11, 18, .. called the Lucas numbers in his honour. On this page we examine some of the interesting properties of the Lucas numbers themselves as well as looking at its close relationship with the Fibonacci numbers. The following page generalises further by taking any two starting values.

/* #######    Girfa Student Help ###############
      Lucas Sequesnce Program
      for more program visit : https://girfahelp.blogspot.in/p/c-language-assignment.html
  ##############################################  */
#include<stdio.h>
void main()
{
    int a,b,c;
    clrscr();
    a=1;

Saturday 24 June 2017

Number to word convert

Q : Write a program to convert a number into its equivalent word without using character array?

/* ##########################################
     Girfa : Student Help
     Program : Number to word converter
     for more program visit :
   ##########################################*/
#include<stdio.h>
#include<conio.h>
void single(int);
int reverce(int);
void ten(int);
void hundred(int);
void printhundred(int);
void main()
{

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.In relational databases, operations are made on a set of rows. For example, a SELECT statement returns a set of rows which is called a result set. Sometimes the application logic needs to work with a row at a time rather than the entire result set at once. In T-SQL, one way of doing this is using a CURSOR. For example when we want to get record from one table and need to insert into another with performing some logic or some conditions .For example if we want to get value from one table row by row  and need to perform some logic over that and update /insert into another table then we can use cursors. Cursor basically works as for/While loop.

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.