Cannot retrieve data with dhtmlxgrid connector

Suite and Optimus Suite 5
#1

Hi,

I am new to dhtmlx world and I am still doing some tests.
First of all, I would like to make an easy query against database but for the moment I am not able to do it. I am using .net connector.
This is my code

[code]

DHTMLX html, body { width: 100%; height: 100%; margin: 0px; overflow: hidden; background-color:white; } var dhxGrid, myDataProcessor; dhtmlxEvent(window, "load", function () { dhxGrid = new dhtmlXGridObject("mygrid_container"); dhxGrid.setHeader("Column"); dhxGrid.init(); dhxGrid.loadXML("gridConnector.ashx"); 
        myDataProcessor = new dataProcessor("gridConnector.ashx");
        myDataProcessor.init(dhxGrid);
    });
</script>
[/code]

And this is gridConnector.ashx page code:

Imports System.Web
Imports System.Web.Services
Imports dhtmlxConnectors
Imports System.Linq

Public Class gridConnector
    Inherits dhtmlxRequestHandler

    Public Overrides Function CreateConnector(context As HttpContext) As IdhtmlxConnector
        Dim conector As New dhtmlxGridConnector(
            "Issues",
            "Id_user",
            "Id",
            dhtmlxDatabaseAdapterType.SqlServer2005,
            ConfigurationManager.ConnectionStrings("Database").ConnectionString
            )
        Return conector
    End Function

End Class

And finally my connection string is this line:

  <connectionStrings>
    <add name="Database" connectionString="Data Source=Issues;Initial Catalog=IssuesTable;Persist Security Info=True;User ID=id;Password=password"/>
 </connectionStrings>

Is there anything I am doing wrong?

Thank you in advance.

#2

Hi,
can you show the http response of connector ashx handler?