Suthahar Jegatheesan MSDEVBUILD / blog by Suthahar

Articles

236 articles published on msdevbuild.com, organised by topic. These open on the main site.

Follow along:Follow on LinkedInFollow on GitHubSubscribe on YouTube

Showing all 236 articles

Azure 89

Xamarin 33

Web 22

  • Difference between Singleton and Static Class

    Singleton Static Class 1 Single means single object across the application life cycle so it application level The static does not have any Object pointer, so the scope is at App Domain…

    Web

  • C# 6.0 New Feature

    C# 6.0 New Feature How to get C# Updated Version? Two ways we can update C# 6.0 Updated Visual Studio into VS 2014 Or Installing Roslyn Package in VS 2013 $ Sign : Its simplify String…

    Web

  • LESS extends CSS with dynamic behavior such as variables, mixins, operations and functions.

    Dot - Less {} Dynamic CSS for . Net LESS extends CSS with dynamic behavior such as variables, mixins, operations and functions. Download latest dot less package http://www.dotlesscss.org/ ,…

    Web

  • Disable Right Click in IE

    Java Script: <script language="javascript"> document.onmousedown=disableclick; status="Right Click Disabled"; Function disableclick(e) { if(event.button==2) { alert(status); return false; }…

    Web

  • Sending Email using gmail

    using System . Net . Mail; Coding: MailMessage om = new MailMessage("[email]", "[email]"); // om . CC // om . Bcc om . Subject = "Welcome to Suthahar bogs"; om . Body = value; om .…

    Web

  • Override Inline Styles with CSS [ !important ]

    Cascading Style Sheets cascade. This means that the styles are applied in order as they are read by the browser. The first style is applied and then the second and so on. What this means is…

    Web 1 comments

  • ASP.NET TIPS: SENDING EMAIL USING ASP.NET (GMAIL OR YOUR SERVER)

    using System.Net.Mail; using System.Net; MailMessage mail = new MailMessage(); mail.To.Add("**@gmail.com"); mail.To.Add("**@gmail.com"); mail.From = new MailAddress("**@gmail.com");…

    Web

  • Reset Controls Value using Asp.net / Javascript / J query

    Reset Controls Value using Asp.net / Javascript / Jquery Asp.net: Dynamicaly you have to add controls means you don't know controls id so we can find control type in particular page after…

    Web

  • Delegate-Lambda Expression (=&gt;):

    Lambda Expression (=>): A lambda expression is an unnamed method written in place of a delegate instance. The compiler immediately converts the lambda expression to either Delegate Instance…

    Web

  • Runtime Assign Method using Delegate

    Writing Plug-in Methods with Delegates A delegate variable is assigned a method dynamically. This is useful for writing plug-in methods. In this example, we have a utility method named…

    Web

  • Beginner Delegate program

    Add Two Number Delegate Program public delegate int AddTwoNumberDel(int fvalue, int svalue); private void btnClick_Click(object sender, EventArgs e) { AddTwoNumberDel AT = Addnumber; //…

    Web

  • C# Dotnet Delegate

    What is Delegate? Its reference to method. once method assign to delegate its work like method delegate method used any other method Where we will use real time? If you want to call…

    Web

  • WCF Programming Model

    Disadvatage : Disadvantage is that only HTTP protocol could be used. Another disadvantage is all the service will run on the same port. WCF Programming Model: WCF service have three parts .…

    Web

  • What is WCF ?

    · Windows Communication Foundation is a programming platform and runtime system for building, configuring and deploying network-distributed services. · It is the latest service oriented…

    Web

  • Reserve word in C#.net

    Keywords in C#.net C#.net have 77 Reserve word. You are not declare variable/method in reserve words .if you want to declare reserved word you can use " @ " symbol. Example: private void…

    Web

  • Configuration File Dotnet

    What is Web.Config File? It is an optional XML File which stores configuration details for a specific asp.net web application. What is Machine.config File? The Machine.Config file, which…

    Web

  • Collection -2D Array

    2D Array You want to use a 2D array containing any type(int,string ,etc) of value in your C# program 2D array contain 2 pair of values Performance PERF 2D Array are slower to index elements…

    Web

  • Collection - Array

    Arrays are references that point to fixed sizes of memory that you can store different kinds of elements in, such as values or references to other objects. In these examples, we look at…

    Web

  • How to use C# string Format

    How to use C# string Format string Format method replace the argument Object into a text equivalent System.String. Replace string Particular index for ex System.String.Format("Hi welcome Mr…

    Web

  • Types of JIT Compilers

    When the program is executed the CLR activates JIT compiler ,inturn this JIT converts the MSIL Code (Non Executable) to Native Code(Executable) on demand basis as each part of Program is…

    Web

  • Resource file in .Net

    What is Resource File ? A resource file is a XML file that contains the strings that we want to a. Translate into different languages. b. Can be updated dynamically so that user themselves…

    Web

  • How To Read Web Page HTML Code With ASP.NET?

    If data are not available in some kind of XML format (like RSS or web services), sometime you need to deal with HTML output of web page. HTML is usually much harder to analyze than XML…

    Web 1 comments

SQL 21

  • SQLite Limitation

    Some Feature not Supported in SQLite Feature Support Not Support Right Outer Join No Only Left Outer Join Full Outer Join No Only Left outer Join Alter Table Rename Table Add Column Alter…

    SQL

  • WHAT IS USE OF COALESCE KEYWORD

    step 1: CREATE TABLE COLLEGE(SID NVARCHAR(10),SNAME NVARCHAR(20),PLACE NVARCHAR(20)) Step 2: INSERT INTO COLLEGE…

    SQL 1 comments

  • Sql Server Trigger for Beginner

    A trigger is a SQL procedure that initiates an action . when an event (INSERT , UPDATE , DELETE) occures . Triggers can be viewed as similar to stored procedure in that both consist of…

    SQL

  • CUBE,COMPUTE,COMPUTE BY and ROLLUP OPERATOR IN SQL SERVER

    The CUBE,COMPUTE,COMPUTE BY and ROLLUP operators are useful in generating reports that contain subtotals and totals. There are extensions of the GROUP BY clause. The result set of a ROLLUP…

    SQL

  • Cannot connect to WMI provider. You do not have permission or the server is unreachable

    Error in SQL Server Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server…

    SQL

  • Add / REMOVE Primary Key to existing table

    CREATE TABLE WITHOUT PRIMARY KEY CREATE TABLE JSSTUDTABLE (SNO NUMERIC(10) NOT NULL)ADD PRIMARY KEY EXISTING TABLE ALTER TABLE JSSTUDTABLE ADD PRIMARY KEY (SNO); REMOVE PRIMARY KEY EXISTING…

    SQL

  • “ COALESCE “ Method in Sql Server

    “ COALESCE “ Method in Sql Server Table Have so many column like that Name HomeAddress OfficeAddress Temp_Address Suthahar Null Null Pudukkottai Suresh Pullanviduthi Null Null Sumathi Null…

    SQL

  • View in Sql Server

    View in Sql Server View is a virtual table It s contains columns and data in different table View does not contain any data directly. Its a set of select query Table 1 Sno Sname Table 2 Sno…

    SQL

  • Trigger Interview Questions

    How many types of triggers are there in Sql Server 2005? There are two types of triggers Data Manipulation language (DML) triggers Data Definition language (DDL) triggers DML triggers…

    SQL 1 comments

  • Trigger In Sql Server

    Trigger is a special kind of Store procedure Modifications to the table are made using INSERT , UPDATE OR DELETE trigger will run It is automatically run Triggers prevent incorrect ,…

    SQL

  • How to get number of row in each table in database

    SELECT obj.NAME, ind.rowcnt FROM sysindexes AS ind INNER JOIN sysobjects AS obj ON ind.id = obj.id WHERE ind.indid < 2 AND OBJECTPROPERTY(obj.id, 'IsMSShipped') = 0 ORDER BY obj.NAME Help…

    SQL

  • How to get number of days in a month

    select CASE WHEN MONTH(getdate()) IN (1, 3, 5, 7, 8, 10, 12) THEN 31 WHEN MONTH(getdate()) IN (4, 6, 9, 11) THEN 30 ELSE CASE WHEN (YEAR(getdate()) % 4 = 0 AND YEAR(getdate()) % 100 != 0)…

    SQL

  • How to select all duplicate records from a table

    select Col, count(Col) from TableName group by field having count(*) > 1 Help to Developer to manage and deliver hands-on digital learning experiences in MAUI, Xamarin,Azure, and Microsoft…

    SQL

  • How to Enable CLR integration in SQL Server

    EXEC sp_configure 'clr enabled', 1; RECONFIGURE WITH OVERRIDE; Go Help to Developer to manage and deliver hands-on digital learning experiences in MAUI, Xamarin,Azure, and Microsoft AI free…

    SQL

  • How to disable CLR integration in SQL Server

    EXEC sp_configure 'clr enabled', 0; RECONFIGURE WITH OVERRIDE; Go Help to Developer to manage and deliver hands-on digital learning experiences in MAUI, Xamarin,Azure, and Microsoft AI free…

    SQL

  • How to get number of records in a table

    SELECT * FROM table1 SELECT COUNT(*) FROM table1 SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2 Help to Developer to manage and deliver hands-on digital learning…

    SQL

  • What is a join and List different types of joins

    Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table. Types of joins: INNER JOINs, OUTER…

    SQL

  • Difference between Triggers and Storedprocedures

    Triggers are basically used to implement business rules.Triggers is also similar to stored procedures.The difference is that it can be activated when data is added or edited or deleted from…

    SQL

  • How to get number of Maximum connection can be establish to SQL

    SELECT @@MAX_CONNECTIONS Help to Developer to manage and deliver hands-on digital learning experiences in MAUI, Xamarin,Azure, and Microsoft AI free Learning portal by Suthahar Jegatheesan

    SQL

  • What do you mean by Filtered indexes

    Filtered indexes are a new feature in SQL 2008 and they allow for an index to contain only some of the rows in the table. Prior to this, an index would always have, at the leaf level, the…

    SQL

  • Get top two records without Top keyword

    set rowcount 2 select column,column1 from tblEmployeeMaster Help to Developer to manage and deliver hands-on digital learning experiences in MAUI, Xamarin,Azure, and Microsoft AI free…

    SQL

Bot 16

Visual Studio 14

MAUI 8

AI 6

C# 5

  • C# Object and Dynamic Types

    This blog provides an in-depth explanation of object and dynamic types in C#. Object Type 1. Overview object is the base class for all data types in C#. It can store any type of value,…

    C#

  • Improving C# Performance by Using AsSpan and Avoiding Substring

    During development and everyday use, Substring is often the go-to choice for string manipulation. However, there are cases where Substring can negatively impact performance and result in…

    C#

  • Free Microsoft Certification : C#

    Microsoft announced a new Foundational C# certification in collaboration with FreeCodeCamp. The Foundational C# certification is completely free for individuals in all regions. The…

    C#certification

  • Visual Studio 2022: C# Global Namespace

    Global usings were introduced in C# 10 and .NET Core 6.0 and later versions. This feature proves to be highly beneficial as it allows you to incorporate commonly used namespaces. As a…

    C#

  • DateOnly And TimeOnly Types In .NET 6 -.NET Core

    In this article, we will discuss Microsoft introduced new types DateOnly and TimeOnly in C# and examine the unique functionalities offered by each, and assist in determining the suitable…

    C#

Xamarin.Android 5

More 17