System.InvalidOperationException: System.Data.OleDb.OleDbDataAdapter internal error: invalid parameter accessor: 6 BADBINDINFO.
I do not have a clue what thsi error means, all states that theres something wrong with myCmd.ExecuteNonQuery ( );
Will apprechiate anyone help.
Thanks, Mac
public
void addMessage ( object src, EventArgs e ) { if ( Page.IsValid ) { OleDbCommand myCmd = new OleDbCommand ( );myCmd.Connection =
new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath("aspa_oledb.mdb")); // define insert command parametersmyCmd.CommandText =
"INSERT INTO aspx_messages ( MessageDate, MessageFrom, Email, MessageSubject, MessageBody ) VALUES ( ?, ?, ?, ?, ? ) SET ? = @@Identity";myCmd.Parameters.Add (
"Date", OleDbType.Date ).Value = DateTime.Now;myCmd.Parameters.Add (
"From", OleDbType.Char ).Value = msgFrom.Value;myCmd.Parameters.Add (
"Mail", OleDbType.Char ).Value = msgEmail.Value;myCmd.Parameters.Add (
"Subject", OleDbType.Char ).Value = msgSubject.Value;myCmd.Parameters.Add (
"Body", OleDbType.VarChar ).Value = msgBody.Value; // used for getting new record IDmyCmd.Parameters.Add (
"Id", OleDbType.SmallInt );myCmd.Parameters [
"Id" ].Direction = ParameterDirection.Output;myCmd.Connection.Open ( );
// do insertmyCmd.ExecuteNonQuery ( );
// fetch new record into readermyCmd.CommandText =
"SELECT * FROM aspx_messages WHERE MessageId=" +myCmd.Parameters [
"Id" ].Value;postDetails.DataSource = myCmd.ExecuteReader (
CommandBehavior.SingleRow );postDetails.DataBind ( );
myCmd.Connection.Close ( );
}
}
Simeon ParvanovPosted Jan 29, 2011, 4:53 PM
you try to use output parameter with MS Access
myCmd.Parameters [ "Id" ].Direction = ParameterDirection.Output;