Venkateswara Rao Desu

Fruits in telugu english

2012-01-07T03:52:00.000-08:00

Ref: http://www.indif.com/food/refer/glossary/fruit.asp

English	Hindi	Bengali	Assamese	Oriya	Marathi	Gujarati	Tamil	Telugu	Kannada
Apple	Seb	Sebu	Aapel	Seu	Safarchand	Safarjan	Applepazham	-	Sebu
Amarnath Leaves	Chaulai	-	-	-	-	-	-	Totakura	-
Artichoke	Arbi / Ghuiyan		-	-	-	-	-	-	-
Ashgourd / White gourd	Petha	Chal Kumdo	Saal Kumura*	Pani Kakharu	Kohala	Petha	Pooshanikai	Boondia Gummadi	Bodi Kumbala
Avocado	-	Kulanshpati	-	-	-	-	-	-	-
Banana	Kela	Kola	kol	Champa Kadali	Kele	Kela / Kelu	Vazhai Kizhangu	Arati Pandu	Bale Hannu
Beet Root	Caquander	Beet	-	Bita	Beet	Beet	Beet	-	Beet
Bitter Gourd	Karela	Karela	Tita Kerela	Kalara	Karle	Karela	Pavakkai	Kakarakaye	Hagalkai
Bottle Gourd / Marrow	Lauki	Laoo	Jati Lao	Lau	Dudhi	Dudhi	Suraikai	Sorakaya	Sorekai
Brinjal/Eggplant	Baingan	Begun	Bengena	Bigana	Wangi	Ringna	Kaththarikai	Vankaya	Badanekai
Broad/Butter Beans	Sem	Seam*	Urahi	Shimba	Ghewda	Valor	Avaraikai	Peddachikkudu	Chkapparadavare
Cabbage	Patha Gobhi	Bandha Kopee	Bondhakobi	Patrakobi	Pan kobi	Kobi	Muttaikosu	Kosu	Kosu
Capsicum/Bell Pepper	Simla Mirch	Lanka	Kashmiri Jalakia	Simla Lanka	Bhopli Mirchi	Simla Marchan	Kuda Milakai	Pedda Mirappa	Donne Menasinakai
Carrot	Gajar	Gajar	Gajor	Gajar	Gajar	Gajar	Mangal Mullangi	Gajjara Gadde	Gajjari
Cauliflower	Phool Gobhi	Phool kopee*	Phoolkobi	Phulakobi	Fulkobi	Phoolkobi	Kovippu	Khosu Povvu	Hookosu
Chilli	Mirch	Lanka	Jalakia	Marcho	Mirchi	-	-	Mirapakayalu	Menasinakai
Cluster Beans	Gawaar Phali	Jharasim	-	Gunnarachhuin	Gawar	Guvar	Kothavarangai	Kasugadda	Gorikayi
Cow peas	Lobhia	Barbati	Dangbodi*	Chani	Chavli	Chota	Karamani	Bobbarlu	Alsande
Coconut	Nariyal	Narkol	Narikol	Nadia	Naral	Nariyel	Thengai	Kobbari Kaaya	Thenginikai
Colocassia	Arbi	Kochu	kosu	Saru	Alu Kanda	Alvi/ Alu	Seppal Kizhangu	Chamadumpa	Sama Gadde
Corriander/cilantro	Dhania	Dhonay Pata	Dhania Paat	Dhania	Kothimbir	Kothmir	Kothamalli Ilaigal	Kothimiri	Kothambir Soppu
Corn	Bhutta	Bhutta	Gum-dhaan	Makka	Makka	Makai	Makka Cholam	Mokka Jonna	Kothambari Beeja
Cucumber	Kheera/Kakdi	Sasha	Tiyoh	Kakudi	Kakadi	Kakadi	Kakkarikai	Dosakayi	Southkayi
Custard Apple	Sharifa	Ata	Aatloss*	Ata	Sitaphal	Sitafal	Seetha Azham	Seetha Phalam	Seetha Phalam
Dates	Khajoor	Khejoor	Khejur	Khajura	Khajur	Khajoor	Pericham Pazham	Kharjoora Pandu	Kharjoora
Drumstick	Sahjan ki Patti	Sajnae Dauta	Sajina	Sajana Chhuin	Shevgyachya Shenga	Sargva Ni Sing	Murungakkai	Munagakayalu	Nuggekai
Dry Plums	Aloo Bhukhara	Sookno Kool	Sukan Bogori	Barakoli Jateeya Phala	Alubukar	Jardalu	Aalpacota Ular Pazham	-	-
French Beans	Flas ki Phali	French Beans	Faras Been	French Beans	Farsabi	VaalFansi	Beans	French Chikkudu	Avare
Fenugreek Leaves	Methi	Methi Sag	Methi Xaak*	Methi Saga	Methi Bhaji	Methi Bhaji	Venthiya Keera	Menthikora	Menthya Soppu
Garlic	Lasan	Rasoon	Naharoo	Rasuna	Lasun	Lasan	Ulipoondu	Vellulli	Bellulli
Ginger	Adrak	Ada	Ada (Kesa)	Ada	Aale	Adu	Inji	Allam	Ashi Shunti
Goose berry	Amla	Amla	Aamlokhi*	-	Awla	Amla	-	Usiri	Nalli kai
Grapes	Angoor	Angoor	Angoor	Anjoori	Draksha	Draksha	Draksha	Draksha	Draksha
Green Berry	Ber	Boroi	-	-	Bor	Bor	-	Regi pandu	-
Green Chillies	Hari Mirch	Kancha Lanka	Kesa Jalakia	Kancha lanka	Hirvya Morchya	Lila Marcha	Pachchai Milagai	Pachchi Mirapakayalu	Hasi Menasina Kai
Green Mango (Raw)	Ambi / Kaacha Aam	Kacha Aam	Kesa aam		Keri	Keri	Manga	Pachhi Mamidikaya	Mavinakayi
Guava	Amrood	Payara	Madhurium	Pijuli	Peru	Peru	Koyya Pazham	Jaama Pandu	Seebe
Jackfruit	Kathal	Kanthal	Kothaal	Panasa	Phanas	Phanas	Pilapinju	Panasa	Halasu
Jambu Fruit	Jamun	Jam*	Jamuk*		Jambhool	-	-	Jeedi Kaya/ Neredu Pandu	-
Kohlrabi	Ganth Gobhi	-	Ool Kobi*	-	-	-	-	-	-
Lady Finger/Okra	Bhindi	Dhanroce	Bhendi	Bhendi	Bhendi	Bhinda	Vendakai	Bendakaya	Bendekai
Lemon	Nimboo	Nembu	Nemu	Lembu	Limbu	Motu Limbu	Yelumicham Pazham	Nimma Sahan	Gaja Nimbe
Lettuce	Salad ke Patte	Salad Patta	Laipaat	Lettuce	Saladchi Paane	Salat	Salathu	Pala Koora	Lettuce Soppu
Lime	Nimbu	Lebu	Gool Nemu*	Lembu	Limbu	Limbu	Narthangai*	Nimma Pandu	Nimbe
Lotus stem	Kamal Kakdi/Bhein	Padda Pata	Podum-daal		Kamal Deth	Kamal Kakdi	Thamarathandu	Thamarkada	-
Mango	Aam	Aam (pakka)	Aam*	Amba	Amba	Keri	Mam Pazham	Mamidi Pandu	Mavina Hannu
Maskmelon/Cantalope	Kharbooja	Kharmuj	-	-	Kharbhooja	Kharbooja	Mulam Pazham	Kharbooja	Kharbooja
Mint Leaves	Pudina	Pudina	Podina	Podana Patra	Pudina	Fudina	Pudhinaa	Pudina Aaaku	Pudina Sopu
Mulberry	Shahtoot	-	Nuni*	-	-	-	-	-	-
Mushroom	Goochi	-	-	-	Alambi	-	Kalaan*	Putta Godugu	-
Mustard Leaves	Sarson ke Patte	Sorisa Sag	Xoriyohor aag	Sorisha Patra	Mohari Cha Pan	Rai Ni Bhaji	Kadugu Ilai	Ava Akalu	Sasuve Yele
Olive	Jaitoon	Jalpai*	Jolfai	-	-	-	Olive pazham	-	-
Onion	Pyaaz	Pyaj	Piyaaz	Piaja	Kanda	Kanda	Vengayam	Neerulli	Eruli
Orange	Santra	Kamala Leboo	Sumothira	Kamala	Santre	Santra	Kichili Pazham	Kamala Pandu	Kittale
Papaya	Papita	Pempe	Omita	Amrut Bhanda	Popai	Papiya	Pappalikai	Boppayi Pandu	Parangi
Parwal	Parwal	Patol	Patol	Potala	-	-	-	-	-
Parsley	Ajmoda Ka Patta	Parsley	Sugandhi Lota	Balabalua Shaga	Ajmoda	Ajmo	Kothamalu Ilaigal Pole	Kothimeera Jati Koora	Kottambari Jothiya Soppu
Pear	Nashpati	Nashpati	Naspoti	Nashpati	Nashpati	Nashpati	Berikkai	Berikkai	Berikkai
Peas	Matar	Motor	Motormah	Matar	Matar	Vatana	Pattani	Batanelu	Batani
Pineapple	Ananas	Anarash	Anarox	Sapuri Anasianas	Ananas	Ananas	Anasi Pazham	Anasa Pandu	Ananas
Plantain (green)	Hara Kela	Kach Kela *	Kaas-kol	Bantalakadali	Kele	Kela	Vazzhakkai	Aratikayi	Balekayi
Plantain Flower	Kela Ka Phool	Mocha	Koldil	Kadali Bhanda	Kele Phool	Kel Phool	Vazhaippu	Aratipowu	Bale Motho
Plum	Aloobukhara	Aloobukhara	-	-	-	Jaldaru	Alpaghoda	ALUBHUKARA pandu	-
Pomegranate	Anar	Dalim	Dalim	Manji	Dalimbache	Dadamna	Mathalam Pazham	Danimma Pandu	Dalimbari
Potato	Aloo	Aloo	Aloo	Alu	Batate	Batata	Urulaikizhangu	Bangaala Dumpa	Alugadda
Pumpkin	Kadoo	Misti Kumra*	Ronga-lau	Kakhuru	Lal Bhopla	Kolu	Parangikkai	Gummadikayi	Kumbalo
Radish	Mooli	Mula	Mula	Mula	Mula	Mulo	Mullangi	Mullangi	Mullangi
Raw Banana	Hara Kela	-	Kesa kol	-	-	Kacha Kela	Vazhakai	Aratikaya	Balle Kaya
Red Chillies	Lal Mirchi	Lal Lanka/ Morich*	Sukan Jalakia	Nali Lankamaricha	Lal Mirchya	Lal Marcha	Milagai Vatral	Erra Mirapa Kayalu	Kenepu Menasinakai
Sappotta	Chiku	-	-	-	Chiku	-	-	Sapota	-
Spring Onions	Hara Pyaaz	Piaj Keli	Piyaaz Paat*	-	Pati Kanda	Kili Bungli	-	Ulli Kadalu	Eruli kavu
Spinach	Palak	Palang Sag	Paleng xaak	Palanga Saga	Palak	Palak	Pasalai Keeral	Palakoora	Spinak Soppu
Sweet Potato	Shakarkandi	Rangalu	-	Kandamula	Ratalu	Ratalu	Sakkara Vali Kizhangu	Chilgada Dumpa	Genasu
Sweet Lime	Mausambi	Musambi	Mausambi	-	Mausambi	Mosambi	Sathukudi*	Battai	Musambi
Star Fruit	Kamrak	Kamranga*	Kordoi	-	-	-	-	-	-
Tomato	Tamatar	Tomato	Bilahi	-	Tomato	Tameta	Thakkali*	-	Tomato
Turnip	Shalgam	Salgam*	Saalgum*	-	-	-	Kirini pazham*	ఎర్ర ముల్లంగి దుంప Erra Mullangi	-
Water Melon	Tarbooj	Tarmuj*	-	-	Kalingad	Tadbooch	Dharbhusni pazham*	Puchha Kaya పుచ్చ కాయ	kallangari hannu
Water Chestnuts	Singhara	Paniphal	-	Panisingara	Shingara	Shingoda	-	Kubyakam	-
Wood Apple	Bhel	Kothbel	Kot Bel*	Kaitha	Kavith	Kothu	Chenaikizhangu	Velega Pandu	Bele
Yam	Jimikand	Suran	Kaath Aloo	Deshi Alu	Suran	Suran	Senai Kizhangu	Kanda Dumpa	Suvarna Gadde
Zucchini	Torai	-	-	-	Dodka	-	-	Beerakaya	-

