MBR IT/.NET 247 : Select Statement Help on ASPFriends.com 'ngfx-sqlclient' list

Select Statement Help

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.

Biplab De

-- Moved from [ngfx-io] to [ngfx-sqlclient] by Victor Von Doom <Click here to reveal e-mail address> --

Hey All,

How 2 get a single record from a select statement which will produce 100 of records in output using T-SQL. I want a 10th record from that output.

Thanking U.

Biplab

_____________________________________________________________
Washington DC's Largest FREE Email service. ---> http://www.DCemail.com ---> A Washington Online Community Member --->
http://www.DCpages.com

_____________________________________________________________
Promote your group and strengthen ties to your members with Click here to reveal e-mail address by Everyone.net http://www.everyone.net/?btn=tag

Reply to this message...

Wally McClure

Something like the following should work in c#. Assuming that you have your
dataset, you can get the datatable and the datarow underneath that dataset.

//DataRow drData;
//dsData is your dataset
//dtData is your datatable
dtData = dsData["table name"];

drData = dtData.Rows[9];
// -- or --
drData = dsData.Tables["table name"].Rows[9];

Wally

----- Original Message -----
From: "Biplab De" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Monday, August 19, 2002 5:55 AM
Subject: [ngfx-sqlclient] Select Statement Help

> -- Moved from [ngfx-io] to [ngfx-sqlclient] by Victor Von Doom
<Click here to reveal e-mail address> --
[Original message clipped]

Reply to this message...

System.Data.DataRow

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com