Posts

Showing posts from January, 2022

Stylesheet

Image
import * as React from 'react'; import styles from './Employeespotlight.module.scss'; import { IEmployeespotlightProps } from './IEmployeespotlightProps'; import { escape } from '@microsoft/sp-lodash-subset'; import * as $ from 'jquery'; import { WebPartContext } from '@microsoft/sp-webpart-base'; import { SPHttpClient, SPHttpClientResponse } from '@microsoft/sp-http'; import { SliderHelper } from './Helper'; export interface SpotlightDetails { userDisplayName: string; userEmail: string; userProfilePic: string; description: string; designation?: string; } export interface IStateEmployeeSlider { value:SpotlightDetails[]; } var result=[]; export interface ResponceDetails { title: string; id: string; } export default class Employeespotlight extends React.Component { private defaultProfileImageUrl: string = "/_layouts/15/userphoto.aspx?size=L"; private helper: SliderHelper = new SliderHe...
Post a Comment
Read more

DIFFERENCE BETWEEN STRING AND STRING BUILDER IN C#:

  Posted by Ganesan - +919042710472                         DIFFERENCE BETWEEN STRING AND STRING BUILDER IN C#: STRING:   String is immutable, which means once you create an instance of string you cannot change the string's value. Then this will keep the old instance and create a new instance with a new value in the memory. Example: String strMyValue ="Hello Visitor";  //create a new string instance instead of changing the old one. strMyValue +="How Are"; strMyValue +="you?"; STRINGBUILDER:  String builder is mutable, it means if you change the value of string using string builder, it will not create a new instance, instead .it will update the value in the existing instance. Example: StringBuilder SbMyValue =new stringBuilder(" "); Sb MyValue.Append("Hello Visitor");sss Sb MyValue.Append("How Are You?"); String strMyValue= sbMyvalue. Testing(); NAMESPACE STRING : The string class in the System namespac...
Post a Comment
Read more

SQL SERVER 2019 INSTALLATION GUIDE

Image
      Posted by Ganesan - +919042710472                                            SQL SERVER 2019 INSTALLATION GUIDE INTRODUCTION:   Microsoft products SQL SERVER developer edition is a full featured free edition. Licensed for use a development and test database in a non- production environment. Download link: https://www.microsoft.com/en-in/sql-server/sql-server-downloads Step 1:   Once completed the download the application then double click it to start the installation process.   Step 2: You have chosen the custom installation, click on “ Install”, allow the application to download and install packages. Step 3:   After all of the packages have downloaded, a new page you can see, follow the box. Click on “ Installation”.    Step 4:   After step 3, choose the first option in the list and proceed to the next step. Step 5:...
Post a Comment
Read more

VISUAL STUDIO 2019 INSTALLATION SETUP

Image
      Posted by Ganesan - +919042710472    VISUAL STUDIO 2019 INSTALLATION SETUP Microsoft provides a free version of Visual studio and it can be downloaded from, https://visualstudio.microsoft.com/downloads/ .   Step 1: Once downloading completed, click on the install button and it will start the installation process.                                    Step 2: Once installation is completes, you will see the main window of visual studio. Step 3: Let’s create a Create a new project, and then you will see the following window,   Visual studio IDE tools. Step 4:   Create a new web application, and given the project name, Step 5: Choose the web forms, Step 6: After that you will see the main window and solution explorer,   Step 7:   Projects and solutions, The web content files (.aspx), source files (.cs files),  and then Run the solution and ge...
Post a Comment
Read more

SQL Vs MySQL

Image
  Posted by Ganesan - +919042710472 SQL: STRUCTURED QUERY LANGUAGE SQL or Structured Query Language is a programming language that enables the function of retrieving, managing, storing the data in the relational database management system. The condition of the SQL statement is declarative in nature and is known as SQL Query. There are different SQL clauses that can be used while writing the queries to define the purpose of action. Some of the most basic and fundamental clauses and their functions are: SELECT : Extracts data from the database UPDATE: Updates data in a databases DELETE: Deletes the data from the data set. CREATE TABLE: Create a new table in a database. CREATE DATABASE: Create a new database INSERT INTO: Insert new data into a database. ALTER TABLE : Modifies a table. WHERE: Filter records based on conditions FROM: Retrieve data from specific columns of a table. MySQL: MySQL was one of the first open source database. MySQL uses SQL queries to perform actions...
Post a Comment
Read more

ASP.NET INTERVIEW QUESTIONS AND ANSWERS

  Posted by Ganesan - +919042710472 1. What is ASP.NET?  Why ASP.NET? ASP.NET is a .NET web technology or server side technology. To develop a web application by using .NET. we have to use a .NET web technology called ASP.NET and a .NET language called C# .NET. 2. What do you mean by server side technology? The code which is executing within the WEB SERVER is called as SERVER SIDE CODE. Server side code we can implement by using server side technologies. Ex: ASP, ASP.NET, JSP, PHP Using server side technology we can develop server side web pages. 3. What do you mean by client side technology? The code which is executing within the WEB BROWSER is called as CLIENT SIDE CODE. Client side code we can implement by using side technologies. Ex: HTML, CSS. 4. What are the programming techniques will be supporting by ASP.NET? ASP.NET will support two programming techniques. They are, 1.  In page technique 2. Code behind technique. 5. How can you pass values between ASP.NET...
Post a Comment
Read more

ADO.NET Interview Questions and Answers

   Posted by Ganesan - +919042710472 1. What is ADO.NET? ADO.NET stands for Microsoft ActiveX Data Object. Ado.net is a database technology which we can think like a set of classes that can be used to interact with the data sources like databases and XML files. Asp.net application, windows application, console application are the few types of .net applications that use ADO.NET to connect with the databases to execute commands and retrieve data. 2. What are the key features of ADO.NET? · Disconnected data architecture · Data cached in data set · Scalability · Data transfer in HTML Format · Strongly typed language. 3. Why is it important to close an ADO.NET application? Connections need to be closed properly because it affects the scalability and reliability of the applications. Open connections are always vulnerable to attack, so to be short , ‘ open connections as late as possible and close it as early as possible’. We can close the connection by final block or using the USING...
Post a Comment
Read more

SQL Interview questions and answers for freshers

Posted by Ganesan - +919042710472  1. What is SQL?   SQL-Structured Query Language   It is a microsoft database which can be used for manipulation of datas.  2. What are the subsets of SQL?   DDL – Data Definition Language –It allows you to perform various operations on the database such as CREATE, ALTER and DELETE objects.   DML – Data Manipulation Language – It allows you to access and manipulate data. It helps you to INSERT, UPDATE, DELETE and RETRIVE data from the database.    DCL – Data Control Language – It allows you to control access to the database .example Grant, Revoke access permissions.   TCL – Transaction Control Language – Used to manage transactions in the database. Example COMMIT, ROLLBACK and SAVEPOINT. 3. How to create a table and add data   Syntax : CREATE TABLE table_name(                  Column1 datatype,                 ...
Post a Comment
Location: Chennai, Tamil Nadu, India
Read more