SQL Server data Access Layer

I have a class i use for most of my data access. I am trying to get a datatable from sql Server, i need to pass my stored procedure name and paramater names and values. But i want this to handle any # of params so i am thinking of using a collection or array but then i need to fiqure out how to set the param types im a little confused my 1st try is to execute spLogin : SELECT [id], [Uid], [Pw], [writ], [Maint] FROM [CM].[dbo].[Usrs] WHERE [Uid] =AtSignUid and [Pw]= AtSignpw so in my calling code im thinking dim Dt as new Datatable = [login to view URL]("spLogin" , array or collection) then in dataserver class: Public Function GetDataTbl(ByVal spName as string, arrayCol as ..) As [login to view URL] Dim drow As DataRow 'use schema Dim Index As Integer Dim dt As New [login to view URL] Dim dr As SqlDataReader Dim cmd as SqlCommand Dim counter As Integer = [login to view URL] - 1 Dim aobjFields(counter) As Object For i As Integer = 0 To counter [login to view URL]([login to view URL](i)) Next Do While [login to view URL] drow = [login to view URL] [login to view URL](aobjFields) For Index = 0 To counter On Error Resume Next drow(Index) = CStr(aobjFields(Index)) Next [login to view URL](drow) On Error GoTo 0 'handle Cstr(null) Loop Return dt End Function as you can see i am very new to sqlServer and i am kinda lost , and the parts where i didnt know what to do i just left out so sorry about that , also on idea of using get schema and using the getSQLiNT32 Methods compared to my old Oledb stuff ANY and all help or tips appreciated!!! ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP