Dot Net Articles

Tips & Tricks: Drag and Drop code from Visual Studio Toolbox

In this article i will explain how to drag and drop common code from Visual Studio Toolbox.

Tips & Tricks: Remove Parameters and Reorder Parameters in Visual Studio

In this article i will explain two features provided in Visual studio IDE. Namely they are "Remove Parameters" and "Reorder Parameters".

Tips & Tricks: Task List in Visual Studio

In this article i will explain "What is Task List in Visual Studio". And how this feature is use full to developers.

Tips & Tricks: Extract Method in Visual Studio

In this article i will explain what is "Extract Method in Visual Studio". How to use this feature.

Tips & Tricks: Rectangular selection of code in Visual Studio

In this article i will explain what is "Rectangular selection of code in Visual Studio". And how developer will get benefit by using this feature while writing the code.

The major features added in C# in each release

The major features added in each release are generally considered to be the following: C# 2.0 - Generics (.NET Framework support was added, and C# benefited from this); iterator pattern (the yield keyword); anonymous methods (the delegate keyword), nullable types, and the null coalescing operator (??).

Check/Uncheck checkboxes when parent checkbox is checked/unchecked and vice-versa in Java Script

Objective: 1. Check all the checkboxes when parent checkbox is checked 2. UnCheck all checkboxes when parent checkbox is unchecked 3. Check parent checkbox if all the child checkboxes are checked 4. UnCheck parent checkbox if atleast one checkbox is unchecked

Bind DropDownList using simple user defined method in ASP.Net

Objective: 1. Bind DropDownList using simple user defined method in ASP.Net 2. User defined method should accept collection (e.g: List<Employee> or List<User> or List<Role> etc) 3. User defined method should accept DataTable as well

Set DropDownList value based on text/value in jQuery

In this article i will explain how to set DropDownList value based on text/value in jQuery

Set DropDownList value based on text/value in Java Script

In this article i will explain how to set DropDownList value based on text/value in Java Script

Get selected text/value from DropDownList (or) Select in jQuery

In this article i will explain how to get selected text/value from DropDownList (or) Select in jQuery

Get selected text/value from DropDownList (or) Select in Java Script

In this article i will explain how to get selected text, value from DropDownList (or) Select in Java Script

Get selected index from DropDownList (or) Select in jQuery

In this article i will expalin how to get selected index from DropDownList (or) Select in jQuery

Get selected index from DropDownList (or) Select in Java Script

In this article i will expalin how to get selected index from DropDownList (or) Select in Java Script

Clear items from DropDownList (or) Select in Java script

In this article i will explain how to clear items from DropDownList (or) Select in Java script.

Clear items from DropDownList (or) Select in jQuery.

In this article i will explain how to clear items from DropDownList (or) Select in jQuery.

How to increase JSON response length in ASP.Net

In this article i will explain how to increase JSON response length in ASP.Net.

Difference between Web User Controls and Web Custom Controls in ASP.Net.

In this article i will explain what is the difference between Web User Controls and Web Custom Controls in ASP.Net.

Exception Handling

Errors in any language are classified into Compile Time Errors, Runtime Errors and Logical Errors.

Minify Resources (HTML, CSS, and JavaScript)

Minification refers to the process of removing unnecessary or redundant data without affecting how the resource is processed by the browser.

Standards for developing flexible, durable, and sustainable CSS

In this article i will explain standards for developing flexible, durable, and sustainable CSS.

Standards for developing flexible, durable, and sustainable HTML

In this article I will explain Standards for developing flexible, durable, and sustainable HTML

C# Coding Standards and Naming Conventions

In this article i will explain our C# coding standards, naming conventions, and best practices. Use these in your own projects and/or adjust these to your own needs.

Java Script: Number Validation

In this article i will explain How to validate a Number in Java Script. This article includes the following: 1.Number Validation in Java Script 2.Number Validation in onblur event. 3.Restrict user to enter other than numbers in onkeypress event.

