Should we escape ' when building command text? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Should we escape ' when building command text?

Message

From

31/12/2007 14:37:03

John Baird
Coatesville, Pennsylvania, United States

To

31/12/2007 14:24:12

Naomi Nosonovsky
Wisconsin, United States

General information

Forum:

ASP.NET

Category:

Databases

Title:

Re: Should we escape ' when building command text?

Environment versions

Environment:

ASP.NET

OS:

Windows XP

Database:

MS SQL Server

Miscellaneous

Thread ID:

01278630

Message ID:

01278714

Views:

22

>Do you know what should I change here?
>
>If I would be able to fix this problem, I'll later re-write the method using your idea.

According to help, the BeginExecuteNonQuery: Initiates the asynchronous execution of the Transact-SQL statement or stored procedure that is described by this SqlCommand.

I would change it to ExecNonQuery and try that...

Click here to load this message in the networking platform