VB.NET - ASP.NET - MS-Access - SQL Statement

Posted by Brian on Stack Overflow See other posts from Stack Overflow or by Brian
Published on 2012-03-29T15:30:45Z Indexed on 2012/03/29 17:30 UTC
Read the original article Hit count: 302

Filed under:
|
|
|

I have a button which when pressed, sets the user's rights in the db. (If Administrator UserTypeID is set to '2' and if Customer it is set to '1'). However when I run the below code, everything remains the same. I think it's from the SQL statement but I;m not sure. Can anyone help please?

Protected Sub btnSetUser_Click(sender As Object, e As System.EventArgs) Handles btnSetUser.Click

    Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Brian\Documents\Visual Studio 2010\WebSites\WebSite3\db.mdb;")

    Dim cmd As OleDbCommand = New OleDbCommand("UPDATE [User] SET [UserTypeID] WHERE Username=?", conn)

    conn.Open()
    cmd.Parameters.AddWithValue("@Username", txtUser.Text)

    If ddUserType.SelectedItem.Text = "Administrator" Then

        cmd.Parameters.AddWithValue("@UserTypeID", "2")
        cmd.ExecuteNonQuery()
        lblSetUser.Text = txtUser.Text + "was set to Administrator."

    ElseIf ddUserType.SelectedItem.Text = "Customer" Then

        cmd.Parameters.AddWithValue("@UserTypeID", "1")
        cmd.ExecuteNonQuery()
        lblSetUser.Text = txtUser.Text + "was set to Customer."

    End If

    conn.Close()


End Sub

End Class

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql