Creating a SQLCommand for use in a SQLDataAdapter

Question

I am trying to delete data from a table using a SQLDataAdapter, and to do so I need to give it a DeleteCommand.

The SQL I would use to delete a row is:

DELETE FROM table WHERE ID = x

The problem is thus: How do I specify to the DataAdapter what to replace x with? The SQL to generate the DataAdapter is slightly different (no joins) than the data table it's being told to update (an outer join).

How can I do this?

Canavar · Accepted Answer · 2009-03-04 20:11:14Z

4

Here you can pass parameter to delete command :

// Create the DeleteCommand.
command = new SqlCommand(
    "DELETE FROM Customers WHERE CustomerID = @CustomerID", connection);

// Add the parameters for the DeleteCommand.
parameter = command.Parameters.Add(
      "@CustomerID", SqlDbType.NChar, 5, "CustomerID");
parameter.SourceVersion = DataRowVersion.Original;

adapter.DeleteCommand = command;

The code taken from MSDN

answered Mar 4, 2009 at 20:11

Canavar

48.1k17 gold badges94 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Malfist Over a year ago

Do I need to check for SQL Injection with this?

Canavar Over a year ago

No you don't, you're passing inputs as parameters.

albertein · Accepted Answer · 2009-03-04 20:10:47Z

1

use SourceColumn and SourceVersion SqlParameter properties:

        var deleteCommand = connection.CreateCommand();
        deleteCommand = "DELETE FROM table WHERE ID = @ID";
        var param = new SqlParameter("ID");
        param.SourceColumn = "the Select Column";
        param.SourceVersion = DataRowVersion.Original;
        deleteCommand.Parameters.Add (param);

answered Mar 4, 2009 at 20:10

albertein

27.3k5 gold badges57 silver badges57 bronze badges

2 Comments

Malfist Over a year ago

Can you explain what the SourceVersion is?

albertein Over a year ago

SourceVersion indicates which value would be used, Original is the original value that you get with the select query, Current is the current value of the field, like if you modified it.

Collectives™ on Stack Overflow

Creating a SQLCommand for use in a SQLDataAdapter

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related