Vbnet+billing+software+source+code -
Public Sub CloseConnection() If conn.State = ConnectionState.Open Then conn.Close() End If End Sub
' Check if already in cart Dim existingRow() As DataRow = cartTable.Select($"ProductID = productID") If existingRow.Length > 0 Then existingRow(0)("Quantity") += 1 Dim qty As Integer = Convert.ToInt32(existingRow(0)("Quantity")) Dim totalBeforeGST As Decimal = qty * price Dim gstAmt As Decimal = totalBeforeGST * (gstPercent / 100) existingRow(0)("GST_Amount") = gstAmt existingRow(0)("Total") = totalBeforeGST + gstAmt Else Dim gstAmt As Decimal = price * (gstPercent / 100) Dim totalWithGST As Decimal = price + gstAmt cartTable.Rows.Add(productID, pName, 1, price, gstPercent, gstAmt, totalWithGST) End If CalculateTotals() txtProductCode.Clear() txtProductCode.Focus() Else MessageBox.Show("Product not found!") End If End If End Sub vbnet+billing+software+source+code
Public Sub ExecuteNonQuery(ByVal query As String) Try OpenConnection() cmd = New SqlCommand(query, conn) cmd.ExecuteNonQuery() Catch ex As Exception MessageBox.Show("Error: " & ex.Message) Finally CloseConnection() End Try End Sub End Module Secure authentication using salt-hash (simplified here for demo). Public Sub CloseConnection() If conn
Introduction In the world of small to medium-sized retail businesses, supermarkets, and restaurants, billing software is the backbone of daily operations. While cloud-based solutions are popular, desktop applications built with VB.NET and SQL Server (or MS Access) remain highly relevant due to their speed, offline accessibility, and low cost of ownership. and low cost of ownership.