Sql Command Error with where condition

sandeep kumar

I tried using the below sqlcommand statement throwing error at where condition. What's wrong with the statement. Can any one help me please.

SqlCommand sqlcmd = new SqlCommand("insert into Database1(ProdcutReleaseDate) values('"+DateTime.Now+"') where [property address]='" + ComboBox1.SelectedValue+"'", sqlcon);

Thanks

sandeep

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Accepted answer
If issue is resolved, please accept one of the answers and close the thread formally.
sandeep kumar8y ago
Hi James & Abeed

Thanks for the Answer.

Thank You
Sandeep
James Axsom8y ago
Hi Sandeep,

If you would like to insert rows into a table via a filter, the INSERT INTO SELECT clause is available to you. Here’s how it works:

INSERT INTO
X (X.COL1, X.COL2, X.COL3)
SELECT (Y.COL1, Y.COL2, Y.COL3)
FROM

Y
WHERE Y.COL=@Value

Its great for copying data from one table to another. The main thing is that your columns share the same data type and relative size. Matching columns names are good but not required.

Columns (if any) not populated in the insert table get null values.

Hope this helps.
Adeeb Arangodan8y ago
INSERT command is used for inserting a new entry (data or row) into a table. If you want to update an already existing entry (row) you can use UPDATE command.

UPDATE
SET =
WHERE