Thursday 2 April 2020

Solved : Internet Technology and Web Design Question Paper (January-17)

Solved : NIELIT (O-Level) Internet Technology and Web Design Question Paper (January-17)

1. Each question below gives a multiple choice  of   answers. Choose the most answer sheet supplied with the question paper, following instructions therein. (1x10)

1.1 : Correct HTML Tag for largest heading:
A) <head>
B) <h6>
C) <heading>
D) <h1>
1.2 : www is based on which model?
A) local-server
B) client-server
C) 3-tier
D) None of the above

Answer IT Tools and Business Systems (July 2019)

Answer : NIELIT (O-Level ) IT Tools and Business Systems (July 2019)

1. Multiple Choice


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

2. True/False


2.1 : T
2.2 : T
2.3 : T
2.4 : F
2.5 : T
2.6 : T
2.7 : F
2.8 : T
2.9 : T
2.10 : T

3. Match the columns


3.1 : K
3.2 : A
3.3 : I
3.4 : M
3.5 : G
3.6 : H
3.7 : L
3.8 : F
3.9 : J
3.10 : C

4. Fill in the blanks


4.1 : H
4.2 : M
4.3 : I
4.4 : L
4.5 : F
4.6 : E
4.7 : J
4.8 : A
4.9 : K
4.10 : G

Wednesday 1 April 2020

Solved : IT Tools and Business Systems (July 2019)

Solved : NIELIT (O-Level ) IT Tools and Business Systems (July 2019)

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=10)

1.1 : Full form of ASCII :
(A) American Standard Code for Information Interconnection
(B) American Standard Code for Information Interchange
(C) American Situation Code for Information Intercommunication
(D) American Standard Coding for 
1.2 : Convert 10100011 from binary to decimal :
(A) 121 (B) 163
(C) 199 (D) 212
Answer

Monday 30 March 2020

Create Page Model attached MVC C#

This post lets you understand to create a view which bind with model, using this approach you can create to form to save the record in the database fastest and easily. As we know validation and binding model with jquery is very time taking task. The model view automatically creates forms as per the model. You can make validation rules in the model.


Model

Answer : IT Tools and Business Systems (January 2019)

Answer : IT Tools and Business Systems (January  2019)

1. Multiple choice :


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

Saturday 28 March 2020

Solved : IT Tools and Business Systems (January 2019)

Solved : IT Tools and Business Systems (January  2019)

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=10)

1.1 : Which is the technology used in the evaluation of aptitude test?
(A) OCR (B) OMR
(C) MICR (D) MCR
1.2 : SQL stands for :
(A) Standard Query Language
(B) Structured Query Language
(C) Shortest Query Language
(D) System Query Language
Answer 

Friday 27 March 2020

Answer : NIELIT IT Tools and Business Systems (July 2018)

Solved :  NIELIT IT Tools and Business Systems (July 2018)

1 : Multiple Choice


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

Thursday 26 March 2020

Compare date in dd/mm/yyyy format C#



Some programmer needs to compare date in the format of dd/mm/yyyy. C# sharp has reach features of handling date but too complicated. So I made this post which helps you to compare date in dd/mm/yyyy format in simple way.

using System.Globalization;

string strFromDate =  "16/03/2020";
           
string strToDate = "20/03/2020";

Wednesday 25 March 2020

NIELIT IT Tools and Business Systems (July 2018)

Solved NIELIT  IT Tools and Business Systems (July 2018)

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.

1.1 : statement for MS-Word?
A) It can be used to prepare annual report.
B) It can be used to generate same document to send multiple persons.
C) It has autocorrect facility and dictionary facility.
D) It can create a graph from given data.
Answer 

Thursday 27 February 2020

Spilit comma seprated string using SQL Server 2012

Create a function that will separate the comma-separated string and extract each word in using SQL Server 2012.

declare @str varchar(50),@l int,@i int,@p int,@slen int
select @str='o,222,333,kl,4444,555,88pol'
select @l=LEN(@str)
set @i=1
set @p=0
set @slen=1

Saturday 8 February 2020

Post data over with API using PHP

This post will help you to understand. How can you call an API created from ASP.NET MVC and calling from PHP?  API was created for the notification purpose for school.API Database is SQL server and server-side language is C#. You will see in this post how can you consume a post API created from other language and consume by PHP

Data Model

Field
Description
ID
Row ID (Auto Increment)
NotesText
Text of notification
NotesType
Attachment Type (Text,Link,File)
Path
Location of Attachemntq
ClassID
Class Name
NewGIF
Description: http://ankuram.probuzzmedia.com/Image/Page/new.gif
CreateDate
Created Date

