Check documentation for the latest version 6.0 of dhtmlxSuite Other Database Types DHTMLX Docs

Other Database Types

You can make the connector work with other database types using ODBC. Just pass the dhtmlxDatabaseAdapterType.ODBC adapter to object constructor.

dhtmlxGridConnector connector = new dhtmlxGridConnector(
    "Country",
    "ISO, PrintableName",
    "UID",
    dhtmlxDatabaseAdapterType.ODBC, 
    ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString,
    "(SELECT count(ISO) from Country)"
);

And modify the connection string in the web.config of your application, e.g. for MySql connection the string will look like this:

<add name="SamplesDatabase" connectionString="DRIVER= {MySQL ODBC 3.51 Driver};
SERVER=SERVERNAME;uid=root;PASSWORD=;DATABASE=dhtmlx;" providerName="System.Data.Odbc"/>
Back to top