Interview Questions Part-5 | What is PRIMARY KEY Constraint in SQL Server | What is UNIQUE KEY Constraint | What is FOREIGN KEY Constraint | What is CHECK Constraint | What is NOT NULL Constraint in SQL Server ?

What is PRIMARY KEY Constraint in SQL Server?

Primary key constraint is used to uniquely identify each record in database table. It won’t allow repetition or duplication of data. Each table is having only one primary key constraint and it contains only unique values. Primary key constraint doesn’t accept null values (Read more Here)

Interview Questions Part-4 | What is the Difference between a HAVING clause and a WHERE clause in SQL Server | What is Connection Pooling and why it is used | What are the Authentication Modes in SQL Server | What is the difference between UNION and UNION ALL | What is Identity in SQL Server

What is the Difference between a HAVING clause and a WHERE clause in SQL Server? 

They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query, whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query

Interview Questions Part-3 | What is an Index in SQL Server | What is the Difference between Clustered and a Non-clustered Index in SQL Server | What is Collation | What are Primary Keys and Foreign Keys in SQL Server | What’s the Difference between a Primary Key and a Unique Key in SQL Server

What is an Index in SQL Server?

An index is a physical structure containing pointers to the data. Indexes are created in an existing table to locate the data more efficiently and quickly (Read more Here)

Interview Questions Part-2 | What are the Different Types of Triggers | What is a View | What is the Difference between a Function and a Stored Procedure | What are the Advantages of Using Stored Procedures in SQL Server

What are the Different Types of Triggers?

After triggers and Instead of triggers 

After triggers are the triggers which are raised before the transaction committed or postback.

Instead of triggers are used to update the database tables which are associated with view instead of updating the view directly.

Interview Questions Part-1 | What is Normalization | What is De Normalization | What is a Stored Procedure | What is a Trigger in SQL Server

What is Normalization? 

In relational database design, the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.There are three main normal forms, each with increasing levels of normalization:

SQL Server Indexes Tutorial | Different Types of Indexes in SQL Server | Difference between Clustered Indexes and Non-Clustered Indexes in SQL Server

Introduction:

Here I will explain about SQL Indexes and different types of indexes and advantages of indexes in SQL Server.

Description:

An index can be created in a table to increase the performance of application and we can get the data more quickly and efficiently. Let’s see an example to illustrate this point suppose now we are reading book in that I need to check the information for dbmanagement to get this information I need to search each page of the book because I don’t know in which page that word information exists it’s time taken process. Instead of reading the each page of book to get that particular word information if I check the index of book (Glossary) it is much quicker for us to get the pages which contains the information with dbmanagement word. By using second method we can save lot of time and we can get information in efficient way.

what is stored procedure in Sql server | what are the advantages of using stored procedures in sql server

Introduction:

Here I will explain about what is stored procedure is and advantages and disadvantages of stored procedures in sql server

Description:

A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure

SQL Union Operator | SQL Union ALL Operator | Difference between Union and Union ALL Operators in SQL |

Introduction:

Here I will explain about SQL UNION and UNION ALL operators and differences between UNION and UNION ALL in SQL Server

Description

Union Operators are used to combine the result of two or more select queries into single result set.

Primary key constraint in sql server, foreign key constraint, unique key constraint, not null, check constraint in SQL Server

Introduction:

Here I will explain primary key constraint in sql server, foreign key constraint in SQL sever, unique key constraint in sql server, not null constraint in sql server and check constraint in sql server.

Description:

A Constraint is a property that we can assign to column in table. By assigning constraint property on column we can prevent the users to enter inconsistent of data in columns. We can assign these Constraint properties during the time of creation of table (By Using CREATE TABLE statement) or during the time of changing the existing table structure (By Using ALTER TABLE statement).

how to bind generic list to gridview | Bind Database values to Generic list using asp.net | Binding custom generic class list to Gridview

Introduction

Here I will explain how to bind generic list to gridview and how to bind database values to generic list using asp.net.

