[thelist] .NET: Parameters with a DataAdapter?
Casey Crookston
caseyb at thecrookstons.com
Sat Mar 29 15:36:57 CDT 2008
Hi,
These few lines of code do a great job of returning a dataset, but I'm not
sure how to pass a parameter into the stored proc. Do I need to switch to
using an SqlCommand?
Public Shared Function GetAdvertisersByLetter(ByVal FirstLetter As String)
As DataSet
Dim drAdvertisers As New DataSet()
Dim dataAdptr As New SqlDataAdapter("Advertiser_By_Letter_test", dbConn)
dataAdptr.Fill(drAdvertisers)
Return drAdvertisers
End Function
Thanks,
Casey
More information about the thelist
mailing list