Hello
Using VS2005 and VB.net when creating a DataGrid you drag and drop to
connect to a SQL Server database. But can a DataGrid connect to a SQL Server
database using a sub procedure or function using a parametized query and if
so how?

Yes

Just set up a data adapter and set the resulting dataset to the
bindingsource

HTH

Michel


"winlin" <winlin@verizon.com> schreef in bericht
news:6128229B-C24E-4AA5-ACD0-F372A75467F7@microsoft.com...
[quoted text, click to view]

I show how to do this (and a lot more) in an article I wrote for
Developer.Com http://www.developer.com/db/article.php/10920_3693236_1
Yes, this might be more than you need, but there are walk-through examples
here that should get your started. My book has more basic (and more
advanced) examples as well.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
[quoted text, click to view]