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 

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

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
CreateDate	Created Date

API Code (C#)

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;

        }