We have an ASPnet 1.1/1.0 project, coding a Sub BindDataGrid( ) for a GridView control.
Here we declared a SQL statement to fill a dataset. The query string contained a WHERE statemet
to display the GridView when the ApptsTime >= strApptPreTime.

(A.ApptsDate > '" & strApptPreDate & "' OR (A.ApptsDate = '" & strApptPreDate & "' AND A.ApptsTime >= '" & strApptPreTime & "' ))" & _

Somehow, we can display GridView only after 10 am, even the 8/9 am data have been created and shown in the SQL Server database.
Tried to debug the Sub BindDataGrid( ), but can set up breakpoints only. After started debugging to create Watch, Auto, or Local windows,
 the 'step in' is deactivated and variavles can not be moved to Watch/Auto/Local windows.

Wondering how to debug a query string in a Sub BindDataGrid( )?


TIA,
Jeffrey

__________________
C. Jeffrey Wang

It works very well now. However, I can see the values for strApptPreDate, strApptPreTime, etc but not the A.ApptsTime. On the Watch 1 window, the Value column displayed:
 ' A.ApptsTime' is not declared or the module containg it is not loaded.'

The Locals window showed all kind of data, e.g. dApptCalcNewDate= #1/25/2008 10:05:09 AM#; and strApptPreTime="10:05". Again,
I just can not see the values for ApptsTime. Tried Immediate windows, typing ? A.ApptsTime, showed the same error as Watch 1 window.

How can I view the A.ApptsTime from the SQL Server database?

Thanks,
Jeffrey

You can't debug SQL server data directly from visual studio the way you are trying to. There are ways to debug stored procedures but I haven't done it. Furthermore, you're trying to look at a column value. There are many rows in the table so aren't going to be able to see (if it were possible) the value of the row being evaluated by the sql query.

You stated "The query string contained a WHERE statemet". It is very highly advised NOT to do this. This technique is basically asking for trouble. It is very easy to perform SQL injection attacks and trash your database or expose data you don't want exposed. You should really use SQL command objects with parameters. This greatly reduces the risk.

-Peter

Is there any way I can debug or trace when or how the
BindDataGrid( ) runs before 9 am? Why BindDataGrid or GridView
does not run when AppsTime > strAppsPreTime?

Jeffrey

Perhaps it's just me, but this discussion is confusing me.

Are you having problems the software at a specific time of day?
Is the problem related to date/time data you are expecting to get back but aren't?

Please provide more detail. A summary of what you are trying to achieve would be helpful. Also some code? But PLEASE only post the relevant code. I.e. post your BindDataGrid() method (trim out what isn't relevant to this question if necessary). Please also post other code that is directly relevant to the behavior of BindDataGrid().

-Peter

Okay, here is a half-time summary.

1. Problem Statement
   Before 9 am, I can see the new, 9 am data in SQL Server database table, but no GridView presentation. At 9:06 am, I can see the old 9 am and the new 10 am data in SQL Server database table, but only 10 am data on the GridView Statement. The 9 am data were skipped. After 10 am, the GridView works just fine for the new data.

2. Debugging query string of the BindDataGrid( ) for the GridView
   To find out why no BindDatGrid( ) for 9 am data, I debugged the query string. On Watch/Local/Immediate windows, I can see the values from Server time, but not the query time data from the SQL Server database. Therefore, I still have no answer why no BindDataGrid( ) before 9 am.

3. BindDataGrid( ) 9 am data is my original question, while debugging the SQL Server query string is the new question.

Thanks,
Jeffrey