Need to populate first 2000 records

[Karunakararao]

Hi All

i have 40,000 records.
populate the total records in Datagrid . it's taken time

I need to populate the first 2000 records After the need to populate next
2000 records.
how can i do it using datagrid.
inC#.Net
..
Advance Thank u
Venu.

 

[e-lores]

You can use limit or top in your SELECT sentences to limit the results that
you obtain from DataBase.
If you want to work in local, you can use the property DataViewManager to
personalize your DataSet.

I hope this help you.
Ernesto Lores.

 

[Karunakararao]

How can i do it using " DataViewManager"

and DataSet.

Plese send once u have any idea of this.

Iam doing like this

OleDbDataAdapter dadEquipList = new
OleDbDataAdapter(selectEquipmentQuery,OledbHelper.CONN_STRING);

DataSet dsEquipList = new DataSet();

dadEquipList.Fill(dsEquipList, "Mrequests");

DataView dvEquipList = new DataView();

dvEquipList = dsEquipList.Tables["Mrequests"].DefaultView;

dgdEquipment.DataSource = dvEquipList;

dgdEquipment.DataBind();

 

[Karunakararao]

I am using web application
pls check that code:

How can i do it using " DataViewManager"

and DataSet.

Plese send once u have any idea of this.

Iam doing like this

OleDbDataAdapter dadEquipList = new
OleDbDataAdapter(selectEquipmentQuery,OledbHelper.CONN_STRING);

DataSet dsEquipList = new DataSet();

dadEquipList.Fill(dsEquipList, "Mrequests");

DataView dvEquipList = new DataView();

dvEquipList = dsEquipList.Tables["Mrequests"].DefaultView;

dgdEquipment.DataSource = dvEquipList;

dgdEquipment.DataBind();

You can use limit or top in your SELECT sentences to limit the results that
you obtain from DataBase.
If you want to work in local, you can use the property DataViewManager to
personalize your DataSet.

I hope this help you.
Ernesto Lores.