datagridview dinamic fill

[luibio]

How can i made SUB to fill a datagrid view with large amount of data
like SLQ 2005 query?

 

[RobinS]

If you're using VS2005, set up a strongly-typed dataset using
the DataSet Designer and then bind it to the Data Grid by
dragging it onto a form.

Robin S.

 

[luibio]

thanks to quickly, and excuse me for my english.

i just need to perform a filling method that don't lock the application
while is loading the data,
my datagridview is linked with a dataset
(datagridview.datasource=getData(query)) and
i could like to show the data like the tableview query in SQL2005, and
let me to stop
the loading of data before (if necessary) the loading of all data.

it's possible to do?
tanks.

RobinS ha scritto:

 

[RobinS]

As far as I know, you can't do that. Every sample I've seen of
using the DataGridView sets the data source = a dataset or a
datatable or a binding source that is defined accordingly.

Dim m_Adapter as CustomersTableAdapter = new CustomersTableAdapter()
Dim m_Customers as CustomersDataSet = New CustomersDataSet()
'uses table adapter to read db and fill dataset
m_Adapter.Fill(m_Customers.Customers)
m_Grid.DataSource = m_Customers.Customers

I don't think you can bind it to the results from a subroutine.
That doesn't mean you can't do it, it just means *I've*
never seen it done. Maybe it would work if you didn't allow
updates. And I don't know how you could stop it in the
middle of loading and show what you have so far, or even
how you could just stop it.

Sorry I couldn't help you more.

Robin S.
----------------------------