Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Andy on Aug 13, 2009 02:06
open dhtmlx forum
store procedure in connector(ASP.Net Edition)

Hi.
A few days ago, dhtmlx connector was released.
Can I use store procedure?
I couldn't find how to use store procedure in the manual.

Thanks for reading.
Answer posted by Pasha on Aug 13, 2009 03:47
If you're going to use stored procedures for insert/update/delete, you may replace standard SQLs for those operations you're going to use with your own (e.g. stored procedure call). There's sample dhtmlxGrid/04_custom_sql.aspx that uses this feature:
connector.Request.CustomSQLs.Add(CustomSQLType.Delete, "UPDATE Country SET PrintableName = '-------------' WHERE UID={UID}");
If we're talking about select operation, then no, dhtmlx connector has no support for them. You can use table functions instead of tables, but not procedures.