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" <ka************@i-vantage.com> escribió en el mensaje
news:uw****************@TK2MSFTNGP10.phx.gbl...

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.

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

"e-lores" <e-****@noesunemail.com> wrote in message
news:ei**************@TK2MSFTNGP12.phx.gbl...

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" <ka************@i-vantage.com> escribió en el mensaje
news:uw****************@TK2MSFTNGP10.phx.gbl...

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.

[Karunakararao]

I am using web application
pls check that code:
"Karunakararao" <ka************@i-vantage.com> wrote in message
news:Oz**************@TK2MSFTNGP09.phx.gbl...

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

"e-lores" <e-****@noesunemail.com> wrote in message
news:ei**************@TK2MSFTNGP12.phx.gbl...

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" <ka************@i-vantage.com> escribió en el mensaje
news:uw****************@TK2MSFTNGP10.phx.gbl...

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.