ASP.NET SQL UPDATE STATEMENT 1

[richfield]

Hi,

I have the following error in my sql satatement:

Incorrect syntax near the keyword 'where',

my code is;

strSql=strSql.format("Update tblSales where SalesId={0} values('{1}','{2}','(3)')",ddlSalesID.selecteditem.value,txtSales.text,txtDate.text,txtEmployeeId.text)

Is there an obvious error?

Cheers Rich

 

[ca8msm]

Yes - you haven't told it which atble to update!

The syntax for an update statement should be:

UPDATE MYTABLE SET MYFIELD = 'A' WHERE MYCRITERIA = 'B'

It will also read the whole sql statement actually as a string so the statement passed to the db would actually by:

Update tblSales where SalesId={0} values('{1}','{2}','(3)')

If you need to add items to a string then you need to break out of the quotation marks.

Simple example:

strSQL = "UPDATE MYTABLE SET MYFIELD = '" & MyTextBox.Text & "' WHERE MYCRITERIA = '" & MyDropDownList.SelectedItem.Value & "'"

Hope this helps.


----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.