CODEWITHSUNDEEP
sqlvb.net
Niam
Niam

Reputation: 37

How to retrieve data and display from database where id = random number?

trying to display data from my database where the id equals to a previously generated number, unfortunately I recieve an error which says 'unknown column q1 in where clause'. The database table has 3 columns, idtopic1, question, answer. Any help is appreciated, thanks.

Here is my code:

    Private Sub ViewBtn_Click(sender As Object, e As EventArgs) Handles ViewBtn.Click
    MysqlConn = New MySqlConnection
    MysqlConn.ConnectionString =
    "server=localhost;userid=root;password=root99;database=database"
    Dim READER As MySqlDataReader
    Dim rndnum As Random
    Dim q1 As Integer
    rndnum = New Random
    q1 = rndnum.Next(1,5)
    Dim q1display As String

    Try
        MysqlConn.Open()
        Dim Query As String
        Query = "select question from database.topic1 where idtopic1= q1"
        COMMAND = New MySqlCommand(Query, MysqlConn)
        READER = COMMAND.ExecuteReader
        q1display = Convert.ToString(COMMAND.ExecuteScalar())
        q1box.Text = q1display

        MysqlConn.Close()
    Catch ex As MySqlException
        MessageBox.Show(ex.Message)
    Finally
        MysqlConn.Dispose()
    End Try
   End Sub
   End Class

Upvotes: 0

Views: 36

Answers (1)

cslin
cslin

Reputation: 21

Change following line:

Query = "select question from database.topic1 where idtopic1= q1"

To:

Query = "select question from database.topic1 where idtopic1= " & q1

Upvotes: 2

Related Questions