The CommandText property has not been properly initialized

Question

i am using vb.net and mysqladmin as my database.

i have a problem in my codes, and i don't know how to debug it. please help me..

my problem is when i click the button update the error shows
"The CommandText property has not been properly initialized."

this is the codes:

 Dim intDB_ID_Selected As Integer


'Private Sub cmdupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdupdate.Click



If MessageBox.Show("Do you want to update this record?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) = vbYes Then

 Dim sqlcommand As New MySqlCommand("UPDATE user_info " & _
                                 " SET name = '" & txtname.Text.Trim & "'," & _
                                 " address = '" & txtaddress.Text.Trim & "', " & _
                                 " age = '" & txtage.Text.Trim & "', " & _
                                 " WHERE id= '" & intDB_ID_Selected & "'", sConnection)
        Call execCmd(SQL)
        load1()
        MsgBox("Record updated successfully.", MsgBoxStyle.Information)
    End If
End Sub `


 Public Sub execCmd(ByVal PstrSQL As String)
    With cmd
        .CommandText = PstrSQL
        .ExecuteNonQuery()
    End With
End Sub

the error line is in

.ExecuteNonQuery()

i am a beginner in this language, so please help me. im begging you guys!!

What is in the SQL variable? You are passing it into the execCmd method, but I don't see where it's set. — Brendan Green, Feb 19 '14 at 02:00

score 0 · Answer 1 · answered Feb 19 '14 at 02:30

0

what is cmd and has it been initialized?

Oh, and try to used parameterized query. The earlier you get into the habit, the better.

answered Feb 19 '14 at 02:30

user2930100

346
4
10

score 0 · Answer 2 · answered Feb 19 '14 at 03:03

Try doing this instead after the messagebox selection. cmd is not properly initialized in execCmd.

Dim sqlStr as String = "UPDATE user_info " & _
                       " SET name = '" & txtname.Text.Trim & "'," & _
                       " address = '" & txtaddress.Text.Trim & "', " & _
                       " age = '" & txtage.Text.Trim & "', " & _
                       " WHERE id= '" & intDB_ID_Selected & "'", sConnection)

Dim sqlcommand As New MySqlCommand(sqlStr)
sqlcommand.ExecuteNonQuery()

load1()
MsgBox("Record updated successfully.", MsgBoxStyle.Information)

The CommandText property has not been properly initialized

.ExecuteNonQuery()

2 Answers2