Cant't Update SQL Server Table in VB.NET

Question

Using Visual Studio 2002 and Microsoft SQL Server. My code does not produce an error, but still the SQL Server table is is still unaffected. :(

The "Add" version of this code works well. . it's just the update. T_T

    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click

    Try
        ''Open DBase
        dbOpen()
        Dim cmd As New SqlCommand()
        Dim cmdm As New SqlCommand()

        cmd.CommandText = "UPDATE [Currency] SET Country= @Country, Unit= @Unit , Code= @Code WHERE ISO= @ISO"

        Dim paramISO As New SqlParameter()
        paramISO.ParameterName() = "@ISO"
        paramISO.Value() = txtIso.Text
        cmd.Parameters.Add(paramISO)

        Dim paramCountry As New SqlParameter()
        paramCountry.ParameterName() = "@Country"
        paramCountry.Value() = txtCountry.Text
        cmd.Parameters.Add(paramCountry)

        Dim paramUnit As New SqlParameter()
        paramUnit.ParameterName() = "@Unit"
        paramUnit.Value() = txtUnit.Text
        cmd.Parameters.Add(paramUnit)

        Dim paramCode As New SqlParameter()
        paramCode.ParameterName() = "@Code"
        paramCode.Value() = txtCurrencyCode.Text
        cmd.Parameters.Add(paramCode)

        MessageBox.Show("Record Updated! ", "Update Status", MessageBoxButtons.OK, MessageBoxIcon.Information)

    Catch ex As Exception
        MessageBox.Show("Record Not Updated! ", "Update Status", MessageBoxButtons.OK, MessageBoxIcon.Information)
    Finally
        dbClose()
        'refresh data grid
        fillgrid()
        'disable fields
        disControl()
    End Try
End Sub

viclim · Accepted Answer · 2013-04-01 06:49:07Z

1

You're missing this statement:

cmd.ExecuteNonQuery()

Add this statement after you've done adding all the parameters to your sqlCommand object.

answered Apr 1, 2013 at 6:49

viclim

9698 silver badges17 bronze badges

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

3 Comments

kinrubich Over a year ago

O_O OMG Thank you very Much! i've already spent 2 hours trying to figure out what's wrong. . LOL Still need to practice. . Still a newbie. . :)

viclim Over a year ago

You're welcome. Practice make perfect. Try to read some tutorial on codeproject.com

kinrubich Over a year ago

:) consequence of copy and pasting. . haha i missed the execute line. . I thought there's something wrong in the commandtext. .

Collectives™ on Stack Overflow

Cant't Update SQL Server Table in VB.NET

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related