Guest User

Untitled

a guest
May 19th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.83 KB | None | 0 0
  1. Public Shared Function getfuifproductenfromcategorie(ByVal fuifId As Integer, ByVal categorie As String) As List(Of FuifProduct)
  2.         Dim fuifProductLijst As New List(Of FuifProduct)
  3.         Dim connectionStringNaam As String = "conString"
  4.         Dim sqlString As String = "select * from fuifproduct fp where fpfuifid=? and fpcategorie=?"
  5.         Dim parameters(1) As OleDbParameter
  6.         Dim fuifIdParam As OleDbParameter = database.createParameter(fuifId)
  7.         Dim categorieParam As OleDbParameter = database.createParameter(categorie)
  8.         parameters(0) = fuifIdParam
  9.         parameters(1) = categorieParam
  10.         Dim reader As OleDbDataReader = database.GetReader(connectionStringNaam, sqlString, parameters)
  11.         fuifProductLijst = getFuifProductenFromReader(reader)
  12.         Return fuifProductLijst
  13.     End Function
Add Comment
Please, Sign In to add comment