[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