Description:

In previous article I explained clearly about what is WCF and how we can use WCF in our applications. Now I will explain how to use Lists in our application to bind data to gridview and I will explain how to bind database values to generic list using asp.net. 

Unable to start debugging on the web server. The web server is not configured correctly. See help for common configuration errors. Running the web page outside of the debugger may provide further information

Introduction:

In this article I will explain how to solve unable to start debugging on the web server. The web server is not configured correctly problem in iis7.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. Now I will explain how to solve unable to start debugging on the web server. The web server is not configured correctly problem in asp.net. 

Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same.

Introduction:

In this article I will explain how to solve Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same. Problem in asp.net.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. After completion of coding I tried to run my application on my local system during that time I got error like 

how to consume (or) use wcf service in web application | how to consume (or) use wcf service in asp.net | wcf tutorial with examples for beginners

Introduction:

Here I will explain how to use or consume WCF (windows communication foundation) service in web application using asp.net.

Description:

In previous articles explained clearly what WCF (windows communication foundation) is and how to create and consume WCF service in c#(windows application) and I also explained clearly uses of WCF Service. Now in this article I will explain how to consume WCF service in web application.

There is no compatible TransportManager found for URI. This may because that you have used an absolute address which points outside of the virtual application

Introduction:

In this article I will explain how to solve The page you are requesting cannot be served because of the extension configuration problem in IIS7.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. After completion creation of WCF service I tried to host my application on my local system during that time I got error like 

The page you are requesting cannot be served because of the extension configuration problem in IIS7

Introduction:

In this article I will explain how to solve The page you are requesting cannot be served because of the extension configuration problem in IIS7.

Description:

In previous post I explained clearly about what WCF is and I explain how to create WCF sample and how to consume WCF service in our application. After completion creation of WCF service I tried to host my application on my local system during that time I got error like 

Introduction to WCF - WCF tutorial | WCF Tutorial - Windows Communication Foundation | WCF Example | WCF Sample code in asp.net 3.5 | Basic WCF Tutorial for Beginners

Introduction:

Here I will explain what WCF (windows communication foundation) is, uses of windows communication foundation and how to create and use windows communication foundation in c#.

Description:

In previous articles explained clearly what webservice is and how to create and consume webservice using asp.net . In another post I explained clearly what windows service is and how to create windows service and sample of windows service using c#. Now in this article I will explain about windows communication foundation. First we will see what a WCF (window communication foundation) is and uses of WCF (windows communication foundation) after that we will see how to create and use WCF in c#.net.

The Service on local computer started and then stopped ,Some services stop automatically if there are not in use by other services or programs

Introduction:

Here I will explain how to solve the Service on local computer started and then stopped, some services stop automatically if there are not in use by other services or programs

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals and how to install windows service in system. In my system I tried to install windows service completion writing the code but at that time I was unable to install windows service I got error like this

how to delete windows service from system

Introduction:

Here I will explain how to delete windows service in our system.

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals and how to install windows service in system. Now I will explain how to delete windows service in our system.

how to install windows service using command prompt or install/uninstall .NET windows service

Introduction:

Here I will explain how to install windows service and how to start the windows service in our local machine.

Description:

In previous article I explained clearly how to create windows service and how to run windows service in scheduled intervals. Now I will explain how to install windows service in our system.

To install windows service in your follow these steps

how to create Windows Service in c# or windows service sample in c#

Introduction:

Here I will explain what windows service is, uses of windows service and how to create windows service in c#.

Description:

Today I am writing article to explain about windows services. First we will see what a window service is and uses of windows service and then we will see how to create windows service.

how to show the tooltip for gridview header columns using asp.net

Introduction:

Here I will explain how to show the tooltip for gridview header columns using asp.net.

Description:

In previous article I explained clearly how to show tooltip for gridview rows and columns and in another post I explained clearly show up and down arrows for gridview sorting . Now I will explain how to show tooltip for gridview headers using asp.net with slight code modification using above posts. To display tooltip for gridview header first design your aspx code like this

