Random datagrid issues

[David]

Hi all,

This is a weird one.

I have been asked to look at an intermittent fault.

Basically, I have a webservice that is delivering info into a datagrid.

Dim Statement As New my_service.Statement
Dim my_data As New my_service.my_data
Statement = my_data.FullStatement(AccNo, StartDate)
dgridStatement.DataSource = Statement.StatmentEntries
dgridStatement.DataBind()

From what I see here, Statement is on the webservice, so
my_data.FullStatement is calling the webservice, to push it back to the
webservice, then bring brought down again from the webservice for the
datasource of the datagrid.

I have simplified it, but not sure if it has the same effect... basically,
statement is now a local dataset, which is now
my_data.FullStatement(...).StatmentEntries then bind just statement to the
datagrid.


The problem I am having (prior to the change, don't know if it happens after
the change yet) is that randomly, the data in the datagrid is doubling for
each row. It doesn't happen often, but it does happen.


There could potentially be 3 points (that I see) where it is happening.
1. On the database. Highly unlikely in my opinion. (The DB is using a stored
proc calling a view, which comes from 3 tables, so a possibility that it
could be from here)
2. The backwards and forwards of the data in the code snippet above.
3. a problem with the datagrid.


I had probs with the datagrid on another unrelated project where the
databind was running twice, so this is why I won't discount this.

Has anyone come up against a similar issue. This is REALLY puzzling me.

--
Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available

 

[David]

Hi Patrice,

Thanks for the response. I am not sure at the moment (I have been moved onto
another project, but I will be sure to have a look).

What would you suggest should be there? (should it be static / shared?)

The main problem I have is that I am effectively working blind. I didn't
write the system initially, and I can't really test it as it is on a client
site and I don't have an account to log into their system. On top of that,
my test rig won't run because the directory has ASP.NET authentication on
it, so even though I put my test code in place, I am still being asked to
sign-in.

This is one of those frustrating projects. :-(

--
Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available