Sending Files via FTP From Your Java Applications

2009-02-24T23:44:00.001-08:00

Ref:

how I send files via FTP and SFTP from my java applications part 1

how I send files via FTP and SFTP from my java applications part 2

Cross browser pop up opener and select options for a Text box

2009-02-17T22:25:00.001-08:00

Main.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">

</SCRIPT>
</HEAD>
<BODY>
<form method=post action='' name=f1>
    <INPUT TYPE="hidden" NAME="localIdfield" id="localIdfield">
    <INPUT TYPE="hidden" NAME="localNameField" id="localNameField">
    <table border=0 cellpadding=0 cellspacing=0 width=550>
    <tr>
        <td >
            <font size=2 face='Verdana'>Program Manager</font>
            <input type="text" disabled="true" name="programManagerContactId" id="programManagerContactId" size='8'>
            <input type="hidden" name="programManagerName" id="programManagerName" size='8'>
            <a href="javascript:void(0);" NAME="My Window Name" title=" My title here " onClick="javascript:searchPopUp('programManagerContactId','programManagerName');">Search Program Manager</a>
        </td>
    </tr>
    <tr>
        <td >
            <font size=2 face='Verdana'>             Auditor</font>
            <input type="text" disabled="true" name="auditorContactId" id="auditorContactId" size='8'>
            <input type="hidden" name="auditorName" id="auditorName" size='8'>
            <a href="javascript:void(0);" NAME="My Window Name" title=" My title here " onClick="javascript:searchPopUp('auditorContactId','auditorName');">Search Auditor</a>
        </td>
    </tr>
