Delete from two tables? [closed]

by

Use parameters and DO NOT concatenate values into your SQL, Try something like…..

protected void btnRemove(object sender, EventArgs e)
{
    conn.Open();

    SqlCommand cmd = new SqlCommand("delete from Car where CarID= @CarID", conn);
    cmd.Parameters.AddWithValue("@CarID", lstCar.SelectedValue);

    SqlCommand cmd1 = new SqlCommand("delete from Orders where OrderID= @OrderID" , conn);
    cmd1.Parameters.AddWithValue("@OrderID", lstOrders.SelectedValue);

    cmd.ExecuteNonQuery();
    cmd1.ExecuteNonQuery();

    conn.Close();
}

More Related Contents:

  1. How can I round a value in SQL
  2. How do I update a value in C# and SQL Server? [closed]
  3. SQL Server Char/VarChar DateTime Error [closed]
  4. How to get last inserted id?
  5. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  6. Execute Insert command and return inserted Id in Sql
  7. Adding multiple parameterized variables to a database in c#
  8. Insert entire DataTable into database at once instead of row by row?
  9. Getting return value from stored procedure in C#
  10. SQL error: Incorrect syntax near the keyword ‘User’
  11. What represents a double in sql server?
  12. Passing List to SQL Stored Procedure
  13. SQL WHERE clause matching values with trailing spaces
  14. How to retrieve data from a SQL Server database in C#?
  15. SqlBulkCopy from a List
  16. Any way to SQLBulkCopy “insert or update if exists”?
  17. Multi threading C# application with SQL Server database calls
  18. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  19. SqlConnection.Close() inside using statement
  20. Generate class from database table
  21. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  22. What is passing parameters to SQL and why do I need it?
  23. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  24. Add WHERE clauses to SQL dynamically / programmatically
  25. How to pass string array in SQL parameter to IN clause in SQL
  26. Query validation using C#
  27. Use SQL Server time datatype in C#.NET application?
  28. Generating sql code programmatically
  29. How to give ADO.NET Parameters
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment