Database help

[javatech007]

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?

 
    Private Sub btnEnter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEnter.Click
 
        Dim balance As New frmBalance
 
        If txtDisplay.Text = CStr(objDS.Tables(0).Rows(rowIndex)("PIN")) Then
            Me.Hide()
            balance.Show()
        End If
 
    End Sub
 
 

[nateraaaa]

What is the value of rowIndex? If you want to search the entire table you will need to use a loop.

 for(int i = 0; i < objDS.Tables.Rows.Count; i++) 
{
If txtDisplay.Text = CStr(objDS.Tables(0).Rows(i)("PIN")) Then
Me.Hide()
balance.Show()
End If
}
 

Nathan

[kunal pawar]

U can used rowfilter property of defaultview class of dataset.table(). this will help to filter record in ur datatable

[debasisdas]

How you will find the unique PIN ?

Are you passing anything to the database like the user name or Account number or anything else ?

[javatech007]

What is the value of rowIndex? If you want to search the entire table you will need to use a loop.

 for(int i = 0; i < objDS.Tables.Rows.Count; i++) 
{
If txtDisplay.Text = CStr(objDS.Tables(0).Rows(i)("PIN")) Then
Me.Hide()
balance.Show()
End If
}
 

Nathan

i did that and it shows up errors when 'int=0' is declared, for the '{' , and for (i) after rows!!

[javatech007]

How you will find the unique PIN ?

Are you passing anything to the database like the user name or Account number or anything else ?

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.

[javatech007]

U can used rowfilter property of defaultview class of dataset.table(). this will help to filter record in ur datatable

thank you.how would i use this?

[nateraaaa]

i did that and it shows up errors when 'int=0' is declared, for the '{' , and for (i) after rows!!

Sorry. That was the way that a for loop is written in C#. Here is how it should look in vb.net

 
Dim balance As New frmBalance()
 
For i As Integer = 0 To objDS.Tables(0).Rows.Count - 1
 
If txtDisplay.Text = DirectCast(objDS.Tables(0).Rows(i)("PIN"), String) Then
 
Me.Hide()
 
balance.Show()
 
End If
 
Next
 
 

Nathan

[javatech007]

Sorry. That was the way that a for loop is written in C#. Here is how it should look in vb.net

 
Dim balance As New frmBalance()
 
For i As Integer = 0 To objDS.Tables(0).Rows.Count - 1
 
If txtDisplay.Text = DirectCast(objDS.Tables(0).Rows(i)("PIN"), String) Then
 
Me.Hide()
 
balance.Show()
 
End If
 
Next
 
 

Nathan

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'.

[nateraaaa]

Replace the , String with , System.Int32 and that should fix your problem. Basically it is saying PIN is an integer type and the code on line 5 is trying to retrieve a string.

Nathan

[javatech007]

Replace the , String with , System.Int32 and that should fix your problem. Basically it is saying PIN is an integer type and the code on line 5 is trying to retrieve a string.

Nathan

hi nathan,

it worked. thanks for everthing

[javatech007]

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.EventArgs) Handles MyBase.Load

objDS.Clear()
objDA.FillSchema(objDS, SchemaType.Source, "CustomerAccounts")

objDA.Fill(objDS, "CustomerAccounts")

Dim objRow As DataRow
objRow = objDS.Tables("CustomerAccounts").Rows.Find(frmATM. txtDisplay.Text.ToString)
txtBalance.Text = objRow.Item("Balance")

End Sub

[/code]

[nateraaaa]

When you say it doesn't work what does that mean? Are you not getting any data back for the balance? Is the code throwing an error? You may want to use a try catch block in your code to catch an exceptions being thrown.

Nathan