Delete Date

[BD]

Developing C# windows forms application in Visual Studio 2005 to
access SQL Server 2005 on remote server. On one form I have a textbox
to enter short date. If I delete the date in the textbox, it does not
validate and therefore will not update the server. I know I should
enter null value but have been unsuccessful.

[Mick Walker]

BD wrote:

Developing C# windows forms application in Visual Studio 2005 to
access SQL Server 2005 on remote server. On one form I have a textbox
to enter short date. If I delete the date in the textbox, it does not
validate and therefore will not update the server. I know I should
enter null value but have been unsuccessful.

Can you post your insert statement?

[BD]

On Aug 17, 8:34 am, Mick Walker <[e-mail]:

BD wrote:

Developing C# windows forms application in Visual Studio 2005 to
access SQL Server 2005 on remote server. On one form I have a textbox
to enter short date. If I delete the date in the textbox, it does not
validate and therefore will not update the server. I know I should
enter null value but have been unsuccessful.

Can you post your insert statement?

I do not have an insert statement at the present. I am migrating from
MSACCESS to C# and learning a new language, so therefore, having a
problem coding the statement. I can tell you, the column in SQL is
DATETIME and on the application I am only interested in short date not
time. Thought about using DateTimePicker control but found I could
not blank out or Null the textbox. Also found I could not delete the
value in the textbox.

[Mick Walker]

BD wrote:

On Aug 17, 8:34 am, Mick Walker <[e-mail]:

>BD wrote:

>>Developing C# windows forms application in Visual Studio 2005 to
access SQL Server 2005 on remote server. On one form I have a textbox
to enter short date. If I delete the date in the textbox, it does not
validate and therefore will not update the server. I know I should
enter null value but have been unsuccessful.

Can you post your insert statement?

I do not have an insert statement at the present. I am migrating from
MSACCESS to C# and learning a new language, so therefore, having a
problem coding the statement. I can tell you, the column in SQL is
DATETIME and on the application I am only interested in short date not
time. Thought about using DateTimePicker control but found I could
not blank out or Null the textbox. Also found I could not delete the
value in the textbox.

Use System.DBNull.Value to insert null values.

i.e
if(txtDate != null) {
// Do Stuff
} else {
// Insert System.DbNull.Value
}

[BD]

On Aug 17, 9:10 am, Mick Walker <[e-mail]:

BD wrote:

On Aug 17, 8:34 am, Mick Walker <[e-mail]:

BD wrote:
Developing C# windows forms application in Visual Studio 2005 to
access SQL Server 2005 on remote server. On one form I have a textbox
to enter short date. If I delete the date in the textbox, it does not
validate and therefore will not update the server. I know I should
enter null value but have been unsuccessful.
Can you post your insert statement?

I do not have an insert statement at the present. I am migrating from
MSACCESS to C# and learning a new language, so therefore, having a
problem coding the statement. I can tell you, the column in SQL is
DATETIME and on the application I am only interested in short date not
time. Thought about using DateTimePicker control but found I could
not blank out or Null the textbox. Also found I could not delete the
value in the textbox.

Use System.DBNull.Value to insert null values.

i.e
if(txtDate != null) {
// Do Stuff
} else {
// Insert System.DbNull.Value
}- Hide quoted text -

- Show quoted text -

How do I handle the validation process? Would I need to insert this
into the validating event?

[Rad [Visual C# MVP]]

On Fri, 17 Aug 2007 06:25:00 -0700, BD <bw******@charter.netwrote:

>Developing C# windows forms application in Visual Studio 2005 to
access SQL Server 2005 on remote server. On one form I have a textbox
to enter short date. If I delete the date in the textbox, it does not
validate and therefore will not update the server. I know I should
enter null value but have been unsuccessful.

Personally I'd try to avoid this problem by using a datepicker
control, that allows null values to be specified. You can then in your
code react as appropriate based on whether the user provided a date or
a null, without needing to validate anything

--
http://bytes.thinkersroom.com