Update query for Access Database for certain Parameters
Posted
by nitinkhanna
on Stack Overflow
See other posts from Stack Overflow
or by nitinkhanna
Published on 2010-06-14T05:53:59Z
Indexed on
2010/06/14
7:22 UTC
Read the original article
Hit count: 275
Hi,
I am using MS Access as a database and using c#, .net for updating some records in it. But it is giving error saying
"No value given for one or more required parameters."
There are 5 colums in Table and I want to update only 2, for that I have written the query like
"update User_DTL set user_role_id = '" + _UserRole + "', auth_id ='" + _authId + "'"
+ " WHERE Id = '" + _Id + "' ";
where _UserRole, _authId, _Id are strings.
What may be the error. Do I need to give every parameter in update statement or there is some other way.
Thanks
© Stack Overflow or respective owner
