Query to get a particular row in Sql Server 2005

In this article we will look into how to write a sql query to get a particular row in sql.

Lets write the code to find 2nd row in a table named mcc_measures.

So first we declare a temporary table

declare @temp table (id int) 

No in this temp table we insertrow numbers of the table

insert into @temp(id)

SELECT 
ROW_NUMBER() over(ORDER BY Measure_Id DESC)
FROM 
mcc_measures

Now from the temp table we select the row where rowid=2 as required

SELECT
*
FROM
@temp
WHERE
id = 2

kick it on DotNetKicks.com

Shout it

pimp it

Twitter from ASP.NET Application

twitter
This post will throw a light on how we can update our status on Twitter from an asp.net application.

The task is pretty simple as we have libraries already available on the net.

I will be using twitterizer dll to perform the task.

The following are the steps to be followed:

  1. Download the twitterizer dll from here.
  2. Add the reference to the dll in your asp.net web application.
  3. Write the code. For example
    Twitter t = new Twitter(UserName, Password);
    t.Status.Update(UpdateString);

Following are the methods and the capabilities provided by these methods which are present in the library:

User Methods

  1. Followers
  2. Friends
  3. Follow User

Status Methods

  1. User Timeline
  2. Public Timeline
  3. Friends Timeline
  4. Show
  5. Update
  6. Destroy
  7. Replies

Direct Messages

  1. Sent To User
  2. Sent From User
  3. New Direct Message

References: Twitteriser Home Page

kick it on DotNetKicks.com

Shout it

pimp it

Save Asp.NET Session state in SQL Server

dotnetlogo
Session states of the asp.net application can be easily saved into SQL Server using the following steps:

  1. Change the settings in the web.config file.
     <sessionState mode=   allowCustomSqlDatabase="true"  
    cookieless="false" timeout="20" sqlConnectionString=
    "database=Test_globalBms ;
    user id=abc;password=abc123$;server=172.27.68.1 " />
    
  2. In the database create the appropriate tables.It is done automatically wen we execute the exe aspnet_regsql.exe located at C:\WINDOWS\Microsoft.NET\Framework\v2.0. location

kick it on DotNetKicks.com