CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> .NET

 C# Custom SQL Statement Doesn't Work

Print topic Send  topic

Author Message
cobbler

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'";
NewDao.RunSql(Sql);

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
akhan


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

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

_________________
"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 http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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