Posts

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

Windows Application CRUD Operation with ADO.net

Image
  Posted by Ganesan - +919042710472    Create STUDENTDB Database in Server Explorer. Create table StudentDetails in STUDENTDB with the below code snippet, Design Form1 as below, Textbox Properties StudentName Name - txtStudentName Age Name - txtAge Save -btnSave Show Data Link Name -linkLabel1 Events btnSave OnClick =btnSave_Click Show Data Link onClick= linkLabel1_LinkClicked Add below Namespace in Form1.cs Using System.Data.SqlClient; Using System.Configuration; Add Reference System.Configuration.DLL in the Project. In Form1.cs (Replace) put the below Snippet, public partial class Form1 : Form  { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString); public Form1()  {  InitializeComponent();  }  private void btnSave_Click(object sender, EventArgs e)  {  con.Open();  SqlCommand cmd = new SqlCommand("insert into StudentDetails values('"+txtStudentName...
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