MaskedTextBox If empty insert NULL into SQL

Question

I have got this code below which care whether maskedtextbox is empty. If it is empty it INSERT INTO SQL table __.__.____ - only the mask so I believe it INSERTS NULL But something got wrong when I fill the maskedtextbox. It still INSERT __.__.____ - NULL I don't know where I make mistake because it should normally insert the date which is in the maskedtextbox.

The mask for this textbox is __.__.____ like 00/00/0000

Data type in which I insert this data is - date.

Here is the code:

var value2 = (object)DBNull.Value;
DateTime parsedDate2;
if (DateTime.TryParseExact(maskedTextBox2.Text, "__.__.____", null,
                           DateTimeStyles.None, out parsedDate2))
{
    value2 = parsedDate2;
}
prikaz.Parameters.AddWithValue("@odjdate", value2);

Edit : This code below says: the name 'value2' does not exist in the current context'

var value2 = (object)DBNull.Value;
DateTime parsedDate2;
if (DateTime.TryParseExact(maskedTextBox2.Text, "dd.MM.yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out parsedDate2))
{
    value2 = parsedDate2;
}
prikaz.Parameters.AddWithValue("@odjdate", value2);

This code below does this Ex:

Converting into data type date wasn't succesfull.

This is the code

if (maskedTextBox2.Text == "__.__.____")
{
    prikaz.Parameters.AddWithValue("@odjdate", null);
}
else
{
    prikaz.Parameters.AddWithValue("@odjdate",maskedTextBox2.Text);
}

You have to give the format in `DateTime.TryParseExact` instead of `__...` what is your mask format? — Sriram Sakthivel, Aug 05 '13 at 14:15
@SriramSakthivel Thank you for your comment, my mask is 00/00/0000 - / is replaced with . — Marek, Aug 05 '13 at 14:16
How does your `maskedTextBox2.Text` value looks like? show sample — Sriram Sakthivel, Aug 05 '13 at 14:20
Im not sure :( In SQL database it is like 2012-12-12, but I insert it like 12.12.2012 - dd.MM.yyyy atleast I hope first is day then is month and year is in the end. — Marek, Aug 05 '13 at 14:27
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/34849/discussion-between-marek-and-sriram-sakthivel) — Marek, Aug 05 '13 at 15:06
@Marek by default, your `maskedTextBox.Text` will be like as what you can see but if you modify the `MaskedTextBox.TextMaskFormat` such as `maskedTextBox1.TextMaskFormat = MaskFormat.ExcludePromptAndLiterals;`, it will be different, for example, `12.12.2012` will be `12122012` and it could be your problem. — King King, Aug 05 '13 at 22:13

Sriram Sakthivel · Answer 1 · 2013-08-05T14:34:58.277

1

Try this

var value2 = (object)DBNull.Value;
DateTime parsedDate2;
if (DateTime.TryParseExact(maskedTextBox2.Text, "dd.MM.yyyy", CultureInfo.InvariantCulture,DateTimeStyles.None, out parsedDate2))
{
    value2 = parsedDate2;
}

Note: if your format is "MM.dd.yyyy" then replace format to make the parse to work!

This should work

edited Aug 05 '13 at 14:34

answered Aug 05 '13 at 14:28

Sriram Sakthivel

72,067
7
111
189

I edited my answer it give sme this error - The name 'value2' does not exist in the current context , I edited answer so you can see what I entered. – Marek Aug 05 '13 at 14:33
1

@Marek You didn't delete the line that says `var value2 = ...`, did you? – jszigeti Aug 05 '13 at 14:35
1

No i just given OP the portion to replace. I haven't suggested to delete any other lines. Is it clear now @Marek – Sriram Sakthivel Aug 05 '13 at 14:36
1

@jszigeti Op would have deleted `var value2 = ..` – Sriram Sakthivel Aug 05 '13 at 14:36
@SriramSakthivel Thank you it was my mistake, I deleted var value.. But it still inserts NULL if the maskedtextbox is filled :/ – Marek Aug 05 '13 at 14:38
1

you mean if maskedtextbox is not filled? – Sriram Sakthivel Aug 05 '13 at 14:41
No, if I fill it, it inserts NULL :( – Marek Aug 05 '13 at 14:43
you filled valid value or what? `dd` should be less than or equal to `31`, `MM` <= `12` ? – Sriram Sakthivel Aug 05 '13 at 14:45
I filled 12.12.2012 but in database I get null value. Dont you know where I make mistake? – Marek Aug 05 '13 at 14:47
Put a break point and check what value you're passing to sql. If correct value is passed probably issue will be in `StoredProcedure` if you're using SP – Sriram Sakthivel Aug 05 '13 at 14:49
@Marek I'd actually put a breakpoint inside the if statement to see if the TryParseExact is correctly identifying your string (this can also check if your masked text box is working) – jszigeti Aug 05 '13 at 14:51
@Marek As jszigeti told try to put breakpoint and see whether it is getting inside If or not. – Sriram Sakthivel Aug 05 '13 at 15:02
@SriramSakthivel That is exactly what I have done, but it says that value2 is null, but I'm not sure exactly why :/ – Marek Aug 05 '13 at 15:03
Whether it went inside If? – Sriram Sakthivel Aug 05 '13 at 15:04
@SriramSakthivel Yes, exactly there. – Marek Aug 05 '13 at 15:05
If it went inside `IF` definitely value2 will have a value. – Sriram Sakthivel Aug 05 '13 at 15:06
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/34850/discussion-between-marek-and-sriram-sakthivel) – Marek Aug 05 '13 at 15:07
@SriramSakthivel it says that value2 is null inside IF Im not sure why – Marek Aug 05 '13 at 15:10
@SriramSakthivel the parseddate2 is like 1. 1. 0001 isnt it because of that? – Marek Aug 05 '13 at 15:15

score 1 · Accepted Answer · answered Aug 08 '13 at 16:30

1

This works fine for me:

 var value2 = (Object)DBNull.Value;
 DateTime parsedDate2;
 if (DateTime.TryParse(maskedTextBox1 .Text, out parsedDate2))
 {
   value2 = (Object)parsedDate2;
 }
prikaz.Parameters.AddWithValue("@odjdate", value2);

answered Aug 08 '13 at 16:30

Silvano

203
1
7

MaskedTextBox If empty insert NULL into SQL

2 Answers2