5.9 Displaying Database Data in Visual Basic Textboxes

How to integrate Access and VB using text boxes to display data and buttons to navigate the records.

Here's the code:

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object,ByVal e As System.EventArgs) HandlesMyBase.LoadOleDbDataAdapter1.Fill(DsPatientsAndWard1)

txtWardName.DataBindings.Add("Text", DsPatientsAndWards1, "Patients.Ward Name")
txtWardClass.DataBindings.Add("Text", DsPatientsAndWards1, "Patients.Ward Class")
End Sub

Private Sub btnNext_Click(ByVal sender As System.Object,ByVal e As System.EventArgs) Handles btnNext.Click
BindingContext(DsPatientsAndWards1, "Patients").Position = BindingContext(DsPatientsAndWards1, "Patients").Position + 1
End Sub

Private Sub btnPrevious_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrevious.Click
BindingContext(DsPatientsAndWards1, "Patients").Position = BindingContext(DsPatientsAndWards1,"Patients").Position -1

End Sub

End Class

Category:

Education

Tags:

• Visual
• Basic
• 2010
• Access
• Microsoft
• Integration
• SQL
• Query
• INNER
• JOIN
• SELECT
• FROM
• textbox
• text
• box
• link
• integrate

[ddpp08]

thank you this is great! but you know when you click on the button you can go position +1 or position -1..is there anyway of making it random everytime?

becuase im trying to create a quiz and i dont want the questions to appear in the same order

[Firchild]

@ddpp08 That's an excellent question, and I can see exactly where you're coming from.. I'm afraid in VB, I'm not sure how, I know in actionscript, I'd use a RND command to select a random number and assign that to an array.. I can look into it, but I'm really busy at the moment, so I can't guarantee a quick response... Any of you guys out there have a suggestion? You normally save my bacon when I can't get the answer!

[glaiveorb]

how did you get the oleDbAdapter and oleDBCommand?

[Firchild]

@glaiveorb Have a little look at my previous tutorials, it's all in there. They're done sequentially

[brianlb78]

were is your desktop background from? that is awesome pic of london

[Firchild]

@brianlb78 built into windows 7

[moldplan]

Great tutorial, thanks a lot.

[sxsinv]

Great video.

Best desktop pic ever.

[mrsuperted]

great vid

learned more from this vid than full year of useless lectures

saved me life wit a assignment

[northy179]

VB 2010 does a lot of this automatically however i still found this video useful to understand why it does it. thanks.

[triplecleff]

thanks in advance

[UPGU]

thanks....the way u explain the tutorials very good n easy to understand....

[ddpp08]

@Firchild yep assigning it to an array is what i thought of originally but im really new to this language and i have no idea how to do it, when you are free, if you could upload a video on that pleasee thank you very much