We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
However, my Insert query keeps spitting out errors:
command.CommandText = "UPDATE [dbo].[Customers] SET [ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone WHERE (([ContactName] = @Original_ContactName) AND ([ContactTitle] = @Original_ContactTitle) AND ([PostalCode] = @Original_PostalCode) AND ([Country] = @Original_Country) AND ([Phone] = @Original_Phone))";
Can someone please help me correct my insert code?
command.CommandText = "INSERT INTO [dbo].[Customers](ContactName,ContactTitle,PostalCode,Country,Phone) VALUES ([ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone)";
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to get a Powershell script to launch from Visual Studio||20||63|
|Selecting only the rows where duplicates exist in specified columns within those rows||3||29|
|Nested forach loop to linq||3||24|
|Advice needed: I need to take data from a web application and transfer the data to word for report automation...||4||15|