Access DB Update Problem-

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

string updateSQL;
updateSQL = "UPDATE TestDetails SET AnsweredWordID =
:AnsweredWordID WHERE RID=:RID";
OleDbCommand command = new OleDbCommand();
command.CommandText = updateSQL;



OleDbParameter param1 = new OleDbParameter(":AnsweredWordID",
OleDbType.Integer, 0, "AnsweredWordID");
command.Parameters.Add(param1);

OleDbParameter param2 = new OleDbParameter(":RID",
OleDbType.Integer);
param2.SourceVersion = DataRowVersion.Current;
param2.SourceColumn = "RID";
command.Parameters.Add(param2);

m_DataTableTestDetails.Rows[m_Position]["AnsweredWordID"] = 99;

OleDbDataAdapter adapter = new OleDbDataAdapter();
OpenConnection();

adapter.UpdateCommand = command;
adapter.UpdateCommand.Connection = m_Connection;

adapter.Update(m_DataTableTestDetails);
CloseConnection();

There is an exception when
adapter.Update(m_DataTableTestDetails); line. The exception is ":RID No value
given for one or more required parameters".
I need help pls. Thanks alot.
 
string updateSQL;
updateSQL = "UPDATE TestDetails SET AnsweredWordID =
:AnsweredWordID WHERE RID=:RID";
OleDbCommand command = new OleDbCommand();
command.CommandText = updateSQL;



OleDbParameter param1 = new OleDbParameter(":AnsweredWordID",
OleDbType.Integer, 0, "AnsweredWordID");
command.Parameters.Add(param1);

OleDbParameter param2 = new OleDbParameter(":RID",
OleDbType.Integer);
param2.SourceVersion = DataRowVersion.Current;
param2.SourceColumn = "RID";
command.Parameters.Add(param2);

m_DataTableTestDetails.Rows[m_Position]["AnsweredWordID"] = 99;

OleDbDataAdapter adapter = new OleDbDataAdapter();
OpenConnection();

adapter.UpdateCommand = command;
adapter.UpdateCommand.Connection = m_Connection;

adapter.Update(m_DataTableTestDetails);
CloseConnection();

There is an exception when
adapter.Update(m_DataTableTestDetails); line. The exception is ":RID No value
given for one or more required parameters".
I need help pls. Thanks alot.
Click to expand...

Your problem is that you added a parameter for the column you are updating. You
do not need the parameter ":AnsweredWordID"
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
 
Hi Otis,
I see you. But my code just a bit sample. The value is 99 not use like a
constant.
You think it as a variable. For example:

m_DataTableTestDetails.Rows[m_Position]["AnsweredWordID"] = answeredID;

Thakns


Otis Mukinfus said:
string updateSQL;
updateSQL = "UPDATE TestDetails SET AnsweredWordID =
:AnsweredWordID WHERE RID=:RID";
OleDbCommand command = new OleDbCommand();
command.CommandText = updateSQL;



OleDbParameter param1 = new OleDbParameter(":AnsweredWordID",
OleDbType.Integer, 0, "AnsweredWordID");
command.Parameters.Add(param1);

OleDbParameter param2 = new OleDbParameter(":RID",
OleDbType.Integer);
param2.SourceVersion = DataRowVersion.Current;
param2.SourceColumn = "RID";
command.Parameters.Add(param2);

m_DataTableTestDetails.Rows[m_Position]["AnsweredWordID"] =
99;

OleDbDataAdapter adapter = new OleDbDataAdapter();
OpenConnection();

adapter.UpdateCommand = command;
adapter.UpdateCommand.Connection = m_Connection;

adapter.Update(m_DataTableTestDetails);
CloseConnection();

There is an exception when
adapter.Update(m_DataTableTestDetails); line. The exception is ":RID No
value
given for one or more required parameters".
I need help pls. Thanks alot.
Click to expand...

Your problem is that you added a parameter for the column you are
updating. You
do not need the parameter ":AnsweredWordID"
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
Click to expand...
 
Back
Top