Complex SQL data source for Grid Connector .NET version


Could I set Complex SQL data source for Grid connectors?
I find out that there exists render_complex_sql to handle the scenario but not for .NET version.

Any suggestions?
I just want to use “NOT IN” Statement where cross over two tables.


just pass ‘true’ as the last parameter of dhtmlxGridConnector’s constructor dhtmlxGridConnector connector = new dhtmlxGridConnector( "SELECT ...", "id", dhtmlxDatabaseAdapterType.SqlServer2005, ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString, true//for complex sql );