SQL update statement in C#

by

This is not a correct method of updating record in SQL:

command.CommandText = "UPDATE Student(LastName, FirstName, Address, City) VALUES (@ln, @fn, @add, @cit) WHERE LastName="" + lastName + "" AND FirstName="" + firstName+""";

You should write it like this:

command.CommandText = "UPDATE Student 
SET Address = @add, City = @cit Where FirstName = @fn and LastName = @add";

Then you add the parameters same as you added them for the insert operation.

More Related Contents:

  1. Automated checking of database connection and query in same database [closed]
  2. Execute non-query error [closed]
  3. How do I clean SqlDependency from SQL Server memory?
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. How to retrieve data from a SQL Server database in C#?
  6. Wildcard search for LINQ
  7. Map category parent id self referencing table structure to EF Core entity
  8. Get an IDataReader from a typed List
  9. Does using parameterized SqlCommand make my program immune to SQL injection?
  10. Any way to SQLBulkCopy “insert or update if exists”?
  11. Multi threading C# application with SQL Server database calls
  12. EF 6 Parameter Sniffing
  13. Use linq to generate direct update without select
  14. encrypt SQL connectionstring c#
  15. Table name and table field on SqlParameter C#?
  16. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  17. How to make LINQ execute a (SQL) LIKE range search
  18. Sql Bulk Copy/Insert in C#
  19. Calling SQL Defined function in C#
  20. Checking for empty or null JToken in a JObject
  21. SQL/C# – Best method for executing a query
  22. Index (zero based) must be greater than or equal to zero
  23. Issues Doing a String Comparison in LINQ
  24. Convert SQL to LINQ Query [closed]
  25. Must declare the table variable @table
  26. C# SQL insert command
  27. Stored procedure returns int instead of result set
  28. How to use String property as primary key in Entity Framework
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment