Thread: automatic alert message by detecting sql command
View Single Post
  #2 (permalink)  
Old May 14th, 2014, 06:22 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default
Hi there,

You're never executing your SQL command or deal with the results. All you do is declare the command, but the SQL statement will never be fired against the database.

Take a look at this tutorial to see how to execute the command, and deal with its return value: http://www.csharp-station.com/Tutori...otNet/lesson03

Cheers.

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
 and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote