binding to datagridview

[Guest]

I have a recordset ( converted from an SQL-DMO queryresult ) that I want to
bind to a datagridview. I'm not finding any tech documents on this without
using a dataadapter or table.
thanks in advance.

 

[Cor Ligthert [MVP]]

dbaguru,

That is because that you cannot connect a recordset to a datagrid.

I don't think that it will go, in my opinion is the recordset not able to
use as one of the properties for a datagridview.

http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.datasource.aspx

The recordset is not a class from Net.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjodbrec.asp

You can use one of the overloaded methods from a dataadapter to convert it
to a datatable..

Or any other method to a class that is usable as datasource.

It helps not much however maybe something.

Cor