By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,474 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,474 IT Pros & Developers. It's quick & easy.

how to fill datagrid faster

P: n/a
I have already done some code to fill the datagrid. my problem is that
the fill method is too slow after executing my code.

here is the scenario.

i have a parent/child form. all is datagrid. one datagrid is a parent
and the other is a child. now when i finish encoding data from the
first datagrid (which is the parent) i have to click the check box
button on that grid and fill the 2nd grid w/ the data from the other
table base on the criteria on the first table. i'm using stored
procedure to insert data. but the problem is when i reload the dataset
using the fill method the execution is too slow.

here is my code.
DsStudentCourse1.Tables("SchYrSemCourseJoin").Clea r()
SqlDataAdapter3.Fill(DsStudentCourse1) 'this code makes the
execution slow

this code will clear the data first then fill again so that the newly
inserted record will be refresh.

my question is on how can i speed loading a data on my datagrid.
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
jaYPee,

Faster is a real relative conception.

However in my idea can you get better ask this as well in the newsgroup

microsoft.public.dotnet.framework.adonet

You know of course that this is not to tell you go away here and if I was
you I would surely check any answer here as well.

Problem with your question is that you need to know a lot about your
application, the data your are filling (when it is an immage by instance it
can be terrible slow) and the ammount of rows you are filling.

I hope it helps anyway something.

Cor

"jaYPee" <hi******@yahoo.com>
I have already done some code to fill the datagrid. my problem is that
the fill method is too slow after executing my code.

here is the scenario.

i have a parent/child form. all is datagrid. one datagrid is a parent
and the other is a child. now when i finish encoding data from the
first datagrid (which is the parent) i have to click the check box
button on that grid and fill the 2nd grid w/ the data from the other
table base on the criteria on the first table. i'm using stored
procedure to insert data. but the problem is when i reload the dataset
using the fill method the execution is too slow.

here is my code.
DsStudentCourse1.Tables("SchYrSemCourseJoin").Clea r()
SqlDataAdapter3.Fill(DsStudentCourse1) 'this code makes the
execution slow

this code will clear the data first then fill again so that the newly
inserted record will be refresh.

my question is on how can i speed loading a data on my datagrid.

Nov 21 '05 #2

P: n/a
jaYPee,

Faster is a real relative conception.

However in my idea can you get better ask this as well in the newsgroup

microsoft.public.dotnet.framework.adonet

You know of course that this is not to tell you go away here and if I was
you I would surely check any answer here as well.

Problem with your question is that you need to know a lot about your
application, the data your are filling (when it is an immage by instance it
can be terrible slow) and the ammount of rows you are filling.

I hope it helps anyway something.

Cor

"jaYPee" <hi******@yahoo.com>
I have already done some code to fill the datagrid. my problem is that
the fill method is too slow after executing my code.

here is the scenario.

i have a parent/child form. all is datagrid. one datagrid is a parent
and the other is a child. now when i finish encoding data from the
first datagrid (which is the parent) i have to click the check box
button on that grid and fill the 2nd grid w/ the data from the other
table base on the criteria on the first table. i'm using stored
procedure to insert data. but the problem is when i reload the dataset
using the fill method the execution is too slow.

here is my code.
DsStudentCourse1.Tables("SchYrSemCourseJoin").Clea r()
SqlDataAdapter3.Fill(DsStudentCourse1) 'this code makes the
execution slow

this code will clear the data first then fill again so that the newly
inserted record will be refresh.

my question is on how can i speed loading a data on my datagrid.

Nov 21 '05 #3

P: n/a
jaYPee wrote:
I have already done some code to fill the datagrid. my problem is that
the fill method is too slow after executing my code.

here is the scenario.

i have a parent/child form. all is datagrid. one datagrid is a parent
and the other is a child. now when i finish encoding data from the
first datagrid (which is the parent) i have to click the check box
button on that grid and fill the 2nd grid w/ the data from the other
table base on the criteria on the first table. i'm using stored
procedure to insert data. but the problem is when i reload the dataset
using the fill method the execution is too slow.

here is my code.
DsStudentCourse1.Tables("SchYrSemCourseJoin").Clea r()
SqlDataAdapter3.Fill(DsStudentCourse1) 'this code makes the
execution slow

this code will clear the data first then fill again so that the newly
inserted record will be refresh.

my question is on how can i speed loading a data on my datagrid.


Maybe should look into optimizing your SQL statement. Maybe it already
is, but I've seen loads of people use very inefficient queries.

--
Rinze van Huizen
C-Services Holland b.v.
Nov 21 '05 #4

P: n/a
jaYPee wrote:
I have already done some code to fill the datagrid. my problem is that
the fill method is too slow after executing my code.

here is the scenario.

i have a parent/child form. all is datagrid. one datagrid is a parent
and the other is a child. now when i finish encoding data from the
first datagrid (which is the parent) i have to click the check box
button on that grid and fill the 2nd grid w/ the data from the other
table base on the criteria on the first table. i'm using stored
procedure to insert data. but the problem is when i reload the dataset
using the fill method the execution is too slow.

here is my code.
DsStudentCourse1.Tables("SchYrSemCourseJoin").Clea r()
SqlDataAdapter3.Fill(DsStudentCourse1) 'this code makes the
execution slow

this code will clear the data first then fill again so that the newly
inserted record will be refresh.

my question is on how can i speed loading a data on my datagrid.


Maybe should look into optimizing your SQL statement. Maybe it already
is, but I've seen loads of people use very inefficient queries.

--
Rinze van Huizen
C-Services Holland b.v.
Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.