binding to datagridview

[dbaguru]

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/lib...atasource.aspx

The recordset is not a class from Net.

http://msdn.microsoft.com/library/de...dobjodbrec.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
"dbaguru" <db*****@discussions.microsoft.com> schreef in bericht
news:E7**********************************@microsof t.com...

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.