Invalid length for a base-64 char array error during decryption of password using asp.net

Introduction:

Here I will explain how to solve the problem invalid length for a base-64 char array during decrypt of encrypted password using asp.net.

Description:

In previous post I explained clearly how to encrypt and decrypt password using asp.net . After completion code for encrypt and decrypt password if I run the program I get problem like

The requested page cannot be accessed because the related configuration data for the page is invalid problem in IIS

Introduction:

In this article I will explain how to solve the requested page cannot be accessed because the related configuration data for the page is invalid problem in IIS7.

 

Description:

Previously I explained how to solve Login failed for user in IIS. Recently I started working with IIS7 at that time I face some of strange problems to rectify those errors I did some modifications in IIS. After seen those errors I decided to write this post to help people who are need with this error.  I did one sample application and deploy application in IIS. I started running my deployed application at that time I get error like this 

System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool' in IIS7

Introduction:

In this article I will explain how to solve System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool' problem in IIS7. 

Description:

Recently I started working with IIS7 at that time I face some of strange problems to rectify those errors I did some modifications in IIS. After seen those errors I decided to write this post to help people who are need with this error.  I did one sample application and deploy application in IIS. I started running my deployed application at that time I get error like this 

System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\DefaultAppPool'

how to add Global.asax.cs file in asp.net or how to add Code behind file for Global.asax in asp.net

Introduction

Here I will explain how to add code behind file for Global.asax in asp.net.

Description:

In previous post I explained clearly about Global.asax file uses and events in asp.net. Here I will explain how to add code behind file to Golbal.asax in asp.net. In one of my project I started writing code in Global.asax file but we decided to write code in Global.asax.cs file code I tried to search for that one but that is not available in our application at that I learn one thing that is we need to add Global.asax and Global.asax.cs these files to our application. For that one first right click on solution explorer and select Add New item

What is the use of Global.asax file events in asp.net

Introduction

Here I will explain what is the purpose of Global.asax file and how we can use Global.asax file in asp.net and I will explain application level events in global.asax file.

Description:

The Global.asax file, also known as the ASP.NET application file, is an optional file that contains code for responding to application-level events raised by ASP.NET or by HttpModules.

The Global.asax file resides in the root directory of an ASP.NET-based application. The Global.asax file is parsed and dynamically compiled by ASP.NET.

Asp.net WebService or Creating and Consuming WebService in asp.net or Create and call webservice in asp.net or how to create webservice and how to use webservice in asp.net

Introduction:

Here I will explain what webservice is, uses of webservice and how to create webservice and how to consume webservice in asp.net.

Description:

Today I am writing article to explain about webservices. First we will see what is webservice is and uses of webservice and then we will see how to use webservice in our applications.

How To Set a Date Format In GridView Using ASP.NET or How to format datetime in gridview boundfield and template columns

Introduction:

Here I will explain how to set date format in gridview using asp.net

Description:

In previous post I explained how to convert datetime to date in sql server . Now I will explain how to format date in gridview. In many situations we will bind date and currency values to gridivew at that time our gridview is something like this

Ajax AutoCompleteExtender example or sample without using webservice (or) Asp.Net AJAX AutoComplete Extender From Database without using webservice

Introduction:

Here I will explain how to use Ajax AutoCompleteExtender without using webservice to display the words begin with prefix typed into the textbox using asp.net

Description:

In previous article I explained clearly how to implement AjaxAutoCompleteExtender with webservice. We can attach Ajax autocomplete exteneder to any textbox to implement this and after assign autocomplete extender to textbox and type more content than the specified minimum word length, a popup will show words or phrases starting with that value.  So the user can choose exact word from the popup panel. Here we are implementing autoCompleteextender to fetch data from the database without using Webservice.

Ajax rating control example with database or how to display value from database in rating control or display average rating for article using asp.net

