Vbnet+billing+software+source+code
' Insert Details For Each row As DataRow In dtDetails.Rows Dim detailCmd As New SqlCommand("INSERT INTO tbl_Invoice_Details (InvoiceNo, ProductID, Quantity, Rate, TaxableValue, CGST_Amount, SGST_Amount) VALUES (@invNo, @pid, @qty, @rate, @taxable, @cgst, @sgst)", conn, transaction) detailCmd.Parameters.AddWithValue("@invNo", txtInvoiceNo.Text) detailCmd.Parameters.AddWithValue("@pid", row("ProductID")) detailCmd.Parameters.AddWithValue("@qty", row("Quantity")) detailCmd.Parameters.AddWithValue("@rate", row("Rate")) detailCmd.Parameters.AddWithValue("@taxable", row("TaxableValue")) detailCmd.Parameters.AddWithValue("@cgst", row("CGST")) detailCmd.Parameters.AddWithValue("@sgst", row("SGST")) detailCmd.ExecuteNonQuery() Next
invoiceContent = sb.ToString() pd.Print() vbnet+billing+software+source+code
Remember to always: