Contoh Aplikasi Program Penjualan Dengan Vb.net 2008 May 2026
Imports System.Drawing.Printing Public Class frmNota Private WithEvents pd As New PrintDocument() Private teksNota As String
Private Sub btnSimpanTransaksi_Click(sender As Object, e As EventArgs) Handles btnSimpanTransaksi.Click Koneksi() Dim trans As OleDbTransaction = conn.BeginTransaction() Try ' Simpan ke header penjualan cmd = New OleDbCommand("INSERT INTO penjualan (no_faktur, tgl, id_customer, total_bayar) VALUES (@faktur, @tgl, @idcust, @total)", conn, trans) cmd.Parameters.AddWithValue("@faktur", txtNoFaktur.Text) cmd.Parameters.AddWithValue("@tgl", dtpTanggal.Value) cmd.Parameters.AddWithValue("@idcust", cmbCustomer.SelectedValue) cmd.Parameters.AddWithValue("@total", total) cmd.ExecuteNonQuery() contoh aplikasi program penjualan dengan vb.net 2008
Private Sub pd_PrintPage(sender As Object, e As PrintPageEventArgs) Handles pd.PrintPage e.Graphics.DrawString(teksNota, New Font("Arial", 12), Brushes.Black, 100, 100) End Sub End Class Cara termudah tanpa Crystal Reports: Buat form frmLaporan.vb dengan DateTimePicker dari tanggal sampai tanggal, lalu tampilkan di DataGridView: Imports System
Sub CetakNota(noFaktur As String) ' Ambil data dari database teksNota = "NOTA PENJUALAN" & vbCrLf & "No Faktur: " & noFaktur & vbCrLf & "==================" ' ... tambahkan detail barang ... PrintPreviewDialog1.Document = pd PrintPreviewDialog1.ShowDialog() End Sub total_bayar) VALUES (@faktur
Imports System.Data.OleDb Public Class frmBarang Private Sub frmBarang_Load(sender As Object, e As EventArgs) Handles MyBase.Load TampilkanData() End Sub
' Load customer ke ComboBox Koneksi() da = New OleDbDataAdapter("SELECT id_customer, nama FROM customer", conn) dt = New DataTable() da.Fill(dt) cmbCustomer.DataSource = dt cmbCustomer.DisplayMember = "nama" cmbCustomer.ValueMember = "id_customer" TutupKoneksi() End Sub