sending form data to database creates a error!
hi i have created a form which should connect to a database and update it when the user inputs into the form, however as soon as i hit the button on the form i get the error No value given for one or more required parameters., I have checked the table names are all correct and cant figure out why it does this can anyone help??
//Build connection object //
OleDbConnection conn = new OleDbConnection() ;
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;";
connStr += "Data Source= " + Server.MapPath("test.mdb");
conn.ConnectionString = connStr;
// Build command object //
queryString = "Insert INTO Customer(C_FirstName, C_LastName) VALUES(";
queryString += fn.Text + "," + "'" + sn.Text + "')";
OleDbCommand dbCommand = new OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = conn;
// Open the connection //
// insert new record using method executeNonQry
} // end of if
} // end of page_load
the error i recieve is as follows:
No value given for one or more required parameters.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.
Line 33: // insert new record using method executeNonQry
Line 34: dbCommand.ExecuteNonQuery();