| .NET DotNet Forum Index » Visual C# Forum » DateTime and Integer parameter field nulls... |
|
Page 1 of 1 |
|
| Author |
Message |
| Jim... |
 Posted: Thu Oct 29, 2009 8:58 pm |
|
|
|
Guest
|
On a windows form in C# I have a DataGridView populated from a tableAdapter
from a Microsoft Access Database table. When I add a query to the
DataGridView I get a toolStrip that allows me to enter parameters and execute
the query. The parameter fields are mainly strings with a dateTime field and
an integerfield. When I go to execute the query, I get message that says
“string not recognized as valid DateTime” when the DateTime parameter field
is left blank. I get a similar message when I use another query that
contains only strings and one integer field even when the integer field is
left blank. I guess I need to find the proper syntax for a null DataTime
field and the proper syntax for a null integer field. Any insight would be
welcomed.
Thanks in advance for your help,
Jim |
|
|
| Back to top |
|
|
|
|
