Interview Questions for 3+ Years of Experience on .NET Professionals

Hi friends in this I will explain about Interview Questions for 3+ Years of Experience on .NET Professionals.

You can refer  .NET interview Questions for 1-2 years Experience, .NET interview Questions for 1-2 years Experience and What is the sequence in which ASP.NET events are processed? Interview Questions on ASP.NET

MVC: How to Bind Data to DropDownList from Database using Stored Procedure in MVC 4 Razor

Hi Friends,in this article I will explain about How to Bind Data to DropDownList from Database using Stored Procedure in MVC 4 Razor.
I already explained in the previous articles about How to bind DropDownList from database in C# MVC 4 razor,How to Create Cascading DropDownList in MVC 4 Razor and JQuery and MVC4 Razor:How to call Stored Procedure using C#

Creating Dynamic CSS Menu From Database SQL Server in ASP.Net Using C#.Net/VB.NET

Hi friends,in this article I will explain about How to Create Dynamic menu is one of the most important parts if a website development. So today I will show you how you can create dynamic css menu with database(SQL Server using in ASP.NET using CSS.

First we will search for the menu which we want to implement dynamically. 

After this we will create table in which we will add the menu item detail. In this article I have used two table one for parent and other for child table. In this child table contains the reference of parent table.

Split and convert Comma Separated String or any Delimited String to Table in SQL Server

Hi friends,in this article I will explain about How to Split and convert Comma Separated String or any Delimited String to Table in SQL Server

In this article I will explain with examples, how to split and convert a comma separated / delimited string to a table using Split function in SQL Server 2005, 2008 and 2012 versions. The string containing words or letters or numbers separated (delimited) by comma or underscore or  plus(+) ,etc,. will be split into Table values.

I will also explain how to use the Split function to split a string in a SQL Query or Stored Procedures in SQL Server 2005, 2008 and 2012 versions.

Custom paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL perfomance

Hi friends,in this article I will explain about How to do Custom paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL perfomance

When there are bulk records to show in the GridView, developers often use paging to distribute the complete records with multiple pages to show the records in the GridView. This means that, when you change the page index, the GridView is bound everytime  from the database to show the next records.

How to List All Tables and Their Rowcount in SQL Server

Hi friends,in this article I will explain about How to List All Tables and Their Rowcount in SQL Server.
I already explained in the previous articles about How to Backup All Databases in SQL Server, How to get Distinct Count across Multiple Tables in SQL Server and How to Remove/Delete duplicate records/Rows from a table in SQL Server

How to Backup All Databases in SQL Server

Hi friends,in this article I will explain about How to Backup All Databases in SQL Server.

Below  is a SQL script to get all Databases Backup in specified folder.
Backup file name will be like "DataBaseName_{Date}-{Month}-{Year}.bak"

How to get Distinct Count across Multiple Tables in SQL Server

Hi Friends,in this article I will explain about  How to get Distinct Count across Multiple Tables in SQL Server.
I already explained in the previous articles about How to Remove/Delete duplicate records/Rows from a table in SQL Server,SQL Server 2008 : How to Remove Special Characters in a String , STUFF and PATINDEX Examples and How to alter primary key column for existing table in sql server 2008
Before knowing How to get Distinct Count across Multiple Tables first know about UNION ALL Operator.

How to Remove/Delete duplicate records/Rows from a table in SQL Server

Hi friends, in this article i will explain about How to remove duplicate rows in SQL Server 2008.
I already explained in the previous articles about How to Remove Special Characters in a String , STUFF and PATINDEX Examples,How to alter primary key column for existing table in sql server 2008 and How to Get List of Stored Procedures based on table name search, using sql server 2008?  

SQL Server 2008 : How to Remove Special Characters in a String, STUFF and PATINDEX Examples

Hi friends, in this article I will explain about  How to Remove Special Characters in a String in SQL Server 2008   

I already explained in the previous articles about How to alter primary key column for existing table in sql server 2008, How to Get List of Stored Procedures based on table name search, using sql server 2008? and Differences and Similarities Between LEN and DATALENGTH Functions in SQL Server

How to alter primary key column for existing table in sql server 2008

Hi friends,in this article i will explain about How to alter primary key column for existing table in SQL Server 2008.
I already explained about How to Get List of Stored Procedures based on table name search, using sql server 2008?,Differences and Similarities Between LEN and DATALENGTH Functions in SQL Server and Common Table Expressions(CTE) in SQL SERVER 2008

How to Get List of Stored Procedures based on table name search, using sql server 2008?

Hi friends,in this article i will explain about Get List of Stored Procedures Where a Table Name is Used in SQL Server.
I already explained in the previous articles about Common Table Expressions(CTE) in SQL SERVER 2008,Create ,list and Alter the trigger associated with a table with SQL Server? and SQL Server 2008 XML input parameter to stored procedure and insert XML data to Table

Differences and Similarities Between LEN and DATALENGTH Functions in SQL Server

Hi Friends,in this article i will explain about Differences  and Similarities Between LEN and DATALENGTH Functions in SQL Server.
I already explained in the previous articles about Common Table Expressions(CTE) in SQL SERVER 2008,Create ,list and Alter the trigger associated with a table with SQL Server? and SQL Server 2008 XML input parameter to stored procedure and insert XML data to Table

Common Table Expressions(CTE) in SQL SERVER 2008

Hi friends,in this article i will explain about Common Table Expressions(CTE) in SQL SERVER 2008.
I already explained in the previous articles about Create your own captcha image generator in ASP.NET using C#.NET/VB.NET,How to create a RDLC report using asp.net with c# /VB.NET and Create ,list and Alter the trigger associated with a table with SQL Server?

Find the Nth Maximum and Minimum Value in a Column in SQL Server 2008

Hi friends,in this article i will explain about how to find the Nth Maximum and Minimum Value in a Column.
In previous articles i explained about Check if Database Exists In SQL Server – Different ways, Query to Get List of Tables in Database in SQL Server 2008 and Create ,list and Alter the trigger associated with a table with SQL Server?

Check if Database Exists In SQL Server – Different ways

Hi Friends,in this article i will explain about Check if Database Exists In SQL Server – Different ways.
I already explained in the previous articles about How to Get List of Stored Procedures based on table name search, using sql server 2008?,Differences and Similarities Between LEN and DATALENGTH Functions in SQL Server and Common Table Expressions(CTE) in SQL SERVER 2008

SQL Server - Query to Get List of Tables in Database in SQL Server 2008

Hi Friends,in this article i will explain about  Query to Get List of Tables in Database in SQL Server 2008.
I already explained in the previous article about How to Get List of Stored Procedures based on table name search, using sql server 2008?,Differences and Similarities Between LEN and DATALENGTH Functions in SQL Server and Common Table Expressions(CTE) in SQL SERVER 2008

Create ,list and Alter the trigger associated with a table with SQL Server?

Hi friends,in this article i will explain about How to Create ,list and Alter the trigger associated with a table with SQL Server?.

I already explained in the previous articles about Binding and Sorting Grid in ASP.NET MVC using Jquery , JSON: Create Cascading DropDownList from Database using JQuery in MVC 4 Razor,How to Bind Data to DropDownList from Database using Stored Procedure in MVC 4 Razor and How to bind DropDownList from database in C# MVC 4 razor

SQL Server 2008: XML input parameter to stored procedure and insert XML data to Table

Hi Friends,in this article i will explain about SQL Server 2008 XML input parameter to stored procedure and insert XML data to Table.
I already explained in the previous articles about How to get selected text of CheckBoxList and align CheckBoxList Horizontal in ASP.NET using C#/VB.NET,SQL SERVER – Simple Example of Cursor. and How to Scroll Page Automatically by few pixels after every few seconds using JQuery

SQL SERVER – Simple Example of Cursor.

Hi Friends,in this article I will explain about SQL SERVER – Simple Example of Cursor..
I already explained in the previous articles about How to Scroll Page Automatically by few pixels after every few seconds using JQuery,VS Shortcuts | Shortcut keys for Visual Studio and JQuery:How to Disable Cut,Copy and Paste of TextBox in ASP.NET