Introduction:

Here I will explain how to use Ajax rating control with database to display average rating for particular article using asp.net

Description:

Previously I explained how to use Ajax Collapsible panel . Now I will explain how to use Ajax rating control with Database in asp.net. In many sites we will see rating options for books, articles and movies etc by giving rating option to user we have chance to know about particular thing how much users are feeling comfort with particular thing. In Ajax we have a rating control by using that we can display the rating option easily. Here I am storing each user rating details into database and displaying the average rating based on number of users rating. To achieve this first design one table in your database and give name like RatingDetails if you want to give another name you can but you need to change table name in code also.

RichTextbox example or sample in asp.net or how to insert or store richtextbox data into database and display richtextbox data from database in gridview using asp.net

Introduction

Here I will explain how to use richtextbox and how we can save our richtextbox data in database and how we can retrieve and display saved richtextbox data into our application using asp.net.

Description:

  

Today I am writing this post to explain about freely available richtextbox. Previously I worked on one social networking site for that we got requirement to use richtextbox at that time we search so many websites to use richtextbox but we didn’t find useful ones. Recently I came across one website and I found one free available richtextbox. We can validate and we can use richtextbox very easily and by using this richtextbox we can insert data in different formats like bold, italic and different color format texts and we can insert images also. To use free Richtextbox download available dll here FreeTextbox . After download dll from that site create one new website in visual studio and add FreeTextbox dll reference to newly created website after that design aspx page like this 

After that Design your aspx page like this 

how to resize image without losing image quality or how to reduce image file size without losing quality using asp.net

Introduction

Here I will explain how to resize an image without losing any quality from uploaded images using asp.net.

Description:

In previous post I explained clearly how to generate the thumbnails dynamically. Here I am using same concept to resize the image without losing quality just by changing scaling factor in previous post. In social networking sites after upload images they will reduce the size of the photo but the quality will be same after seen that I tried to write this post. I taken one of my pic that pic size is 3.62 MB before resize Image that is here 

Asp.net Create/generate thumbnails from images

Introduction

Here I will explain how to generate thumbnails dynamically from uploaded images and how to bind thumbnails to datalist using asp.net.

Description:

In previous post I explained clearly how to bind images from folder to datalist . Now I will explain how to generate thumbnails from uploaded images and how to bind those thumbnails to datalist using asp.net. In website development sometimes we get requirement like generating thumbnails from images without losing quality of image and it’s same like original image. For that first create one new website after that right click on that website select New Folder give name as Images because here I am using same name if you want to use another name you need to change the name in code also. After completion of adding Images folder to your website Design your aspx page like this 

Microsoft Community Contributor Award - 2011 or I got MCC (Microsoft Community Contributor Award) Award

Today I am writing this post to share my happiness with you guys because I got MCC (Microsoft Community Contributor) Award from Microsoft.

As usual I opened my hotmail and tried to check my mails during verifying mails I found one mail is from Microsoft I was surprised because in that mail they mentioned like this 

how to bind or display images from folder to datalist using asp.net or how to insert images into folder and display images from folder to datalist using asp.net

Introduction

Here I will explain how insert images into folder and how to bind the images to datalist using asp.net.

Description:

In previous post I explained clearly how to bind images from folder to gridview . Now I will explain how to save images into folder and how we can bind that images to datalist using asp.net. It’s very easy to store images in folder and binding that images to datalist. For that first create one new website after that right click on that website select New Folder give name as Images because here I am using same name if you want to use another name you need to change the name in code also after completion of adding Images folder to your website Design your aspx page like this

Ajax Collapsible Panel Control sample or how to use Ajax Collapsible Panel control using asp.net

Introduction:

Here I will explain how to use the Ajax Collapsible Panel in asp.net.

Description:

In Previous post I explained clearly how to use Ajax Accordion menu .Now I will explain how to use the Ajax Collapsible panel control in asp.net. In so many websites we will see some of collapsible panels like if we click on down arrow panel will expand automatically and if we click on up arrow that panel will collapse automatically this type of functionality we can achieve by using ajax collapsible panel control.

how to use multiple web.config files in asp.net application or working with more than one web.config file in asp.net application

Introduction:

Here I will explain how to use multiple web.config files in single application using asp.net

Description:

I attended one interview at that time they asked one question that is it possible to use multiple web.config files in single asp.net application? For that question answer is Yes we can use multiple web.config files in single web application but how? By creating web.config file in sub root folders we can use multiple web.config files in our application but each folder should contains only one web.config file. Here I will explain step by step how we can use multiple web.config files in our application.

Ajax Accordion Control Example or how to use ajax accordion control in asp.net or working with Ajax Accordion Control

Introduction:

Here I will explain how to use the Ajax Accordion control in asp.net.

Description:

In Previous post I explained clearly how to show the progressbar during check the username availability using asp.net .Now I will explain how to use the Accordion control in asp.net. Accordion control is used to bind multiple panes and display one pane at a time. This control is like having multiple collapsiblepanels where only one can be opened at a time. To use Accordion control in our code we need to design code in certain format like below

Limit number characters in asp.net multiline textbox using JavaScript

Introduction:

Here I will explain how to Show or limit the number of characters length in Multilne textbox and how to remove vertical scrollbar in Multiline textbox using asp.net

Description:

One day I found one interesting thing in one of the sms sending site in that they provide one message textbox that is allowing only 140 characters to send message and they are displaying number characters left in the messagebox to type and if we are typing text in messagebox they are displaying the percentage graph also how much percentage of characters has entered in message textbox out of 140 characters. At that time I decided to write the post based on that here I designed page with one textbox that has a multiline property and one label to display the number of characters left to type in textbox and used tables to display the percentage graphs based on text typed in textbox

 First design your aspx page like this

how to export gridview data to PDF using asp.net or Export gridview data to PDF using asp.net

Introduction:

Here I will explain how to export gridview data to PDF using asp.net.

Description:

In my previous articles I explained clearly how to export gridview data to excel or word and how to export gridview data to CSV file . Now I will explain how to export gridview data to PDF using asp.net. In asp.net we don’t have direct feature to export gridview data to PDF for that reason here I am using third party library ITextSharp reference. The dll is available here ITextSharp first download dll from this site after that create one new website in visual studio and add ITextsharp dll reference to newly created website after that design aspx page like this 

AjaxDragpanelExtender Example or how to show the login page with popup using modalpopupextender or how to use AjaxDragPanelExtender in asp.net

Introduction:

Here I will explain how to show the login page with modal popup and how to use Ajax dragpanelextender using asp.net

Description:

I saw one website that contains login button if I click on that login button login page opens with popup and we can drag and drop that login panel anywhere on that popup for looking it’s very nice at that time I decided to write post to implement login page with popup and draggable. Previosuly I explained clearly lightbox effect for login page. In that post we can show our login page with popup. Now we can see how to show login page with popup and dragble on modalpopup to implement this I am using AjaxModalPopupExtender and AjaxDragPanelExtender . i already explained clearly about how to show the progressbar during postback using AjaxModalPopupExtender. Now I will explain about AjaxDragpanelExtender.

how to export gridview data to CSV file or Export Gridview data to CSV file using asp.net

Introduction:

Here I will explain how to export gridview data to CSV or text document using asp.net.

Description:

I have one gridview that has filled with user details now I need to export gridview data to CSV file or text file. First we need to learn what is CSV file? CSV file is a text based file in which data are separated by comma and it can be opened by Excel. Each row of data in CSV file separated with commas.

RegisterForEventValidation can only be called during Render();

Introduction:

Here I will explain how to solve the problem RegisterForEventValidation can only be called during Render(); during export of gridview to excel or word or csv using asp.net.

Description:

In previous post I explained clearly how to show export gridview data to excel,word,notepad and csv using asp.net Export gridview data to Excel,Word . During export a gridview data to excel, word, notepad or csv I got error like 

