Posts

Showing posts with the label DotnetTraininginChennai

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

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

OOPS - OBJECT ORIENTED PROGRAMMING SYSTEM

Posted by Ganesan - +919042710472 Object oriented programming uses a different set of programming languages than old procedural programming languages. Everything in OOP is grouped as self sustainable "objects".  Main concepts of OOPs are  Class, Object, Abstraction, encapsulation, inheritance and polymorphism. CLASS: Class is a collection of objects. Class is composed of three things, a name, attributes, and operations. To create a class, you simply use the keyword "Class" followed by the Class name,            Class ClassName             {               } OBJECT:   An object can be considered a "thing" that can perform a set of related activities. The set of activities that the object performs defines the object's behaviour. For example the hand (object) can grip something. Can give their name or address. an Object is an instance of a class.           ...
Post a Comment
Read more