inserting web form data into ms-access using asp.net

Question

I am trying to take data from a web form and place it in an ms-access database. The code which is in the aspx.vb page (to date) is listed below but when I run it the cmd.ExecuteNonQuery() throws up

"No value given for one or more required parameters."

Why is this? What should the code read?

  Protected Sub RegButton_Click(sender As Object, e As EventArgs) Handles RegButton.Click
    Dim con As New OleDb.OleDbConnection
    Dim cmd As New OleDb.OleDbCommand
    Dim Sql As String

    con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Users.accdb;Persist Security Info=True"

    con.Open()

    Sql = "INSERT INTO Users.Personnel (FirstName, LastName, Address, Email, Username, UserPassword) VALUES (@first, @last, @addr, @email, @uname, @pwd) "
    cmd = New OleDb.OleDbCommand(Sql, con)
    cmd.ExecuteNonQuery()
    MsgBox("saved")

    cmd.Parameters.AddWithValue("@first", FirstBox.Text)
    cmd.Parameters.AddWithValue("@last", LastBox.Text)
    cmd.Parameters.AddWithValue("@addr", AddressBox.Text)
    cmd.Parameters.AddWithValue("@email", EmailBox.Text)
    cmd.Parameters.AddWithValue("@uname", UserBox.Text)
    cmd.Parameters.AddWithValue("@pwd", PwdBox.Text)

    con.Close()

End Sub

Amit Yadav · Accepted Answer · 2017-02-17 09:35:09Z

1

you can not execute query before passing parameters try this.

con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Users.accdb;Persist Security Info=True"

con.Open()

Sql = "INSERT INTO Users.Personnel (FirstName, LastName, Address, Email, Username, UserPassword) VALUES (@first, @last, @addr, @email, @uname, @pwd) "
cmd = New OleDb.OleDbCommand(Sql, con)


cmd.Parameters.AddWithValue("@first", FirstBox.Text)
cmd.Parameters.AddWithValue("@last", LastBox.Text)
cmd.Parameters.AddWithValue("@addr", AddressBox.Text)
cmd.Parameters.AddWithValue("@email", EmailBox.Text)
cmd.Parameters.AddWithValue("@uname", UserBox.Text)
cmd.Parameters.AddWithValue("@pwd", PwdBox.Text)
cmd.ExecuteNonQuery()
MsgBox("saved")
con.Close()

End Sub

answered Feb 17, 2017 at 9:35

Amit Yadav

4813 silver badges11 bronze badges

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

1 Comment

Be Alert Over a year ago

Thanks Amit. A simple solution which makes me feel simple for not spotting it!!

Collectives™ on Stack Overflow

inserting web form data into ms-access using asp.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related