CodeXchange Wednesday, October 22, 2014
Home
What's it?
Download
Register
My Snippets
Add Snippet
Search
Faq
Contact Us
Sponsors

Website hosted by


Code Snippet Preview

Review the code snippet before inserting it on your project.

Snippet Metadata
Summary: grab record from db and subtracts it from variable
Language: VB.NET
Author: Marcus Reed
Author snippets RSS:
Culture: en-US
Bytes: 871
Visual Studio 2005 Snippet:

Snippet Stats
Downloads: 0
Overall rating : 0
Average rating : Snippet rating

Snippet Preview
Code:
        Try
            ' Takes a string from the textbox to find the records source in the database
            Dim aid As String = ArrestIDToolStripTextBox.Text
            Dim cmd As OleDbCommand = New OleDbCommand("SELECT SUM(AmountPaid) FROM tblPayment WHERE ArrestID ='" & aid & "'", con) ' SQL to pull the data from the database
            con.Open() ' open the connection to the database
            Dim amtpaid As Int32 = cmd.ExecuteScalar
            TextBox2.Text = amtpaid
            con.Close()
            Dim x1, x2 As Integer
            x1 = TextBox3.Text  ' Total Fine amount.
            x2 = TextBox2.Text  ' Total amount Paid so far.
            TextBox4.Text = Val(x1) - Val(x2) ' Subtracts the total fine amount from the amount paid to give us the total amount due.
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try

Snippet Comments
Comments:
No comments for this snippet

Other snippets that may interest you..
Related Snippets
TDT - GridPage - Page_Init (C#)
CustomValitaor (C#)
(C#)
Get the file extension from a file path or file name (VB.NET)
grab record from db and subtracts it from variable (VB.NET)



Copyright ©2009-2014 CodeXchange. Server version 1.0.3720.32855 Client Version 0.9.0.0

With from Barcelona

Most Helpful members
These are the members who have received the most points for their helpful samples
Zepho Zep
Robert Wagner
Galen Taylor

All time 'Hall of fame'
Formating a file size and adding the B, KB, MB and GB extension appropriately with string.Format (C#)
INI File Access (VB.NET)
Read XML from string into DataSet (C#)
Create Manifest File for your Application (VB.NET)
Round function to avoid banker's rounding (VB.NET)
Get Short and Long Path Names (VB.NET)
Sending Mail through authenticated SMTP server (C#)
One Way Hash for strings (C#)
Formating a file size and adding the B, KB, MB and GB extension appropriately with string.Format (C#)
How do I load an image from a URI address? (VB.NET)
Use our easy to use Visual Studio.NET addin client and start sharing code snippets with the CodeXchange community!
Refreshed: Wednesday, October 22, 2014