getting data from database asp.net

Question

i am trying to get data from ms access database using this code but i can not this is my code is this correct

Dim query As String = "SELECT [data] FROM tabless WHERE user = '" & user.Text & "'"
Using connection As New OleDbConnection(connectionString)

    Dim cmd As New OleDbCommand(query)  
    Dim adapter As OleDbDataAdapter = New OleDbDataAdapter(query, connection)    
    Dim com As New OleDbCommand(query, connection)    
    connection.Open()
    'on the line below I get an error:  connection property has not been initialized    
    Dim reader As OleDbDataReader = cmd.ExecuteReader()

    While reader.Read()
        Label1.Text = (reader(0).ToString())
    End While

    reader.Close()

End Using

Database

|data|
  asl

trying to get data from database and trying to show it in a label is this possible

Dim reader As OleDbDataReader = cmd.ExecuteReader() connection property has not been initialized — Craftx398
– Craftx398, Commented May 5, 2017 at 1:23
That information should be part of your question. Please edit it in there, and realize that you need to include that type of information in every question you post. We shouldn't need to ask you for that. — mason
– mason, Commented May 5, 2017 at 2:30

mason · Accepted Answer · 2017-05-05 02:35:12Z

2

You never associated cmd with the connection, and you never use com or adapter. This is the sort of thing you can figure out by stepping through your code line by line and inspecting the state of it.

Dim query As String = "SELECT [data] FROM tabless WHERE user = '" & user.Text & "'"

Using connection As New OleDbConnection(connectionString)

    Dim cmd As New OleDbCommand(query, connection)
    connection.Open()
    Dim reader As OleDbDataReader = cmd.ExecuteReader()

    While reader.Read()
        Label1.Text = (reader(0).ToString())
    End While

    reader.Close()

End Using

Also, your code is vulnerable to a SQL Injection Attack. You should not be concatenating strings together to form your queries. You should instead use parameterized queries.

answered May 5, 2017 at 2:35

mason

32.8k12 gold badges83 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting data from database asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related