Export gridview data to Excel/word document in asp.net C#

Introduction:

Here I will explain how to export gridview to Word or Excel document using asp.net in c#.

Description:

I have one gridview that has filled with user details now I need to export gridview data to word or excel document based on selection. To implement this functionality first we need to design aspx page like this 

how to show the progressbar during check the username availability or how to implement username check availabilty like yahoo using asp.net ajax

Introduction:

Here I will explain how to show the progressbar during check the username availability using asp.net Ajax or how to implement username check availabilty like yahoo using asp.net ajax.

Description:

In Previous post I explained clearly how to check the username availability using asp.net ajax Now I will explain how to show the progressbar during check the username from database just like checking the username in yahoo if you observe yahoo registration page after enter username and click on check button at that time we will see progress image during get the data from database after that result will display now we will implement the same thing in our application.

how to check username availability using asp.net ajax or check username availability in asp.net using ajax

Introduction:

Here I will explain how to check the username availability using asp.net Ajax .

Description:

I designed one registration page in that user will enter userdetails like username, password etc at the time of enter username in textbox I need to validate the username whether that username available or already taken by any other user for that I am checking username availability in database based on username. Here I am getting one problem that is after enter username in textbox I am getting the data from database and showing the result on page like whether that username available or not but at that time page gets postback and losing the entered values in textboxes for that reason I used ajax concept to check username availability.  

Control 'gvdetails' of type 'GridView' must be placed inside a form tag with runat=server

Introduction:

Here I will explain how to solve the problem Control 'gvdetails' of type 'GridView' must be placed inside a form tag with runat=server during export of gridview to excel or word or csv using asp.net.

Description:

In previous post I explained clearly how to show export gridview data to excel,word,notepad and csv using asp.net Export gridview data to Excel,Word . During export a gridview to excel, word, notepad or csv I got error like 

Change the style of ajax TabContainer in asp.net

Introduction:

Here I will explain how to show the use Ajax Tab container in asp.net effectively and how to change appearance of TabContainer by applying CSS styles in asp.net.

Description:

I have one web page that page contains lot of information about user that contains user profile details, job details and new user registration details because of that huge controls and data on webpage I face problem to maintain the webpage effectively. At that time I decided to use Ajax Tab container by using this container we can use web page space effectively. Tab container contains set of tabs that can be used to organize the page content. Tab Container is a host for number of TabPanels. Each TabPanel defines its HeaderText or HeaderTemplate as well as a ContentTemplate that defines its content. One more thing don't hesitate to learn the post completely after seen the length of the post nothing is there just design only the page contains 3 TabPanels that's why code is more for looking it's very easy to work with TabContainer

Asp.net gridview custom paging example like Numeric, first, previous, next and last

Introduction:

Here I will explain how to show the gridview with custom paging like numeric first, previous, next, last in asp.net

Description:

In previous post I explained gridview with different types of paging with available paging options in gridview but now if we want to display the gridview with custom paging like Numeric, first, previous, next and last for that we need to write some code to show the gridview paging like what we except and here I used gridview with pagertemplate to create the paging in gridview effectively for that create new website and design the aspx page like this

how to solve Microsoft JScript runtime error: Sys.Net.WebServiceFailedException: The server method 'GetSlides' failed with the following error during usage of Ajax slideshowextender control in asp.net

Introduction:

Here I will explain how to solve the problem Microsoft JScript runtime error: Sys.Net.WebServiceFailedException: The server method 'GetSlides' failed with the following error: during use of Ajax Slideshow extender control to display images from root folder using asp.net

Description:

In previous post I explained clearly how to show slideshow using AjaxSlideshowExtender control from root folder in asp.net check here . During working with Ajax SlideshowExtender I got error like

Microsoft JScript runtime error: Sys.Net.WebServiceFailedException: The server method 'GetSlides' failed with the following error: <html><head>