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

Monday 26 February 2018

Delete Record MVC Ajax



Target User

Beginner He/She learning MVC and want to delete a record by clicking on delete button on table row.

Table Stucture


Field
Data Type
Roll
Bigint
Name
Varchar(20)
City
Varchar(20

Model

public class StudentModel
{
    public int Roll { get; set; }
    public string Name { get; set; }

    public string City { get; set; }
}

Controller

//Show Record Page
public ActionResult ShowData()

Saturday 24 February 2018

Plane C Graphics


Plane C Graphics





/*==============================
      Girfa Student Help
      Program :Plane C Graphics
      More Program :http://girfahelp.blogspot.in/p/graphics-c-language.html
================================*/
#include <graphics.h>
#include <stdlib.h>
#include <stdio.h>
#include <conio.h>
#include <dos.h>
void drawplane(int);
int main(void)
{
   /* request auto detection */
   int gdriver = DETECT, gmode, error

Record Update ajax MVC


Field
Data Type
Roll
Bigint
Name
Varchar(20)
City
Varchar(20
Table Structure 1



Store Procedure

USE [Girfa_Studb]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER proc [dbo].[UpdateProduct]
(
@roll bigint,
@name varchar(100),
@city varchar(100)

)

Friday 23 February 2018

Save Data MVC Ajax

Target audience

Beginners learning MVC and want to save a from record into database using ajax.

Table Structure

Roll
Bigint
Name
Varchar(20)
City
Varchar(20)

Store Procedure

USE[Girfa_DB]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTERProc[dbo].[AddRecord]
(
@rollbigint,
@namevarchar(20),
@cityvarchar(20)
)
AS

BEGIN
       SETNOCOUNTON;
              INSERTintoStudent(roll,Name,City)values(@roll,@name,@city)
       SETNOCOUNTOFF;
END

Model


publicclassStudentModel
{
publicint Roll { get; set; }
publicstring Name { get; set; }

Wednesday 21 February 2018

Data Render Using Razor

Display Student Record on cshtml page in table using Razor


@model IEnumerable<Britanic_MIS.Models.InvoiceModel>
<table >
        <thead>
            <tr><th>Roll</th><th>Name</th><th>City</th></tr>
        </thead>
        <tbody >
                 
                @foreach (var item in Model)
                {