A secure login form to restrict access to the billing module. Conclusion
End Class Use code with caution. Copied to clipboard 3. Key Components for Advanced Systems vb.net billing software source code
Private Sub btnSaveInvoice_Click(sender As Object, e As EventArgs) Handles btnSaveInvoice.Click Try Dim db As New dbConfig() db.OpenConnection() Dim cmd As New SqlCommand("INSERT INTO Invoices (CustomerName, InvoiceDate, TotalAmount) VALUES (@name, @date, @total)", db.conn) cmd.Parameters.AddWithValue("@name", txtCustomerName.Text) cmd.Parameters.AddWithValue("@date", DateTime.Now) cmd.Parameters.AddWithValue("@total", CDec(lblGrandTotal.Text)) cmd.ExecuteNonQuery() MsgBox("Invoice Saved Successfully!", MsgBoxStyle.Information) db.CloseConnection() Catch ex As Exception MsgBox(ex.Message) End Try End Sub Use code with caution. 7. Advanced Features to Add A secure login form to restrict access to the billing module
Private Sub FormatDataGridView() dgvCart.Columns("ProductID").Visible = False dgvCart.Columns("ProductCode").HeaderText = "Product Code" dgvCart.Columns("ProductName").HeaderText = "Product Name" dgvCart.Columns("Quantity").HeaderText = "Qty" dgvCart.Columns("UnitPrice").HeaderText = "Unit Price" dgvCart.Columns("GST").HeaderText = "GST %" dgvCart.Columns("Total").HeaderText = "Total" dgvCart.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill End Sub TotalAmount) VALUES (@name
Search over 1000+ Lessons from our extensive library.