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.

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 is a pointer which does not point valid object. When a pointer has 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);
}