Java Script: Create/Insert rows dynamically to HTML Table and Remove/Delete rows from HTML Table

In this article i will explain How to Create/Insert rows dynamically to HTML Table and Remove/Delete rows from HTML Table.

Java Script: Create HTML Table dynamically

In this article i will how to create a HTML Table dynamically in Java Script.

Java Script: TextBox

In this article i will explain how to work with TextBox in Java Script.

Java Script: Get Key Codes

In this article i will explain how to get key codes in Java Script.

ASP.Net: How to Create an Excel (or) Export data into Excel

In this article i will explain how to Create an Excel (or) Export data into Excel

SQL Server: Search for particular keyword in all procedures (or) Get list of procedures where particular keyword or table name is used

In this article i will explain how to search for particular keyword in all procedures (or) Get list of procedures where particular keyword or table name is used in SQL Server.

SQL Server: Get List of SQL Jobs

In this article i will explain how to get list of SQL Jobs in SQL Server.

SQL Server: Get List of Stored Procedures with Created Date and Modified Date

In this article i will explain how to get list of Stored Procedures with Created Date and Modified Date in SQL Server.

SQL Server: Variables

In this article i will explain Different types of Variables in SQL Server.

SQL Server: Triggers

In this article i will explain what is Trigger.

SQL Server: Difference between Stored Procedure and Function

In this article i will explain what is the difference between Stored Procedure and Function.

SQL Server: Functions

In this article i will explain what is Function.

SQL Server: Named Batches

In this article i will explain about Named Batches.

SQL Server: Anonymous Batches

In this article i will explain about Anonymous Batches.

SQL Server: Batches

In this article i will explain about Batches.

SQL Server: Non Equi Join

In this article i will explain what is Non Equi Join.

SQL Server: Equi Join

In this article i will explain what is Equi Join.

SQL Server: Cross Joins

In this article i will explain what is Cross Join.

SQL Server: Full Join (or) Full Outer Join

In this article i will explain what is Full Join (or) Full Outer Join.

SQL Server: Joins

In this article i will explain what are joins in SQL Server.

SQL Server: Delete record from parent table when there is Foreign Key relation between parent and child tables

In this article i will explain how to delete record from parent table when there is Foreign Key relation between parent and child tables in SQL Server.

SQL Server: DEFAULT Constraint

In this article i will explain what is DEFAULT Constraint in SQL Server.

SQL Server: FOREIGN KEY Constraint

In this article i will explain what is FOREIGN KEY Constraint in SQL Server.

SQL Server: PRIMARY KEY Constraint

In this article i will explain what is PRIMARY KEY Constraint in SQL Server.

SQL Server: UNIQUE Constraint

In this article i will explain what is UNIQUE Constraint in SQL Server.

SQL Server: CHECK Constraint

In this article i will explain what is CHECK Constraint in SQL Server.

SQL Server: NOT NULL Constraint

In this article i will explain what is NOT NULL Constraint in SQL Server.

SQL Server: Constraints

In this article i will explain what is Constraint. And how many Constraints available in SQL Server.

SQL Server: Temporary Table

In this article i will explain what is Temporary Table in SQL Server.

SQL Server: Differences between CHAR, NCHAR, VARCHAR and NVARCHAR

In this article i will explain differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server.

SQL Server: Identity Column

In this article i will explain how to create a table with auto incremented column in SQL Server.

SQL Server: Drop Command

In this article i will explain what is Drop Command and how to use Drop Command in SQL Server.

SQL Server: Truncate Command

In this article i will explain what is Truncate Command and how to use Truncate Command in SQL Server.

SQL Server: Delete Command

In this article i will explain what is Delete command and how to use Delete command in SQL Server.

SQL Server: Update command

In this article i will explain what is Update command and how to use Update command in SQL Server.

SQL Server: How to rename a column and How to rename a table

