Categories | Question details Back To List | ||
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. |