Sql Command Error with where condition

Question

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

Nitin Sontakke · Answer

If issue is resolved, please accept one of the answers and close the thread formally.

James Axsom · Answer

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 Arangodan · Answer

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

sandeep kumar · Answer

Hi James & Abeed Thanks for the Answer. Thank You Sandeep

Sql Command Error with where condition

Answers (4)