Questions About A Blank DataGrid...

  • Thread starter Thread starter Frank Buchan
  • Start date Start date
F

Frank Buchan

This is an odd one.

I have an application (rather large) that has a page where data from a
single dataset binds to two controls. The one control is a Calendar control,
which binds to the dataset directly. The other control is a DataGrid, which
is bound to the same dataset, though it is filtered via a DataView. On five
development boxes everything works perfectly. The Calendar and List fill,
without even a single issue. Using the same database (SQL Server 2000) on a
live server, the T-SQL that populates the dataset works perfectly, and
without errors. The Calendar control fills without error. The DataGrid
throws no exceptions, but just remains blank. Code inserted to determine if
the dataset is somehow over-filtered shows that it is not. Looping the rows
of the DataView produces a list identical to what is expected. Again, no
errors. None. And, yet, the DataGrid is frustratingly blank...until one sets
the filter controls (also part of the page) and clicks the Filter button. At
that juncture, the List fills, and the DataGrid behaves as it does on every
other box this has been checked against.

The code works, and there are no errors thrown on any of the machines; all
SQL Server installs are identical; all databases are identical; all code is
identical. Does anyone have any idea what could cause this bizarre
behaviour -- which cannot be reproduced on any other machine, no matter how
hard we have tried.

Thanks for any insight.

Frank Buchan
 
What browser is being used on the problem machine? Have you loked at the
HTML source code? It sounds suspiciously like a Netscape issue with
incomplete table tags.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
Thanks, Kevin. I never thought to mention the browser.

The site on all five primary boxes we have tried to reproduce it on has
been tested against both IE and NS from version 4 onward. It works with
all those browsers, to one degree or another -- woth some expected
variances. No matter what browser is used to view the live version that
fails to render, the DataGrid simply remains blank.

You reminded me though about the Netscape rendering issue, and I think
my next attack on the issue will be to start comparing HTML source
output off the various boxes. It certainly doesn't seem to be a DataSet
issue, but I never even considered that it might somehow be a tag issue.
It's certainly a better longshot than the no shot I'm currently
managing. :)

I will post if I discover anything.

Thanks much for the insight.
 
It was just a guess, Frank, but thanks. Since it isn't an IE/Netscape issue,
I will be interested to hear what actually IS the cause of the problem. I'm
at a loss myself.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
Well, it wasn't HTML tag issues. The Grid is truly blank, despite being
constructed in memory (I checked that too). I will certainly post a
solution of some kind when I discover one.

C'est la vie. :)
 
Back
Top