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