</table>
</form>
</BODY>
</HTML>

popUp.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>

        opener.document.getElementById(parentIdField).value = document.getElementById(local_id).value;
        opener.document.getElementById(parentNameField).value =document.getElementById(local_name).value;
        self.close();
    }
</script>

<title>(Type a title for your page here)</title>
</head>

Dot Net Installer download direct links

2009-02-10T21:40:00.001-08:00

Ref from : http://www.msfn.org/board/lofiversion/index.php/t122149.html

.NET Frameworks 1.1, 1.1SP1, 2SP1 are full downloads .NET Framework 3 and 3.5 from the general MSDN and windows update site are bootstrappers (installs, checks config, and then downloads what's needed). Microsoft Dot Net Framework 3.0 Bootstrapper 2.8 MB
CODE
http://www.microsoft.com/downloads/details.aspx?familyid=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en
Microsoft Dot Net Framework 3.0 SP1 is a full download Microsoft Dot Net Framework 3.0 Redistributable 50.3 MB - Direct Link
CODE
http://go.microsoft.com/fwlink/?LinkId=70848

Microsoft Dot Net Framework 3.5 Bootstrapper 2.7 MB
CODE
http://www.microsoft.com/downloads/details.aspx?familyid=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en
Microsoft Dot Net Framework 3.5 Redistributable 33.3 MB
CODE
http://www.microsoft.com/downloads/details.aspx?FamilyID=e3821449-3c6b-42f1-9fd9-0041345b3385&DisplayLang=en
Microsoft Dot Net Framework 3.5 Full Package 197 MB Direct Link
CODE
http://download.microsoft.com/download/6/0/f/60fc5854-3cb8-4892-b6db-bd4f42510f28/dotnetfx35.exe
It's the last one - the 197 MB file that looks to contain all preceding Dot NET versions... It also looks like it contains the x64 architecture files as well - I'm just not too sure???

Spring Mail and Gmail SMTP server

2009-02-03T01:24:00.001-08:00

Spring Mail and Gmail SMTP server

February 1, 2008 at 9:04 pm · Filed under open source, spring

In case you need to use Spring Mail with Gmail SMTP server, first of all configure a mail sender bean:
 <bean id= "mailSender" class= "org.springframework.mail.javamail.JavaMailSenderImpl" > <property name= "host" value= "${mail.host}" /> <property name= "port" value= "${mail.port}" /> <property name= "username" value= "${mail.username}" /> <property name= "password" value= "${mail.password}" /> <property name= "protocol" value= "${mail.protocol}" /> <property name= "javaMailProperties" > <props> <prop key= "mail.smtps.auth" >true</prop> <prop key= "mail.smtps.starttls.enable" >true</prop> <prop key= "mail.smtps.debug" >true</prop> </props> </property> </bean>

We could take to a property file the relevant properties:
mail. host = smtp. googlemail . com mail. port = 465 mail. username = yourUsername mail. password = yourPassword mail. protocol = smtps

Let’s see an integrational test for this:
public class SimpleMailSenderTest extends AbstractDependencyInjectionSpringContextTests { protected MailSender mailSender ; public SimpleMailSenderTest () { setPopulateProtectedVariables ( true ); } @ Override protected String [] getConfigLocations () { return new String [] { ”applicationContext. xml ” }; } public void testSendEmail () throws Exception { SimpleMailMessage simpleMessage = new SimpleMailMessage (); simpleMessage. setFrom ( ”fromEmail” ); simpleMessage. setTo ( ”toEmail” ); simpleMessage. setText ( ”Testing text” ); simpleMessage. setSubject ( ”Testing subject” ); mailSender. send ( simpleMessage ); } }

In case we have a template for sending these emails we could define a template message bean:
<bean id= "templateMessage" class= "org.springframework.mail.SimpleMailMessage" > <property name= "from" value= "fromAddress" /> <property name= "to" value= "toAddress" /> </bean>

Alternatively, we could also specify replyTo, cc, bcc, sentDate, subject and text.

Spring Mail and Gmail SMTP server

2009-02-03T01:17:00.001-08:00

Spring Mail and Gmail SMTP server

February 1, 2008 at 9:04 pm · Filed under open source, spring

Alternatively, we could also specify replyTo, cc, bcc, sentDate, subject and text.

One liners -- Hidden meanings in Company talk

2009-01-22T23:49:00.000-08:00

One liners -- Hidden meanings in Company talk
Today's Professional Management FUNDAS

1."We will do it" means "You will do it"

2."You have done a great job" means "More work to be given to you"

3."We are working on it" means "We have not yet started working on the same"

4."Tomorrow first thing in the morning" means "Its not getting done "At least not tomorrow!"

5."After discussion we will decide-I am very open to views" means "I have already decided, I will tell you what to do"

6."There was a slight miscommunication" means "We had actually lied"

7."Lets call a meeting and discuss" means "I have no time now, will talk later"

8."We can always do it" means "We actually cannot do the same on time"

9."We are on the right track but there needs to be a slight extension of the deadline" means "The project is screwed up, we cannot deliver on time."

10."We had slight differences of opinion "means "We had actually fought"

11."Make a list of the work that you do and let's see how I can help you" means "Anyway you have to find a way out no help from me"

12."You should have told me earlier" means "Well even if you told me earlier that would have made hardly any difference!"

13."We need to find out the real reason" means "Well I will tell you where your fault is"

14."Well Family is important; your leave is always granted. Just ensure that the work is not affected," means, "Well you know..."

15."We are a team," means, "I am not the only one to be blamed"

16."That's actually a good question" means "I do not know anything about it"

17."All the Best" means "You are in trouble"

Virtual box back up and restore VDI files

2008-11-18T02:36:00.001-08:00

The command is this:

VBoxManage clonevdi /home/winship/.VirtualBox/VDI/WinXP.vdi /media/storage2/tmp/WinXP.vdi

To restore it, go to File->Virtual Disk Manager->Add and select your backup .vdi file

CSS browser hacks

2008-09-28T23:32:00.001-07:00

height:10px;
_height:20px;/* ignored by IE6 */

*height:20px;/* ignored by IE7 */

#container[id] { width: 820px; } /* ignored by IE */

Read resource files from class library: resx files from dll

2008-07-16T22:26:00.000-07:00

set up for resource files in Visual studio:

Add the below line in your class

ResourceManager rm = new ResourceManager("%NAMESPACE TO BE REPLACE WITH THE DEFUAT NAMESPACE OF LIBRARY%.ErrorMessages", Assembly.GetExecutingAssembly());
rm.GetString("%RESOURCE KEY HERE%");

thats it ,... to read resource in a dll from the same dll

How to exclude .svn folders from project -Eclipse

2008-02-14T00:04:00.000-08:00

Ref:
http://pyre.third-bit.com/blog/archives/101.html
http://lists.ofbiz.org/pipermail/dev/2006-January/009586.html
http://www.malcolmhall.com/?p=98

I’ve just began using Eclipse instead of IntelliJ and one thing had me stumped for an hour. My src folder was under SVN but my bin folder wasn’t, however when I compile, the tortoise plugin for windows explorer suddenly showed the bin folder as under SVN with an exclamation over the folder icon. What was going on? It appears that when Eclipse builds, it copies any files and folders form the src folder to the bin folder including the .svn hidden folders. I had just about given up with Eclipse then I started hunting for a way to manually exclude the .svn folders from the build. A few attempts at making my own exclude pattern which only worked in a few cases I finally found this neat solution on the web:

Modify the project’s java build path to exclude the pattern **/.svn/

Here’s complete directions:
Project / Properties / Java Build Path / Source / unfold your project / Excluded / Edit / Exclusion patterns / Add / “**/.svn/*”

Configuring Java on Linux

2007-12-13T03:39:00.000-08:00

http://sdnshare.sun.com/view.jsp?id=1018

Exo ECM Architectiure request process

2007-12-13T03:29:00.000-08:00

Exo_platform Architecture

Form request->to portlet (UIPortlet’s subclass) or UICommand class -> sets Renderer using (VelocityRenderer), sets class using setClazz
-> gets RequestInfo using RequestInfo class -> using a Business service object (For ex:OrganizationService)-> gets Handler(Handler Implementor which is like a DAO) -> using hibernate service ->gets data from database and puts in java objects -> Performs
Business process

Exo-ECM postgres SQL configuration

2007-12-13T03:22:00.000-08:00

1) JDBC Driver – copy the driver to application service lib directory.
URL: jdbc:postgresql:postgres
Driver Class: org.postgresql.Driver
Username: postgres
Password: postgres
2) Configure the driver .
http://docs.exoplatform.org/exo-documents/exo-jcr.site/dbcontainer.html
Single-database configuration:
Configure the “database-configuration.pgsql.xml” and “database-configuration.xml” available in “%EXO-TOMCAT-HOME%/conf” directory to postgres: (If ‘database-configuration.pgsql.xml’ not available then take a content copy of ‘database-configuration.hsql.xml’ file and create new one)
The changes includes update the url of data base, driver class, username, password and dialect.
Here are the details for Poetgres:
URL: jdbc:postgresql:postgres
Driver Class: org.postgresql.Driver
Username: postgres
Password: inkriti
Dialect: org.hibernate.dialect.PostgreSQLDialect

3) Intigration

Work n progress:
We are getting issues while creating the tables into postgres data base as hibernate configuration for postgres sql is different from hsql(Ex: In scenarios of identity generation is different for different data bases)

JAVA char set UTF-7

2007-11-04T23:34:00.000-08:00

content from : http://www.freeutils.net/source/jcharset/

What is the Java Charset package?
The Java Charset package is an open-source implementation of character sets that were missing from the standard Java platform.
How do I use the Java Charset package?
The Java Charset package is written in pure Java, and thus requires no special installation. Just add the "jcharset.jar" file to your classpath, or place it in any of the usual extension directories.
The JVM will recognize the supported character sets automatically, and they will be available anywhere character sets are used in the Java platform.
As an example, you can take a look at java.lang.String's constructor and getBytes() method, both of which have an overloaded version that receives a charset name as an argument.

ASP.Net AJAX toolkit Control Library

2007-10-01T03:58:00.000-07:00

ASP.Net with AJAX::
Wonderful toolkit

http://www.asp.net/ajax/ajaxcontroltoolkit/

To create your own AJAX control Library

http://www.asp.net/ajax/ajaxcontroltoolkit/samples/Walkthrough/CreatingNewExtender.aspx

Working with Database ASP.Net & C#.Net 2.0

2007-09-18T12:04:00.000-07:00

For running large queries with ASP.Net and C#.Net in SQL Server 2005,

http://www.asp.net/learn/data-access/tutorial-25-cs.aspx
http://static.asp.net/asp.net/files/DataTutorials/datatutorial25cs.pdf

Data Tutorials Start Page

Introduction

Basic Reporting

Master/Detail

Custom Formatting

Editing, Inserting, and Deleting Data

Paging and Sorting

Paging and Sorting Report Data
Efficiently Paging Through Large Amounts of Data
Sorting Custom Paged Data
Creating a Customized Sorting User Interface

Custom Button Actions

Adding and Responding to Buttons to a GridView

Displaying Data with the DataList and Repeater

Filtering Scenarios with the DataList and Repeater

Editing and Deleting Data Through the DataList

Paging and Sorting with the DataList and Repeater

Custom Button Actions with the DataList and Repeater

Custom Buttons in the DataList and Repeater

Accessing the Database Directly from an ASP.NET Page

Enhancing the GridView

Working with Binary Files

Caching Data

Database-Driven Site Maps

Building a Custom Database-Driven Site Map Provider

Working with Batched Data

Advanced Data Access Scenarios

SELECT DEPTNO, ROW# FROM DEDBADM.DEPT TB1, TABLE (SELECT COUNT(*) + 1 AS ROW# FROM DEDBADM.DEPT TB2 WHERE TB2.DEPTNO < TB1.DEPTNO) AS TDEPT_TAB
WHERE ROW# BETWEEN 2 AND 4;