Getting all databases from Sql Server 2005-2008 using c#

This code will help you in getting all databases of Sql Server and show them in the drop down list. Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table...

Read the rest of this entry »

Posted in Asp.net , c# , databases sql server 2005 , databases sql server 2008

Paging through SQL Server

This query will help you in doing paging through SQL Server. You will need to pass just the starting and ending index and it will return the records.. DECLARE @startingindex int; DECLARE @endingindex int set @startingindex=10 set @endingindex=20 select * from Table_Name where table_id in( SELECT us.table_id FROM (SELECT ROW_NUMBER() OVER (ORDER BY table_id) AS Row, Table_id FROM Table_Name) us WHERE Row >@startingindex and Row<@endingindex ...

Read the rest of this entry »

Posted in Custom Paging , Paging , Paging in Sql Server