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.

Answer / avanish singh

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

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()

}
}

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;

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.

Answer / raghwendra ji chaubey

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

Answer / satyambabu

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.

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

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.

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>");


}

what is connection pooling ?

3 Answers   Vertex,

How to find the given query is optimised one or not?

0 Answers  

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers  

What are the ado.net connection pooling parameters?

0 Answers  

What does adodb stand for?

0 Answers  

What are the major difference between classic ADO and ADO.NET?

0 Answers  

Which control of the BindingNavigator returns the current position within the data source?

0 Answers  

What is ado.net tutorial?

0 Answers  

What is the difference between oledb sql server and oledbdotnet provider?

0 Answers  

Which object is used to add relationship between two Datatables?

0 Answers  

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

0 Answers  

What are the rules to implement connection pooling?

0 Answers