Passing parameters to gridview

[Mike P]

I am entering two dates into textboxes and using them as control
parameters in an SQL DataSource which is being used to populate a
gridview. I am using a custom validator to check if the data entered
into the text boxes are valid dates, but even when my code captures that
they are not valid dates it seems like it still tries to populate the
gridview and in doing so gives me the error 'Conversion failed when
converting datetime from character string'.

How can I prevent these parameters being passed to the gridview if they
are invalid?

 

[Guest]

Is enable client script set to true on your validator?

 

[Mike P]

No, EnableClientScript is not set to true.

 

[Rad [Visual C# MVP]]

I am entering two dates into textboxes and using them as control
parameters in an SQL DataSource which is being used to populate a
gridview. I am using a custom validator to check if the data entered
into the text boxes are valid dates, but even when my code captures that
they are not valid dates it seems like it still tries to populate the
gridview and in doing so gives me the error 'Conversion failed when
converting datetime from character string'.

How can I prevent these parameters being passed to the gridview if they
are invalid?

Rather than wrestling with date validation I suggest you get a good
JavaScript calendar implementation that will save you from the
headaches of validation of dates and internationalization data format
issues.

As for your problem maybe if you posted the code that processes the
dates we could be better placed to understand the error