Hi
I'm hoping that somebody can help me with the following:
I have a DataTable which I'm displaying in a DataGrid. I am changing values
in this grid which need to be passed back to the DataTable and then back to
the database source.
In the grid, I sometimes only want to show some of the rows i.e. I filter
it. I do this by using a DataView to the DataTable and then filtering the
DataView which is the source to the grid.
All well and good so far!
However, I have recently added several thousand new rows to the DataTable.
When I set the DataView using:
MyDataView.Table = MyDataSet.Table("MyBigTable")
MyDataView.RowFilter = "[Col1] = 2"
However, this takes several seconds to do the first line! There are
approximately 400,000 rows in it. However, using the filter I may only be
drawing out 20 rows.
Can anybody suggest how I can speed this up?
Thanks in advance
G 3 1064
Hi,
Did you ever read the article Development guide with OleDBProNet at http://www.udaparts.com/devguide.htm
Read it. You'll know the reason.
"G .Net" <no********@email.comwrote in message
news:3d******************************@pipex.net...
Hi
I'm hoping that somebody can help me with the following:
I have a DataTable which I'm displaying in a DataGrid. I am changing
values in this grid which need to be passed back to the DataTable and then
back to the database source.
In the grid, I sometimes only want to show some of the rows i.e. I filter
it. I do this by using a DataView to the DataTable and then filtering the
DataView which is the source to the grid.
All well and good so far!
However, I have recently added several thousand new rows to the DataTable.
When I set the DataView using:
MyDataView.Table = MyDataSet.Table("MyBigTable")
MyDataView.RowFilter = "[Col1] = 2"
However, this takes several seconds to do the first line! There are
approximately 400,000 rows in it. However, using the filter I may only be
drawing out 20 rows.
Can anybody suggest how I can speed this up?
Thanks in advance
G
Sorry yererui, I don't follow
G
"yekerui" <no****@yahoo.comwrote in message
news:e1**************@TK2MSFTNGP02.phx.gbl...
Hi,
Did you ever read the article Development guide with OleDBProNet at http://www.udaparts.com/devguide.htm
Read it. You'll know the reason.
"G .Net" <no********@email.comwrote in message
news:3d******************************@pipex.net...
>Hi
I'm hoping that somebody can help me with the following:
I have a DataTable which I'm displaying in a DataGrid. I am changing values in this grid which need to be passed back to the DataTable and then back to the database source.
In the grid, I sometimes only want to show some of the rows i.e. I filter it. I do this by using a DataView to the DataTable and then filtering the DataView which is the source to the grid.
All well and good so far!
However, I have recently added several thousand new rows to the DataTable. When I set the DataView using:
MyDataView.Table = MyDataSet.Table("MyBigTable") MyDataView.RowFilter = "[Col1] = 2"
However, this takes several seconds to do the first line! There are approximately 400,000 rows in it. However, using the filter I may only be drawing out 20 rows.
Can anybody suggest how I can speed this up?
Thanks in advance
G
G.
You have always make your choise what to do on the server and what on the
client.
In this sitation it is in my idea completely clear that you should not use
here a dataview but a Where clause in your select statement.
Cor
"G .Net" <no********@email.comschreef in bericht
news:3d******************************@pipex.net...
Hi
I'm hoping that somebody can help me with the following:
I have a DataTable which I'm displaying in a DataGrid. I am changing
values in this grid which need to be passed back to the DataTable and then
back to the database source.
In the grid, I sometimes only want to show some of the rows i.e. I filter
it. I do this by using a DataView to the DataTable and then filtering the
DataView which is the source to the grid.
All well and good so far!
However, I have recently added several thousand new rows to the DataTable.
When I set the DataView using:
MyDataView.Table = MyDataSet.Table("MyBigTable")
MyDataView.RowFilter = "[Col1] = 2"
However, this takes several seconds to do the first line! There are
approximately 400,000 rows in it. However, using the filter I may only be
drawing out 20 rows.
Can anybody suggest how I can speed this up?
Thanks in advance
G This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Raymond Lewallen |
last post by:
I have a dataview in which the sort property will not sort the dataview.
Here's is a simple scenario similar to what I am doing:
Class Foo
Private Function Retrieve() As DataView
' Returns a...
|
by: Jensen bredal |
last post by:
Hello,
I use The RowFilter property to select number of row from my dataview.
How can i get the number of rows found ?
I experience that the number of rows remains the same as before the...
|
by: ignw82 |
last post by:
Hi all,
I have a strange behaviour in dataview, maybe you can help me.
the behaviour is like this :
First I made a datatable (odt) in data set, and then I created a
dataview using this...
|
by: Alpha |
last post by:
I have a window application. In one of the form, a datagrid has a dataview
as its datasource. Initial filtering result would give the datavew 3 items.
When I double click on the datagrid to edit...
|
by: Ryan Moore |
last post by:
I have a dataset (called adset) which has a column called "Large" which is
either an integer 0 or 1.
I am creating 2 dataviews, one which should display the 1's and one which
should display the...
|
by: Dazz |
last post by:
Hi
I desperately need some help. I want to have a DataView sorted
alphabetically by a specific column, then I want to find the first record
that begins with the letter the user inputs and get...
|
by: kjvt |
last post by:
Based on a prior posting, I've written a function to convert a
recordset to a dataview. The first call to the function for a given
recordset works perfectly, but the second call always returns a...
|
by: David Wender |
last post by:
I want to create a dataview with a sort on multiple columns. However,
when I use FindRows, I only want to search some of the columns, not
all. Is this possible? I have not been able to make it...
|
by: Bernie Hunt |
last post by:
I'm having trouble getting rowfiltering to work on my dataview. I have
two dataviews, one with a list of shows (dvAllShows) and the other with a
list of shows attended by a person(dvAttendedShows)....
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |