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#)