Advertisement
Guest User

oledb

a guest
Jul 26th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.77 KB | None | 0 0
  1.  dim cmdSelect = New OleDbCommand("SELECT TrTerimaBarangMst.NoBukti, TrTerimaBarangMst.Tgl, TrTerimaBarangMst.KdSupplier, TrTerimaBarangDtl.Kode, TrTerimaBarangDtl.Qtty, TrTerimaBarangDtl.Harga, [Qtty]*[Harga] AS Jumlah, Barang.Nama AS NamaBarang, Supplier.Nama AS NamaSupplier " & _
  2. "FROM ((TrTerimaBarangMst INNER JOIN TrTerimaBarangDtl ON TrTerimaBarangMst.NoBukti = TrTerimaBarangDtl.NoBukti) INNER JOIN Barang ON TrTerimaBarangDtl.Kode = Barang.Kode) INNER JOIN Supplier ON TrTerimaBarangMst.KdSupplier = Supplier.Kode " & _
  3. "WHERE tgl BETWEEN ? and ? " &
  4. "ORDER BY TrTerimaBarangMst.NoBukti", conn)
  5.  
  6. cmdSelect.parameters.addWithvalue ("?a", TglFROM.Value.Date)
  7. cmdSelect.parameters.addWithvalue ("?b", TglEnd.Value.Date.AddDays(1))
  8.  da =  New OleDbDataAdapter (cmdSelect)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement