dhtmlxFormConnector returns all data not just ID sent in GET

Suite and Optimus Suite 5
#1

I’m using this code to create my dhtmlxFormConnector

  dhtmlxFormConnector connector = new dhtmlxFormConnector(
                "Tbl_table",
                "Col1,Col2, Col3, Col4, Col5,Col6,Col7,Col8",
                "ID",
                dhtmlxDatabaseAdapterType.SqlServer2005,
                ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
            );
            return connector;

machine/demo/Form.ashx?ID=11

It returns all the data…

I’ve tried adding a filter like this

  dhtmlxFormConnector connector = new dhtmlxFormConnector(
                "Tbl_table",
                "Col1,Col2, Col3, Col4, Col5,Col6,Col7,Col8",
                "ID",
                dhtmlxDatabaseAdapterType.SqlServer2005,
                ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
            );
            if (context.Request.QueryString["id"] != null)
                connector.Request.Rules.Add(new FieldRule("ID", Operator.Equals, context.Request.QueryString["id"]));
            return connector;

This hasn’t worked either… Is there something else we’re supposed to do for this to work with the FormConnector - I’m following the Contact Manager tutorial btw.

Thanks,
Matt

#2

please ignore - I had copied some code and forgotten to change the class used in the ashx… :slight_smile: