SQL help

When trying to update a value in my database I get the error

No value given for one or more required parameters.

No value given for one or more required parameters.

however I heard this is common and usually means the SQL statement is wrong

Here is my SQL string

string _sSqlString = $"UPDATE Product SET SellPrice = {SellPrice} WHERE ProductName = {ProductName}";

databaseUtils.ExecuteSqlQuery(_sSqlString);

string _sSqlString = $"UPDATE Product SET SellPrice = {SellPrice} WHERE ProductName = {ProductName}";

databaseUtils.ExecuteSqlQuery(_sSqlString);

After inputting the variables into the Sql it looks like this

UPDATE Product SET SellPrice = 9 WHERE ProductName = apple

UPDATE Product SET SellPrice = 9 WHERE ProductName = apple

A picture of the database is attached

The ExecuteSqlQuery method works as intended, at least for all my other SQL requests, however they all use either DELETE, INSERT or SELECT

Thanks

C#•2y ago•

21 replies

Hazzza

SQL help

When trying to update a value in my database I get the error

No value given for one or more required parameters.

No value given for one or more required parameters.

however I heard this is common and usually means the SQL statement is wrong

Here is my SQL string

string _sSqlString = $"UPDATE Product SET SellPrice = {SellPrice} WHERE ProductName = {ProductName}";

databaseUtils.ExecuteSqlQuery(_sSqlString);

string _sSqlString = $"UPDATE Product SET SellPrice = {SellPrice} WHERE ProductName = {ProductName}";

databaseUtils.ExecuteSqlQuery(_sSqlString);

After inputting the variables into the Sql it looks like this

UPDATE Product SET SellPrice = 9 WHERE ProductName = apple

UPDATE Product SET SellPrice = 9 WHERE ProductName = apple

A picture of the database is attached

The ExecuteSqlQuery method works as intended, at least for all my other SQL requests, however they all use either DELETE, INSERT or SELECT

Thanks

SQL help

Similar Threads

SQL help

Similar Threads

Similar Threads

Similar Threads