data grid with stored procedure as a data source

[larry mckay]

Hi,
I'd like to use a datagrid with a

1. most grid's use SQL data adapters as a datasource. I'd like to use
a parametrized query into a stored procedure (specifically a
sqldatareader) instead of using the data adapter.

does anyone have any code samples that will do this?
I'm looking for gridname.datasource = mydatareader (if this is possible)
where the sqldata reader returns a result set from a parametrized stored
procedure.

2. I'd also like a code snip of leveraging the grid to perform a LIVE
update to the datasource (where the data source IS NOT A bound to a sql
server table). I'd actually like to have the modifications of the table
rows as input to save records in the table, but the VIEW that the grid
gives the user COULD be a join from 2 tables.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Herfried K. Wagner [MVP]]

* larry mckay <la***@larrymckay.com> scripsit:

I'd like to use a datagrid with a

1. most grid's use SQL data adapters as a datasource. I'd like to use
a parametrized query into a stored procedure (specifically a
sqldatareader) instead of using the data adapter.

If you don't get an answer here, you may want to post to this group:

NG for Windows Forms + databinding:

<news://news.microsoft.com/microsoft.public.dotnet.framework.windowsforms.dat abinding>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>