Important Sql Queries

Introduction: In this article i am going to give some of very useful SQL Queries that are required to us in our day to day programming life.

1. Get current Database Name:  Select DB_NAME()

2. Get Details Of All Databases Present In SQL Server: Select * from sys.databases

3. Rename A Database: Exec sp_renamedb ‘oldDatabaseName’ , ‘newDatabaseName’

Dataset Vs DataReader

Introduction: Following are some of the differences between DataSet and DataReader objects in .NET.

Dataset	DataReader
It is used in disconnected architecture	It is connection oriented.
Works with multiple tables	Works with single tables
Forward and backward scanning of data.	Only forward scanning is possible
We can make several edits on the dataset.	It is read only record set.
Occupy more memory	Occupy less memory.
Relationship can be maintained	Relationship can’t be maintained.
Relatively slower data access	Faster than data set.
Works with multiple records at a time.	Works with only 1 record at a time.
Transactions can be handled	No transaction can be handled as its read only.
Can be bind to multiple controls	Can be bind to a single control only
More overhead in memory as it is heavyweight	Lightweight object hence very less overhead
Supported by VS.Net tools	Must be manually coded.

Filter GridView Using tablesorter_filter plugin in ASP.NET

Introduction: Hey guys in the previous article i have explained how we can sort gridview and paginate gridview in asp.net at client side without making any postback to server using very small jQuery plugins for table sorting paging, filter. In this article i am going to explain how we can implement the filtering of records based on any column or group of columns either in a table or girdView. You can download each of these plugins by clicking here.

• 
  

  For Sorting a table or gridView.

  
  


• For Paging  a table or gridView.


• For filtering a table or gridView.

Gridview Paging With TableSorter Pager Plugin

Introduction:  In the previous article i have illustrated how we can use table sorter plugin into ASP.NET GridView Control to sort records displayed in gridview at client side without consuming server resources..This article describes the implementation of Pager ad-on of the table sorter plugin with GridView in ASP.NET to display paged records at the client side. So without making any post back you would be able to display desired no of records in gridview. So this would be a great approach if your application is going to contains large chunk/amount of data  that need to sort and display at client side.

Sort GridView Using Table Sorter At Client Side

Introduction:

First of all i would like to introduce you with the table sorter. It's an add-on that uses jQuery plugin to sort the table at client. Since we are sorting table at client side so no server resources is being consumed and no post back occurs and no load on server side for sorting the table. you can download this plugin from the following website www.tablesorter.com .Christian Bach is the author of this plugin which did a fantastic job.