ASP.NET

Passing null to datetime datatype

16-Dec-08 19:12

You asked this the other day and you were given at least one useful answer. Instead of trying it, or asking about it, you just post the same question again. Did you try what was suggested ?

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 18:46

16-Dec-08 18:46

i want to store null in database in field having datetime datatype
but i am not able to do it

i tried this
convert.toDateTime(null)

i am get this error
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

with regards
rahul

Christian Graus16-Dec-08 18:48

16-Dec-08 18:48

OK - this means that your DB will only accept a date. You should change the DB so it will take null, or you should sanitise your input. Either way, Convert.ToDateTime(null) is a nonsense. You should pass in DbNull.Value, or null, whichever works, to store null.

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 18:59

16-Dec-08 18:59

my DB takes null

i have tried what u said but it doesn't works

with regards
rahul

Christian Graus16-Dec-08 19:14

16-Dec-08 19:14

Do you mean what I said here, or in the other thread you started as a different user ?

If your DB takes null, then you won't get an error if you insert null. But Convert.ToDAteTime(null) is a nonsense, that won't work.

What did you try, and what happened ?

Christian Graus

Driven to the arms of OSX by Vista.

amit sahu2016-Dec-08 19:27

amit sahu20

16-Dec-08 19:27

DateTime? arivalDate = null;
DateTime? departDate = null;
fun(arivalDate,departDate)

public void fun(object Date_Start,object Date_End)
{
 if (Date_Start == null)
{            cmd.Parameters.AddWithValue("@Date_Start",System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@Date_Start", Date_Start);
}
if(Date_End == null )
{
cmd.Parameters.AddWithValue("@Date_End", System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@Date_End", Date_End);       
}
}

Christian Graus16-Dec-08 19:39

16-Dec-08 19:39

amit sahu20 wrote:
public void fun(object Date_Start,object Date_End)

This is ridiculous. Why pass an object and not a DateTime? ? Then you can use .HasValue, and generally write nice code.

Have you set a breakpoint to see which code executes ? Have you tried DbNull.Value ? I wonder if SqlDateTime is a type for SQL Server only ?

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 19:58

16-Dec-08 19:58

i did what u said

if (Date_Start == null){
cmd.Parameters.AddWithValue("@Date_Start",System.Data.SqlTypes.SqlDateTime.Null);
}

but i am geting error
System.Data.SqlClient.SqlException: Error converting data type nvarchar to datetime

with regards
rahul

Rahul Gharat16-Dec-08 19:32

16-Dec-08 19:32

i am doing this

DateTime CompletionDate;
if (txtCompletionDate.Text != "")
{
CompletionDate = Convert.ToDateTime(txtCompletionDate.Text);
}
else
{
CompletionDate = null;
}

and passing this CompletionDate to Store procedure

but i am getting error
cannot convert null to datetime

with regards
rahul

amit sahu2016-Dec-08 19:36

amit sahu20

16-Dec-08 19:36

use it before pass to DB
if (CompletionDate == null)
{ cmd.Parameters.AddWithValue("@CompletionDate",System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@CompletionDate", CompletionDate);
}

and also in DB "CompletionDate" field shulid allow null

Christian Graus16-Dec-08 19:41

16-Dec-08 19:41

Oh, you were answering, not asking. The code you posted is still messy, even if SqlDateTime.Null works.

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 20:09

16-Dec-08 20:09

in DB completiondate allows null

but it still gives same error

with regards
rahul

Christian Graus16-Dec-08 23:06

16-Dec-08 23:06

How do you know it allows null ? In any case, your error is not that null is not allowed, but that the date object is broken. I think you need to make your code typesafe, walk through with the debugger and see what date is passed in. You also need to fix your code where it is prone to breaking.

Christian Graus

Driven to the arms of OSX by Vista.

Christian Graus16-Dec-08 19:40

16-Dec-08 19:40

This is messy. What if the text entered cannot be converted ? This code is fragile and not production quality, on many levels.

I need to see the code that throws that error, in order to comment on it.

Christian Graus

Driven to the arms of OSX by Vista.

Rahul Gharat16-Dec-08 20:07

16-Dec-08 20:07

DateTime? StatusDate,CompletionDate;

if (txtStatusDate.Text != "")
{
StatusDate = obj.ConvertStringToDate(txtStatusDate.Text);
}
else
{
StatusDate = null;
}

i am get error in below code
public Boolean InsertTask(string oprtype, object StatusDate)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlcommand = "DailyReport";
DbCommand dbcommand = db.GetStoredProcCommand(sqlcommand);
db.AddInParameter(dbcommand, "@oprtype", System.Data.DbType.String, oprtype);
if (StatusDate != null)
{
db.AddInParameter(dbcommand, "@StatusDate", System.Data.DbType.DateTime, StatusDate);
}
else
{
db.AddInParameter(dbcommand, "@StatusDate", System.Data.DbType.DateTime, DBNull.Value);
}
db.ExecuteNonQuery(dbcommand);
return true;
}

with regards
rahul

Christian Graus16-Dec-08 23:04

16-Dec-08 23:04

rahul.gharat wrote:
object StatusDate)

Why are you still passing this as an object ? In any case, if this is passing DBNull.Value, and the procedure fails, then your database doesn't support null. That's really about it. Have you tried running the proc directly against the database ? What does the proc look like ?

I can't help but feel that if you made this code typesafe, it might well work. You're not passing a datetime, you're passing an INullable<DateTime> and I can't help but wonder if that makes a difference, when all you tell the compiler is that it's an object.

Christian Graus

Driven to the arms of OSX by Vista.

Website Deployment

kirandilip16-Dec-08 18:34

kirandilip

16-Dec-08 18:34

good morning every one,
i generated a website application using asp.net with c#.net.i want to deploy that website but i donot know how to deploy the website,plz tell me how to deploy the website by a step by step procedure.
thanks in advance.

Christian Graus16-Dec-08 18:48

16-Dec-08 18:48

Copy the files onto the server. Make sure the server has ASP.NET installed. Point IIS to your site.

Christian Graus

Driven to the arms of OSX by Vista.

Abhijit Jana16-Dec-08 18:53

Abhijit Jana

16-Dec-08 18:53

Just 2 day back there was a same Question on CP.
Check [^]
You can find step by step description over there.
-------------
This is one of the common question that i have faced in this forum. So I have planned for write a step by step guide to deploy the sites. Hope I will upload it in CP as early as possible Wink | ;)

cheers,
Abhijit
My Recent Article : Beginner's Guide to ASP.NET Application Folder

Vimalsoft(Pty) Ltd16-Dec-08 19:18

Vimalsoft(Pty) Ltd

16-Dec-08 19:18

Step1:Make sure that the IIS is Installed,

Step2: Make sure that the Correct .NET Framework for your Application is Installed

Step 3: Create an Virtual Directory

Step 4: Copy your Files in the Vurtual Directory

And thats it Smile | :)

Simple ne

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Christian Graus16-Dec-08 19:43

16-Dec-08 19:43

And you repeated the advice already given because.,..... ? These repeat answers flood the forums, an easy question sometimes gets 8 answers, all of them the same.

Christian Graus

Driven to the arms of OSX by Vista.

Vimalsoft(Pty) Ltd16-Dec-08 19:47

Vimalsoft(Pty) Ltd

16-Dec-08 19:47

Sorry about that