In this article i will explain how to rename a column and how to rename a table in SQL Server.

SQL Server: How to add a column to table and How to delete a column from table

In this article i will explain how to add a column to table and how to delete a column from table in SQL Server.

ASP.Net: ListView Basics - ItemDeleting

In this article i will explain how to Delete ListView records

SQL Server: How to alter table column in SQL Server

In this article i will explain how to alter table column in SQL Server.

SQL Server: How to create a table

In this article i will explain how to create a table in SQL Server.

SQL Server: System Databases

In this article i will explain what are System Databases. And what is the role of each System Database.

SQL Server: Insert values into Identity Column

In this article i will explain how to insert values into Identity column in SQL Server.

ASP.Net: ListView Basics - ItemEditing, ItemUpdating and ItemCanceling events

In this article i will explain how to Edit ListView records, how to Update ListView records and how to Cancel ListView update operation.

C#: How to Query for characters in a string using LinQ.

In this article i will explain how to query for characters in a string using LinQ.

C#: How to Read characters from String

In this article i will explain how to read characters from string.

ASP.Net: List View Basics - Insert a new record from List View Footer (or) How to use InsertItemTemplate in ListView

In this article i will explain how to insert new record from List View footer (or) How to use InsertItemTemplate in ListView.

ASP.Net: List View Basic Example

In this article i will explain how to use ListView control in ASP.Net with example (or) How to bind data to ListView control.

JQuery: How to replace string in JQuery

In this article i will explain how to replace string in JQuery.

Java Script: How to replace string in Java Script

In this article i will explain how to replace string in Java Script.

C#: How to replace string in C#

In this article i will explain how to replace a string in C#.

SQL Server: How to replace string in SQL Server

In this article i will explain how to replace string or text in SQL Server. And how to replace table column values in SQL server.

C#: How to convert string to int in C#

In this article i will explain how to convert string to integer in C#. And how many ways we can convert string to integer.

SQL Server: How to get fixed length number format in SQL Server (or) How to prefix zeros to number, to get fixed length number format in SQL Server

In this article i will explain how to get a fixed length number format in SQL Server (or) how to prefix zeros to number, to get fixed length number format in SQL Server.

SQL Server: Split function (or) How to Split string in SQL Server

In this article i will explain how to Split string in SQL Server (or) how to create Split function in Sql Server.

SQL SERVER – DDL, DML, DCL and TCL Commands

In this article i will explain what is DDL in SQL Server? And What are DDL commands? what is DML in SQL Server? And What are DML commands? what is DCL in SQL Server? And What are DCL commands? what is TCL in SQL Server? And What are TCL commands?

SQL Server: Right Join (or) Right Outer Join

In this article i will explain what is Right Join (or) Right Outer Join.

SQL Server: Left Join (or) Left Outer Join

In this article i will explain what is Left Join (or) Left Outer Join.

SQL Server: Inner Join (or) Join

In this article i will explain what is INNER JOIN.

SQL Server: How to get current week dates

In this article i will explain how to get current week dates in SQL Server with examples? When to use: Example 1: Get current week travelers list Example 2: Get current week interviews list

SQL Server: Joins - Cartesian Product

In this article i will explain what Cartesian Product in SQL Joins? How to retrieve data from multiple table by using this join with an example?

SQL Server: Date Formats

In this article i am explaining how to get different date formats in SQL Server.

JSON - Basics

In this article i will explain what JSON is and how we will perform operations on data using JSON. JSON: JavaScript Object Notation. JSON is syntax for storing and exchanging text information, like XML. JSON is smaller than XML, and faster and easier to parse.

Access Specifiers or Access Modifiers in C#

In encapsulation, before creating any types you must always consider scope of the type or visibility of the type. C# provides various number of keywords to decide the scope, those are private(default one), public, internal, protected and protected internal. If you create any type without these keywords, by default it will take as private.