Please help me in aspdotnet

[abglorie]

Please can you help me, for the following problem solving I want update the string value. The string value is "Women's Studies" Now I am using UPDATE command like Dim MyText as TextBox MyBox = "Women's Studies" MySql = "UPDATE MyTable SET Title='" & MyText & "' Where Title='Womens Studies'" The programme running time display the error message as Incorrect syntax near 'S'. Unclosed quotation mark before the character string How to rectify in above problem? Now I am using Asp.net with VB, and SQL Server Please Help me Thanking you in advance abglorie abglorie

[Pankaj Garg]

Replace single quote to double quotes.

[Abhijit Jana]

abglorie wrote:

MySql = "UPDATE MyTable SET Title='" & MyText & "' Where Title='Womens Studies'"

Check this line.... you will get your soln.. ;)

Best Regards ----------------- Abhijit Jana View My Latest Article :- SpyNet : Your Network Spy "Success is Journey it's not a destination"

[N a v a n e e t h]

abglorie wrote:

MySql = "UPDATE MyTable SET Title='" & MyText & "' Where Title='Womens Studies'"

Use parameterized query. Read about SQL injection attacks.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions