If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?

Question Posted / guest

14 Answers
36276 Views
Ksb, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / tiger kumar

We have the option of the fetching the starting record and
the maximum record options.

_dataadapter.Fill(_dset,"Test",11,10);

It will retrieve the record from 11 to next 10 records.

Is This Answer Correct ?

11 Yes

2 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / avanish singh

_adapter.Fill(ds,11,10).
or By iterate record from 11 to 20.

Is This Answer Correct ?

7 Yes

1 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / suresh jayaraman

for(int
RowsCount=1;RowsCount<dataset.rows.count;RowsCount++)
{
if(RowsCount>10 && RowsCount<20)
{
//if you GirdView or DataGrid
Gridview1.DataSource=dataset;
GridView1.DataBind()

}
}

Is This Answer Correct ?

8 Yes

4 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / pra vesh hajela

SqlConnection conn = new
SqlConnection(AppConfiguration.ConnectionString);
SqlCommand cmd = new
SqlCommand("SelectCustomerInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//da.Fill(ds);
da.Fill(ds, 10, 10, "table");
return ds;

Is This Answer Correct ?

4 Yes

0 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / vijay

Dataset consists of DataTable collection which consists of
DataRows. Create Dataset object, then create DataRow object

Dim objRow as New DataRow

objRow(9) to objTow(19) woud give the rows between 10 and
20, as first row is stored with index 0.

Is This Answer Correct ?

7 Yes

4 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / raghwendra ji chaubey

SqlDataAdapter sda = new SqlDataAdapter(sqlquery , con);
DataSet ds = new DataSet();
sda.Fill(ds);
sda.Fill(ds, 3, 2, "SrcTables");

Is This Answer Correct ?

5 Yes

2 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / satyambabu

Is This Answer Correct ?

5 Yes

3 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / abhishek_gp3

Use Overloaded Fill() function of SqlDataAdapter Class of System.Data.SqlClient namespace.

Fill(1,2);
1- Dataset object
2- Table name

Fill(1,2,3,4);
1- Dataset Object
2- Starting Rec.
3- End Rec.
4- Table Name
--
Sample prog:
------
using System;
using System.Windows;
using System.Data;
using System.Data.SqlDataAdapter;

Class FetchRec
{
SqlConnection Con;
SqlDataAdapter Adap;
Dataset ds;

Public FetchRec()
{
Con = new SqlConnection("initial catalog=master;integrated security=yes");
Con.Open();

Adap= new SqlDataAdapter("Select ID, Name from Employee where ID > 110");

ds= new Dataset();
}//constructor end

try{
ds = Adap.Fill(ds, 10, 20, "Employee");

int rcount=ds.Tables["Employee"].Rows.Count;

for(int i=0; i < rcount ; i++)
{
Console.Writeline(ds.Tables["Employee"].Rows[i][0] + ds.Tables["Employee"].Rows[i][1]);
}

con.close();
} //try end
catch(SqlException exp)
{
MessageBox.Show(exp.Message);
}

}//class end

Is This Answer Correct ?

3 Yes

1 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / vaidyanathan r.

DataRow[] dr = new DataRow[10];
for(int i = 10 to 19)
dr[i] = DataSet1.Tables[<TableIndex>].Rows[i];

DataRow array dr contains Records between 10 and 20.

Is This Answer Correct ?

3 Yes

2 No

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?..

Answer / muthu kumar

DataSet ds = new DataSet();
ds.Load(cmd.ExecuteReader(),
LoadOption.OverwriteChanges, "sample");

DataRow[] dr = ds.Tables[0].Select("id>1 and id<10");

for (int i = 0; i < dr.Length; i++)
{
Response.Write(dr[i][0].ToString()+"<br>");

}

Is This Answer Correct ?

2 Yes

2 No