Displaying Data from Database in Textboxes VB.net Access

Question

0.00/5 (No votes)

See more:

Hello, I am trying to display data from my database in textboxes that matches the text of the combo box however, have been unsuccessful. All the textboxes display are 0's
Here is the code I already have.

VB.NET

Private Sub ComboBox42_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ComboBox42.SelectedIndexChanged

        dataFile = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Simon\Documents\Visual Studio 2010\Projects\UWOShipTool\UWOShipTool\Ship.mdb"
        connString = dataFile
        myConnection.ConnectionString = connString
        Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Ships] WHERE [Name] = '" & ComboBox42.Text & "'", myConnection)
        myConnection.Open()
        Dim dr As OleDbDataReader = cmd.ExecuteReader

  
        While dr.Read
            Found = True
            Name = dr("Name")
            Dura = dr("Dura")
            Vertical = dr("Vertical")
            Horizontal = dr("Horizontal")
            Row = dr("Row")
            Turn = dr("Turn")
            Wave = dr("Wave")
            Armor = dr("Armor")
            Cabin = dr("Cabin")
            CannonChambers = dr("Cannon Chambers")
            Cargo = dr("Cargo")
        End While

        TextBox1.Text = Dura
        TextBox2.Text = Vertical
        TextBox3.Text = Horizontal
        TextBox4.Text = Row
        TextBox5.Text = Turn
        TextBox6.Text = Wave
        TextBox7.Text = Armor
        TextBox8.Text = Cabin
        TextBox9.Text = CannonChambers
        TextBox10.Text = Cargo
        TextBox11.Text = Adv
        TextBox12.Text = Trade
        TextBox13.Text = Battle

        myConnection.Close()

Thanks in advance. :)

Posted 30-Jan-16 8:28am

Sdolby

Updated 4-Jun-20 4:55am

Add a Solution

Comments

CHill60 31-Jan-16 18:16pm

When you debug this code do you actually enter the loop While dr.Read? Do you only enter it once?
Consider (Seriously) using parameterised queries to avoid the risk of sql injection and to make your sql queries more robust.
Try reading this article - Mastering Debugging in Visual Studio 2010 - A Beginner's Guide[^]

Sdolby 29-Aug-17 9:37am

In this case, I don't need to worry about injection. As there is no way they can input data and it's all controlled inputs. However, when I wrote this code I was quite new to SQL and now I know better I paramaterise it(And barely even write in VB.net)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ivan_FM · Accepted Answer · 2016-02-13T00:51:00

I think you have to try the following: