CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> .NET

 C# Custom SQL Statement Doesn't Work

Print topic Send  topic

Author Message

Posts: 2
Posted: 02/10/2009, 11:37 AM

I have been trying to add a Custom SQL statement to 'After Execute Select' of a record using CodeCharge Studio 4.1.

The idea is that the user selects a 'completed' checkbox which will then update a date-time stamp field indicating when the record was completed.

The code I am trying is:

System.Web.HttpContext context=System.Web.HttpContext.Current;
DataAccessObject NewDao=Settings.Connection1DataAccessObject;
string Sql = "UPDATE tasks SET completion_time = NOW() WHERE completed = 0 AND completion_time = '0000-00-00 00:00:00'";

This results in a "The type or namespace name 'DataAccessObject' could not be found " error message.

Is there a reference that I need to add? The help file doesn't mention anything about adding a reference.
Cobbling together technologies to make it useful.
View profile  Send private message

Posts: 38
Posted: 02/16/2009, 3:11 AM

Dim update_completed As New SqlCommand("UPDATE tasks ....." , Settings.Connection1DataAccessObject)  

"Simplicity is the key to brilliance” (bruce lee)
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by  and YesSoftware, Inc.