Data Connector for .NET

Suite and Optimus Suite 5
#1

Can someone please provide me with documentation of the dhtmlxConnector for .net that spells out: Put these files in these places, reference these files in these places, modify this routine for your purpose.

You can use the download sample as an example if you’d like.

#2

Hi,
check this article
docs.dhtmlx.com/doku.php?id=dhtm … xconnector

in general, all you need to do to use connectors is add reference to connectors library(dhtmlxConnectors.dll) and create generic handler(ashx file), which will create connector instance to process requests from client side dhtmlx componets

e.g.
gridConnector.ashx:

<%@ WebHandler Language="C#" CodeBehind="gridConnector.ashx.cs" Class="dhtmlxConnector.Net_Samples.dhtmlxGrid.gridConnector" %>

gridConnector.ashx.cs:

using System;
using System.Web;
using System.Web.Services;
using dhtmlxConnectors;
using System.Configuration;

namespace dhtmlxConnector.Net_Samples.dhtmlxGrid
{ 
    public class gridConnector: dhtmlxRequestHandler
    {
        public override IdhtmlxConnector CreateConnector(HttpContext context)
        {
            dhtmlxGridConnector connector = new dhtmlxGridConnector(
                "SELECT ISO, PrintableName FROM Country",
                "UID",
                dhtmlxDatabaseAdapterType.SqlServer2005,
                ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
            );           
        }    
    }
}

on the clien-side you can use something like

mygrid = new dhtmlXGridObject(container_id);
...
mygrid.loadXML("gridConnector.ashx");
var dp = new dataProcessor("gridConnector.ashx");
dp.init(mygrid);

and that’s all you need to do to perform crud operations against single table, more complex cases will require additional configuration