Hi,
I have an atm program and i am having trouble with the lodgement part. I have an input box for the amount to lodge which will add to the balance in an access database. However when i input a value to lodge it throws up an error in the saveBalance sub about decimals saying -
Input string was not in a correct format.Couldn't store <-70.764633.333> in Balance Column. Expected type is Decimal.
Here is my code:...
javatech007
Last Activity: Mar 17 '08, 06:45 PM
Joined: Nov 14 '07
Location:
-
Converting string to double
A have a balance value in my access database that is a string but want to convert it to a string. How would i go about this? -
Database Relationship Help
I have this relationship set up but my list box wont display the child data even though the code compiles grand.
Here is the code
[CODE=.NET]
Public Sub FillCustomerAcc ounts()
Dim objDetails As DataRow, objAccount As DataRow
Dim strAccountEntry As String
lstAccounts.Ite ms.Clear()
objDetails = objDS.Tables("C ustomerDetails" ).Rows.Find(cbo Accounts.Select edItem.ToString )... -
its ok i just go it. thanks for your help -
Im after getting it now but not sure where to write in my text box in the query. See below:
[CODE=VB.NET]
Dim objSqlStr As String = "SELECT * FROM CustomerAccount s WHERE (PIN = frmATM.txtDispl ay.Text)"
[/CODE]Leave a comment:
-
Thanks but how would i do a query. what does HTH mean??...Leave a comment:
-
it shows up no error when debugged
If i delete all the loop and just equal the listbox to some text it shows the text. when i keep the loop and equal the listbox to some txt it soesnt show anything again. so i think its something to do with the loop....Leave a comment:
-
Banking database
I have an access database with customer bank records and have created an ATM program using .NET. The user enters their UNIQUE PIN to access their personal account but i am having trouble to show their balance by using their UNIQUE PIN to get their balance. Here is what i have tried.
[CODE=.VBNET]
Public Class frmBalance
Dim objDS As New DataSet
Dim objConn As New OleDb.OleDbConn ection("Provide r... -
I was able to fix that in the end but now have a new problem. My form loads up with all the information appearing in it but no information appears in my list box that uses the relationship between the 2 tables to get the information.
Here is my code for putting the info into the list box. Aswell the program runs with no errors being thrown up but it just doesnt show.
[CODE=vbnet]
Public Sub FillCustomerAcc ounts()...Leave a comment:
-
Database Relationships
I am trying to setup a relationship between 2 tables from an access database but what I have done throws up an error at the part of my code where I set up the relatonship.
Below is my code and my error on line 13 to 15 says - This constraint cannot be enabled as not all values have corresponding parent values.
Any ideas?
[CODE=.VBNET]
Public Sub Retrieve()
objDS.Clear()... -
hi,
i've a new problem now. I trying to allow the user who entered their unique PIN to be able to view their bank balance. So Im trying to take their PIN and match it with their balance from my access database! I tried this but it doesnt work.
[CODE = .NET]
Private Sub frmBalance_Load (ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
objDS.Clear()...Leave a comment:
-
hi nathan,
it worked. thanks for everthing...Leave a comment:
-
thanks you've been a great help so far but its throwing up an error for line 5 saying:
Unable to cast object of type 'System.Int32' to type 'System.String' ....Leave a comment:
-
thank you.how would i use this?...Leave a comment:
-
each customer is given a unique pin that no one else can get so if they enter that number they can withdraw money. so no just the pin....Leave a comment:
-
i did that and it shows up errors when 'int=0' is declared, for the '{' , and for (i) after rows!!...Leave a comment:
-
Database help
Hi,
I have an access database of bank customers which include a unique pin number for each customer.
I have an atm part to my program and want the pin enrty form to read the unique pins from the database to allow access or not. What i have so far below only reads the first pin from my database! Any ideas?
[CODE=vbNET]
Private Sub btnEnter_Click( ByVal sender As System.Object, ByVal e As System.EventArg s)... -
Converting types
How would you convert a string that is loaded from a txt file into a integer so it can be used for calculations? -
JComboBox help
I am trying to use comboboxes in a ticket payment screen for train tickets. I have two combo boxes. One for picking a route and the other for picking a time. What i want is when you pick a route in the first combo box, different departure times are availble in the time combobox depending on your route choice. I am trying to use if statements but its not working.
[JAVA = CODE]
routesCmb = new JComboBox();
routesCmb.addIt em("Please... -
GUI with arrays
I am trying to save data into an array from JTextFields but dont know how to go about it. I have a number of textfields to enter information into it. I dont know where to start with how to use arrays with gui. Any help?
Code so far
[CODE:JAVA]
import java.awt.*;
import java.awt.event. *;
import java.io.*;
import javax.swing.*;
public class TimetableAdmin extends JFrame implements...
No activity results to display
Leave a comment: