dataset

[shine]

I want to retrieve first 3 records of first table and last 4 records of
second table, How to do this using c# and dataset?

Any suggestion would be greatly appretiated

[Keko]

if use to sql :

string Top3= "SELECT TOP 3 * FROM yuordatatable";
SqlDataAdapter YourComm = new SqlDataAdapter( Top3, yoursqlConn );
"shine" wrote:

I want to retrieve first 3 records of first table and last 4 records of
second table, How to do this using c# and dataset?

Any suggestion would be greatly appretiated

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

First records:

dataset.Tables[ table1 ].Rows[0]
dataset.Tables[ table1 ].Rows[1]
dataset.Tables[ table1 ].Rows[2]

Last Records:
dataset.Tables[ table2 ].Rows[ dataset.Tables[ table2 ].Rows.Count-1]
dataset.Tables[ table2 ].Rows[ dataset.Tables[ table2 ].Rows.Count-2]
dataset.Tables[ table2 ].Rows[ dataset.Tables[ table2 ].Rows.Count-3]

Note you need to check if the tables have more than 2 records.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"shine" <sh***@discussions.microsoft.com> wrote in message
news:78**********************************@microsof t.com...

I want to retrieve first 3 records of first table and last 4 records of
second table, How to do this using c# and dataset?

Any suggestion would be greatly appretiated