Tip on filling DataSet in C#

Hi all gurus out there!

When i use the Wizard to create some fields from a table it creates, the
dataset, bindingsource and tableadapter.

Now for the problem. When i open that form in my program, it automaticly
fills the dataset with all the records in the table. In this case there is
over one milion records. It takes ages to fill the dataset and view the
form.

So i created a Fill procedure that only gets the first 1000. Now if the
customer want to search beond this record how can i do that, ie fill the
dataset with the next record from the table....

Alla in all, i just want to fill the dataset with x records, then fill x
record at a time when clicking next.

Any suggestions, links to a nice page describing this problem?

Regards
Martin



.

Relevant Pages

  • Q: Tip on filling a DataSet.
    ... When i use the Wizard to create some fields from a table it creates, ... dataset, bindingsource and tableadapter. ... Alla in all, i just want to fill the dataset with x records, then fill x ...
    (microsoft.public.dotnet.languages.csharp)
  • Easiest Way To Point To New Database, I Created Data Source And Connection to It, Then Dragged Table
    ... have to delete my DataGridView, re-create the DataSet, TableAdapter, ... BindingSource, and BindingNavigator. ... I have to use the wizard! ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data Access Layer using TableAdapter & Performance / Packaging
    ... TableAdapter wizard to generate the data access layer. ... "A TableAdapter connects to a database, executes queries, or stored ... statements or existing stored procedures in the database. ...
    (microsoft.public.dotnet.general)
  • Re: Databinding a datagridview control
    ... 2- Follow the wizard to create a datatable/tableadapter with the query ... wizard. ... Dim cmd as New SqlCommand ... Dim myBindingSource As BindingSource = New BindingSource ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Create SQL Mobile database on desktop
    ... when you associate a control to the dataset created by the wizard, you have to components added to your form: ... i don't know if it this due of beta state of VS or because it is a PDA database but some things are missing to complete the connection: some properties of the bindingsource and a tableadapter ... in this video, the adapter is added to the form by VS but not in mine ...
    (microsoft.public.sqlserver.ce)
Loading