API Code (C#)

Thursday 6 February 2020

Horizontal Image Slider


Head Section

<link rel="stylesheet" href="lightslider.css" />

   
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
    <script src="lightslider.js"></script>


CSS

<style>

        ul {
            list-style: none outside none;
            padding-left: 0;
            margin: 0;
        }

        .demo .item {
            margin-bottom: 60px;
        }

Friday 31 January 2020

ASP.NET MVC 3 and the @helper syntax within Razor

When you make a website then sometimes you need to make a reusable HTML component, for example, you want to show testimonial on the various page. For doing this you need to copy-paste testimonial HTML on pages where it is required. The problem arises when any modification is done on Testimonial, You will have to update testimonial manually on every page which is time taking and prone to error.

Consume Get API

Consume get API from ASP.Net using PHP


This post will help you to know how can you consume a get Api. Api in this post is made through ASP.Net C# which will be consumed by core PHP.

Data Model


Field
Description
ID
Row ID (Auto Increment)
NotesText
Text of notification
NotesType
Attachment Type (Text,Link,File)
Path
Location of Attachemntq
ClassID
Class Name
NewGIF
Description: http://ankuram.probuzzmedia.com/Image/Page/new.gif
CreateDate
Created Date


<table border="1" cellpadding="3" cellspacing="0">
                <tr>
                                <th>Sr No.</th>
                                <th>Notes Text</th>

Tuesday 28 January 2020

News Ticker


Ticker using HTML and CSS



Latest News

Lorem
ipsum
datom


CSS


.g-news {
            border: solid 1px #ffb600;
            height: 300px;
            width:300px;
        }

Thursday 23 January 2020

POST API ASP.Net

POST API ASP.Net C# (MVC)

API Controller


public class MyapiController : ApiController
    {
        // GET api/myapi
        public MyapiController() { }
     
        // POST api/myapi
      
        public IHttpActionResult Postdata([FromBody] NotificationModel data)
        {
            UserRepository obj = new UserRepository();
            string ErrMsg="";
            obj.AddNotesDB(data, ref ErrMsg);
            return Ok();
        }

    }

Monday 20 January 2020

Return JSON Object from API Controller

Return JSON Object from API Controller ASP.Net C# (MVC)


public IHttpActionResult GetNotification()
        {
            UserRepository ob = new UserRepository();
            List<NotificationAPIModel> data = new List<NotificationAPIModel>();
            data = ob.GetNotificationAPI("0", "2");

Sunday 19 January 2020

Answer : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018

Answer  : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018

1. Multiple Choice


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

Saturday 18 January 2020

Solved : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018

Solved : M1-R4: IT TOOLS & BUSINESS SYSTEMS Jan-2018


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 : Binary equivalent of (53.625)10 is .
A)  (110101.101)2 B)  (111101.001)2
C)  (110111.100)2 D)  (100101.101)2
1.2 : FAT stands for________
A) File Allocation Table
B) Folder Allocation Table
C) Folder Allocation Transition
D) File Allocation Transition
1.3 : ____ operation of file or folder is required to move location of file or folder.
A) Copy followed by Paste
B) Cut followed by Paste
C) Move followed by Paste
D) Change location

Thursday 9 January 2020

Delete File C# ASP.Net

JS



function DeleteImage(path)
{
    if (confirm('Are you sure to delete this Image')) {

        var Userobj =
           {

           }

        $.ajax({

            url: '/WebsiteAdmin/DeleteAssociateImage?path=' + path,
            type: "POST",
            contentType: false, // Not to set any content header 
            processData: false, // Not to process data 
            data: JSON.stringify(Userobj),

            success: function (result) {
                //Update Extension
                if (result.sMessage == "1") {
                    alert("Image deleted Successfully");
                    location.reload();

Monday 6 January 2020

Select specified file from input type file using HTML

Select specified file from input type file using HTML


Input type file enables you to select any type of file by default but you can specify which file type will be selected. Following HTML input type file enable you to select image (JPG,PNG),Word and PDF file. 

Saturday 4 January 2020

Image file preview before upload using css

Image file preview before upload using css


Uploading Image file to the webserver is very common. We use HTML file type input for file upload, by default HTML file upload control doesn’t preview file. But if you want to show selected image file preview before upload and select only image file. Then this post is a complete solution for this. So enjoy coding with Girfa Student Help blog.


<html>
<head>
    <title>Preview file before upload</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
    <style>
        .fileUpload {
            position: relative;
            overflow: hidden;
           
            margin-top: 0px;
        }

            .fileUpload input.upload {
                position: absolute;
                top: 0;
                right: 0;
                margin: 0;
                padding: 0;
                font-size: 20px;
                cursor: pointer;
                opacity: 0;
                filter: alpha(opacity=0);
            }
    </style>
    <script>

Thursday 26 December 2019

Encrypt password in SQL Server

This post will show you how can you encrypt/decrypt the password in SQL server 2012 fully using SQL Server store procedure.

Encrypt



        INSERT INTO AdminMaster ( Name,  UserName, Password, Status)

        VALUES('Girfa', 'girfa',EncryptByPassPhrase('key', '123')  , 1)

Sunday 15 December 2019

Textbox jquery option

Textbox jquery option

Textbox enter keypress detection


$j('#txtDesignCode').keypress(function (event) {

    var keycode = (event.keyCode ? event.keyCode : event.which);
    if (keycode == '13') {
       alert('Enter key hit'); 
    }

});