Drop or Remove Foreign Key Constraint in SQL Server 2008

Introduction:

Here I will explain how to create or remove / drop foreign key constraint in sql server.  Foreign key constraint in one table point to primary key in another table in sql serverand foreign key constraint is used to prevent the actions that would destroy the links between two tables.

Description:

In previous articles I explained Primary key constraint in sql server, foreign key constraint in sql server, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to remove foreign key constraint in sql server.

How to make a simple USB Desktop Locker in C#

Introduction :
Today I will show you how to make a USB locker for your desktop in C# Windows Application which will keep your computer unlock unless until you plugged out the pen drive. Sounds interesting?  You will find this kind of software in the Internet by search it in Google or in any other search engine. But it comes more happiness when you did it yourself. So lets come make our own USB Desktop locker.

How to do?
First of all take a pen drive, don't get frighten, your pen drive will be safe and workable. Then open the Visual Studio and add a new Windows Application project. As a form is added by default, so you don't need to add any more. Its enough.

SQL Server Convert Table Data to XML Format using XML PATH, XML AUTO or XML RAW

Introduction:

Here I will explain how to convert table data to xml format in sql server or get table data in xml format in sql server. We can convert sql server table data in xml format by using XML AUTO or XML PATH or XML RAW.

Description:

In previous articles I explained SQL Server Get Data in XML format  group by columns, Reading XML data file using SQL query, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to convert table data to xml format in sql server or get table data in xml format in sql server.

SQL Server - Get Data in XML Format Based on Group by Columns in SQL Server with Example

Introduction:

Here in sql server I will explain how to get data in xml format based on group by columns in sql server with example or sql server group columns and show in xml format.

Description:

In previous articles I explained cursor example in sql server, While loop example in sql server, nested while loop example in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain cursor how to get data in xml format based on group by columns in sql server with example.

Sorting Columns in Repeater Control in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to implement sorting in repeater control in asp.net using c#, vb.net with example or how to sort columns in repeater control in asp.net using c#, vb.net.

Description:
  
In previous articles I explained Repeater Control Example in asp.net, Display time like facebook/twitter like 1 minute ago, hour ago, use of using statement in c#, make some cells read only in excel sheet and many articles relating to asp.net, c#,vb.net and JQuery. Now I will explain how to implement sorting in repeater control in asp.net using c#, vb.net with example.

jQuery Get Dropdownlist Selected Value Onchange Event Example

Introduction: 

Here I will explain how to use jQuery to get dropdownlist selected value onchange Event or jQuery dropdown change event get selected value or jQuery get dropdownlist selected value onchange event.

Description:
  
In previous articles I explained jQuery check if checkbox is checked or not, jQuery change opacity of image on mouseover, jQuery change image on mouseover, jQuery dropdown with images, jQuery show alert message while leaving from website, jQuery Countdown timer script example and many articles relating to jQuery and asp.net. Now I will explain how to get dropdownlist selected value during onchange event.

ASP.Net - Add Items to Dropdownlist Programmatically on Button Click in C# and VB.Net

Introduction: 

Here I will explain how to add items to dropdownlist programmatically on button click in asp.net using c# and vb.net or dynamically add items to dropdownlist on button click in asp.net using c# and vb.net.

Description:
  
In previous articles I explained Cascading dropdownlist example in asp.net, highlight gridview records based on search in asp.net, filter gridview records based on dropdown selection in asp.net and many articles relating to asp.net, c#,vb.net and JQuery. Now I will explain how to add items to dropdownlist programmatically in asp.net using c# and vb.net.

C# - Create Windows Form Application Setup File in C#.Net

Introduction: 

Here I will explain how to create setup file for windows form application in visual studio 2008 in c# with example. To create setup file windows application in c# we need to use setup and deployment section templates in visual studio.

Description:
  
In previous articles I explained constructors in c# with examples, difference between virtual, override, new keywords in c#, Difference between sessionstate and viewstate, Highlight gridview rows on mouseover in jQuery and many articles relating to asp.net, c#,vb.net and JQuery. Now I will explain how to create setup file for windows form application in visual studio 2008 in c# with example.

jQuery String indexOf Method Example in JavaScript (Uses of indexof Method in jQuery)

Introduction: 

Here I will explain what is string indexof method in JavaScript or jQuery and uses of indexof method in JavaScript or jQuery with example. Indexof method in jQuery or JavaScript is used to check whether particular word existing in string or not and we can get position of first occurrence of word in string. This indexof method will return -1 incase if the word not exists in string in JavaScript or jQuery.

Description:
  
In previous articles I explained jQuery check if checkbox is checked or not, jQuery change opacity of image on mouseover, jQuery change image on mouseover, jQuery dropdown with images, jQuery show alert message while leaving from website, jQuery Countdown timer script example and many articles relating to jQuery and asp.net. Now I will use of string indexof method in JavaScript or jQuery.

jQuery Validation to Check Terms and Conditions Checkbox Checked or Not

Introduction: 

Here I will explain how to implement jQuery validation for terms and conditions checkbox checked / not or check terms and conditions checkbox selected or not using jQuery or restrict user to accept terms and conditions using jQuery.

Description:
  
In previous articles I explained jQuery check if checkbox is checked or not, jQuery change opacity of image on mouseover, jQuery change image on mouseover, jQuery dropdown with images, jQuery show alert message while leaving from website, jQuery Countdown timer script example and many articles relating to jQuery and asp.net. Now I will how to check terms and conditions checkbox status selected or not using jQuery.