Get Free Trial

Result of query not loading into component

Alberto Nudman asked on July 9, 2016

I am a newbie,
I have followed the instructions provided in
I have created an ASPX page (VisualizadosDatos.aspx) which queries the DB and returns the data through the compressor. If I paste the link into the browser, I see something like
“___ocsv2___2.215/2.213 +ejecutivo,+fecha_real_de_visita,+periodo_de_fecha_real_de_visita,+etapa,+unidad,+modelo,+tipologia,+medio Pablo Barria,16-04-2016 0:00:00,04-2016,Barrio Los Castaños Etapa 2,B,D-82 D,D,Referido ^0,10-04-2016 0:00:00,^0,Condominio Los Castaños %n%,C,C-74 C,C,Letrero ^0,^1,^0,^1,^1,^1,^1,^1 ^0,19-06-2016 0:00:00,06-2016,^0,^0,^0,^0,^1 ^0,18-05-2016 “
This shows the query contents are right. However, if I use the script and put filename: “localhost:/VisualizadorDatos” into the script, the component is shown but no data is displayed
Kindly help

4 answers

Alberto Nudman July 10, 2016

I added the following line to my script:
dataSourceType: ‘ocsv’
And now the grid loads the data… but most of the fields are empty. And the query IS returning the right data (if I run it in SQL Management Studio directly, I can see it)

Alberto Nudman July 10, 2016

Hi again….
I have figured out what happens, though I don’t know how to fix it. The OCSV loads fine, but with many empty rows. If I filter them, I can see the data correctly.
What should I do?

Alberto Nudman July 10, 2016

Finally I figured out how to deal with this. Only adding Response.End() in the last part solved it all
Final code looks like this
protected void Page_Load(object sender, EventArgs e)

        string resultado;

        string connectionString = “******”;
        SqlConnection sqlConnection = new SqlConnection(connectionString);
        string query = “SELECT * FROM TABLE”;
        DbCommand command = new SqlCommand(query, sqlConnection);
        DbDataReader reader = command.ExecuteReader();

        Stream inputStream = Flexmonster.Compressor.Compressor.CompressDb(reader);
        resultado = new StreamReader(inputStream).ReadToEnd();


Ian Sadovy Ian Sadovy Flexmonster July 11, 2016

Hello Alberto,
I am glad to hear that the issue is resolved.
Please do not hesitate to contact us if you have any further questions.

Please login or Register to Submit Answer