Complex SQL data source for Grid Connector .NET version

Suite and Optimus Suite 5
#1

HI,

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.

Thanks.

#2

Hello,
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 );