title: I need to be able to insert values from textboxes into an access database ,but as of now its not working
body: <p>I am not being able to insert values from textboxes into the access database, Here's the code ,It shows the error "no value given for required parameters"</p>
  
  <pre><code> firstname = fname.Text
          middlename = mname.Text
          lastname = lname.Text
          address = addr.Text
          accountplan = accplan.SelectedItem
          accounttype = acctype.SelectedItem
          accountname = firstname + " " + middlename + " " + lastname
          Dim accessconn As New  _
  System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" &amp; "avalanche.mdb")
          Dim com As System.Data.OleDb.OleDbCommand
          Try
              accessconn.Open()
              MsgBox("Access succesfully connected")
              com = New System.Data.OleDb.OleDbCommand("INSERT INTO account(firstname,middlename,lastname) VALUES(firstname,middlename,lastname)", accessconn)
              com.ExecuteReader(CommandBehavior.CloseConnection)
              accessconn.Close()
              Return
          Catch ex As Exception
              accessconn.Close()
              MsgBox(ex.ToString)
              Return
          End Try
  </code></pre>