Monday, December 31, 2012

Tuesday, December 25, 2012

Return SQL Query Result as XML in SQL Server- AUTO Mode

In previous post Return SQL Query Result as XML in SQL Server , I explained For XML clause for getting the query result as XML. I also explained RAW mode of this clause. Today I will explain AUTO  mode in FOR XML  clause.

Monday, December 24, 2012

Return SQL Query Result as XML in SQL Server

SQL Server gives you option to retrieve data as XML by supporting For XML clause, which you can use as a part of your query. For XML clause supports different options that let you define the format of XML data.

For XML clause supports four modes- RAW, AUTO, EXPLICIT, PATH. When you include the FOR XML clause in your query, you must specify one of these four modes.

Thursday, December 13, 2012

Validate ListBox and DropDown List using Required Field Validator

In Asp.Net, sometimes we need to validate List Box and Drop Down List using Required Field validator. Here I am sharing the code for validating List Box and Drop Down List, it is tricky and avoids to use java script function for validation.

Monday, December 10, 2012

How to delete row in data table?

In ASP.Net, we use the data tables very frequently in our application. Sometimes we need to delete the row from the data table using some filter condition. Today I will show you a simple example to delete the row from your data table based on your condition.
We have a data table structure as showing below in the image:

Saturday, December 8, 2012

Disable right click on web page and images

Sometimes it is required to prevent images on web pages being copied by another one. You can prevent the images by disabling the right click on your web page or by disabling image context menu on images only. Here I am going to share that how can you achieve this?

Disable right click on images
For disabling the image context menu on right click on images, just add the below event handler to the img or image tag as shown below

How to pass an array in a Query String?

Today I am going to give an example of passing an array in a query string. We have two pages one is Sender.aspx and second is Receiver.aspx. We will create the ArrayList in Sender.aspx and sent it to Receiver.aspx.

Friday, December 7, 2012

Creating data table programmatically in C#

Sometimes we need to create the data table programmatically in code behind. Here I am giving you a simple example of creating data table programmatically in C#.

Thursday, December 6, 2012

Select random records from database (MySQL, Oracle, MS SQL)

Sometimes we need to select random records from a table in our database. For example, if you created online test application then every time we need to get the random questions from our questions table.
Today I will give you some examples for selecting random records in some popular databases.

Tuesday, December 4, 2012

LINQ Operators:Partition Operators

This post is the part of series called LINQ Operators that brings the practical examples of LINQ operators. In previous posts we have learned about Filtering and Projection operators.Today we will see the Partition Operators in LINQ.

 

Monday, December 3, 2012

If You Enjoyed This Post Please Take 5 Seconds To Share It.

^ Scroll to Top hgpromo