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??

void Page_Load()
{

if(IsPostBack)
{
//Build connection object //
OleDbConnection conn = new OleDbConnection() ;
string connStr;
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;";
connStr += "Data Source= " + Server.MapPath("test.mdb");
conn.ConnectionString = connStr;

// Build command object //

string queryString;
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 //
conn.Open();


// insert new record using method executeNonQry
dbCommand.ExecuteNonQuery();


} // 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.

Source Error:

Line 32:
Line 33: // insert new record using method executeNonQry
Line 34: dbCommand.ExecuteNonQuery();
Line 35:
Line 36:

Hmmm, well I used your code and it worked for me?

Have you put break points in and seen what values are being passed?

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??

void Page_Load()
{

if(IsPostBack)
{
//Build connection object //
OleDbConnection conn = new OleDbConnection() ;
string connStr;
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;";
connStr += "Data Source= " + Server.MapPath("test.mdb");
conn.ConnectionString = connStr;

// Build command object //

string queryString;
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 //
conn.Open();


// insert new record using method executeNonQry
dbCommand.ExecuteNonQuery();


} // 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.

Source Error:

Line 32:
Line 33: // insert new record using method executeNonQry
Line 34: dbCommand.ExecuteNonQuery();
Line 35:
Line 36:

This article has been dead for over six months. Start a new discussion instead.