Imports System.Data.SqlClient Module DbConnection Public conn As New SqlConnection("Data Source=YOUR_SERVER;Initial Catalog=BillingDB;Integrated Security=True") End Module Use code with caution. Adding Items to the DataGridView
Try ' Create a StreamWriter to write text to the file Using writer As New StreamWriter(filePath, False) ' False to overwrite existing file writer.WriteLine("================================") writer.WriteLine(" OFFICIAL INVOICE ") writer.WriteLine("================================") writer.WriteLine("Date: " & invoiceDate) writer.WriteLine("Customer: " & customerName) writer.WriteLine("--------------------------------") ' If using a DataGridView for items, loop through rows here writer.WriteLine("Total Amount Due: $" & totalAmount) writer.WriteLine("--------------------------------") writer.WriteLine(" Thank you for your business! ") writer.WriteLine("================================") End Using vb.net billing software source code