how pass the null value using datetime datatype in asp.net and database is mysql?

Question

i am using asp.net 2.0 and database is Mysql and i am passing null value using datetime datatype to mysql table like this duedate is datetime

if (ddlTerms.SelectedItem.Text.ToString() != "--Select--")
   {
     DateTime createDate = DateTime.Now.AddDays(Convert.ToDouble(ddlTerms.SelectedValue));
     oInvHeader.DueDate = createDate;
   }
   else
   {
    oInvHeader.DueDate =(how to write the code here)
   }

in invoiceHeader.cs code

using System;
using System.Data;
using MySql.Data.MySqlClient;
using System.Text;

 private DateTime m_DueDate;

public DateTime DueDate
        {
            get
            {
                return m_DueDate;
            }
            set
            {
                m_DueDate = value;
            }
        }

pls help me thank u hemanth

pls check this link it is sql server like taht i have mysql c-sharpcorner.com/UploadFile/sd_patel/… — hmk
– hmk, Commented Aug 13, 2011 at 5:36

Off The Gold · Accepted Answer · 2016-02-10 13:36:25Z

3

First of all your DueDate property should be nullable to accept a null value.

Then you can assign the null value like..

oInvHeader.DueDate = null;

Here is, how we declare a nullable variable

DateTime? DueDate;

edited Feb 10, 2016 at 13:36

Off The Gold

1,23615 silver badges28 bronze badges

answered Aug 13, 2011 at 5:42

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

hmk Over a year ago

how to set the datetime poperty is null ( i am asking db r fields in asp.net)

Muhammad Akhtar Over a year ago

what is this oInvHeader.DueDate ? are you using any code generation tool?

hmk Over a year ago

no on dataaccess layer i am using invoiceheader.cs so that class object is oinvHeader and duedate is the datetime datatype

Muhammad Akhtar Over a year ago

Can you show me that cs file? you can edit your question and paste that cs file code.

Ajith kumar · Accepted Answer · 2012-10-16 07:00:51Z

0

public virtual Nullable Variablename

it wil take default null

answered Oct 16, 2012 at 7:00

Ajith kumar

411 bronze badge

Comments

Yaroslav · Accepted Answer · 2012-10-16 07:14:10Z

0

class test
{ 
    public virtual Nullable<Int32> ReagentSupplyCode
     {
        get;
        set;
     }
}

edited Oct 16, 2012 at 7:14

Yaroslav

6,55210 gold badges54 silver badges91 bronze badges

answered Oct 16, 2012 at 7:04

Ajith kumar

411 bronze badge

Collectives™ on Stack Overflow

how pass the null value using datetime datatype in asp.net and database is mysql?

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related