473,327 Members | 2,074 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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.

Expand|Select|Wrap|Line Numbers
  1. Public Class frmBalance
  2.  
  3.     Dim objDS As New DataSet
  4.     Dim objConn As New OleDb.OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source=bank.mdb")
  5.  
  6.     Dim objSqlStr As String = "SELECT * FROM CustomerAccounts"
  7.     Dim objDA As New OleDb.OleDbDataAdapter(objSqlStr, objConn)
  8.  
  9.     Private Sub frmBalance_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  10.  
  11.         objDS.Clear()
  12.         objDA.FillSchema(objDS, SchemaType.Source, "CustomerAccounts")
  13.  
  14.         objDA.Fill(objDS, "CustomerAccounts")
  15.  
  16.         Dim objRow As DataRow
  17.         objRow = objDS.Tables("CustomerAccounts").Rows.Find(frmATM.txtDisplay.Text.ToString)
  18.         txtBalance.Text = objRow.Item("Balance")
  19.  
  20.     End Sub
  21. End Class
  22.  
Mar 15 '08 #1
5 990
kenobewan
4,871 Expert 4TB
If a user enters a pin, you will need a query using their ID number. HTH.
Mar 16 '08 #2
If a user enters a pin, you will need a query using their ID number. HTH.
Thanks but how would i do a query. what does HTH mean??
Mar 16 '08 #3
Im after getting it now but not sure where to write in my text box in the query. See below:

Expand|Select|Wrap|Line Numbers
  1.     Dim objSqlStr As String = "SELECT * FROM CustomerAccounts WHERE (PIN = frmATM.txtDisplay.Text)"
  2.  
Mar 16 '08 #4
its ok i just go it. thanks for your help
Mar 16 '08 #5
kenobewan
4,871 Expert 4TB
its ok i just go it. thanks for your help
Hope This Helps. Well done!
Mar 17 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Cherrish Vaidiyan | last post by:
sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps in this site : ...
3
by: mazubair | last post by:
I am going to develop a Banking Solution for very small branches of a Bank. The branches are standalone and no remote transactions will be made i.e. only the individual branch will be under...
2
by: mazubair | last post by:
I am going to develop a Banking Solution for very small branches of a Bank. The branches are standalone and no remote transactions will be made i.e. only the individual branch will be under...
11
by: cj | last post by:
Lets assume all calculations are done with decimal data types so things are as precise as possible. When it comes to the final rounding to cut a check to pay dividends for example in VB rounding...
2
by: =?Utf-8?B?V2F5bmU=?= | last post by:
Been using Money 2005 without problem until recent. Suddenly, I can no longer add new banking accounts even though I only have 10 or 11 existing accounts. When I click on "add new account" , it...
5
by: Jervin | last post by:
Project Requirements The key elements of the project are that the project: • Needs a database support. • Have rather well defined functions with certain degree of complexity. ...
4
by: zslhiring | last post by:
Please email resumes for the following position. Location - NJ Duration - Long Term Senior Developer with minimum 5 years of development/design experience Strong C++ application development...
1
by: =?Utf-8?B?Umlja1JTQkFFbnRlcnByaXNl?= | last post by:
I am having trouble downloading my banking transactions from Wachovia Bank. The only way a business can download is thru MS Money. Can anyone tell me how they get there transactions from Wachovia?
2
by: anasanjaria | last post by:
I m working on my project, its based on a banking application. What i basically does is send bank account owners an sms after every transaction made to their account. This is to prevent fraud so if,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.