DataGridView Binding.(Takes along time to load)
-
Hi everyOne. I have dataGridView in my project whitch is Bind to my dataBase (Student's Table).After 3 months that the user has Saved around 3,000 rows in that table Now when they open that form with 3,000 Rows in Student's table it takes along time to load the form(Form become white). What should i do to run that form without any problem and Quickly? Thank u.
CanI
-
Hi everyOne. I have dataGridView in my project whitch is Bind to my dataBase (Student's Table).After 3 months that the user has Saved around 3,000 rows in that table Now when they open that form with 3,000 Rows in Student's table it takes along time to load the form(Form become white). What should i do to run that form without any problem and Quickly? Thank u.
CanI
You need to filter what is retrieved and or displayed. To filter what is retrieved, put a WHERE clause in the SELECT statement, to limit it to students whose name begins with 'A', for example. then allow the users to hit a 'Next' or 'Previous' button to move from the 'A's to the 'B's and vice versa. Or by their Major, or whatever. To Filter what is displayed, the
BindingSourcehas aFilterproperty that you can use to get a similar effect. Hope this helps! :)Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”