DeleteCommand

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 17 Sep 2005 19:27 GMT

Hello,

How can I use the DeleteCommand to delete a record where the delete statment
takes a CustomerID as a parameter (CustomerID is the variable that holds
Customer ID taken from a TextBox)

Thanks

Signature

Regads,
Rochdi

Reply to this Message

Herfried K. Wagner [MVP] - 17 Sep 2005 22:03 GMT

"John" <John@discussions.microsoft.com> schrieb:

> How can I use the DeleteCommand to delete a record where the delete
> statment
> takes a CustomerID as a parameter (CustomerID is the variable that holds
> Customer ID taken from a TextBox)

Sample (look for "DELETE FROM"):

.NET Framework Class Library -- 'SqlDataAdapter' Constructor ('SqlCommand')
<URL:http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlDa
taAdapterClassctorTopic2.asp>

Note that this sample shows how to use a parameterized command. This
approach is recommended over building up the whole command string by hand
because it protects from SQL injection.

Signature

M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...