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


}

Which is the best institute in navi mumbai to learn DotNet

2 Answers  

What is ado net stands for?

0 Answers  

How can you implement sub data grid in a master datagrid?

1 Answers  

What are the benefits of ADO.NET?

0 Answers   B-Ways TecnoSoft,

What is the difference between Datareader and Dataset?

0 Answers  

What are the namespaces used in ado.net for data access?

0 Answers  

What is aggregate root?

0 Answers  

describe the dataset object in ado.net.

0 Answers  

Define executenonquery?

0 Answers  

Define data access layer?

0 Answers  

i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code

9 Answers   Wipro,

Describe the disconnected architecture of ADO.NET’s data access model.

0 Answers