SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Question

1.00/5 (1 vote)

See more:

.NET

MVC4

how to convert my date into the sql format

Posted 10-Jan-16 19:02pm

Member 11956239

Add a Solution

Comments

dan!sh 11-Jan-16 1:11am

As the message states, the date has to be within acceptable range. Share what you are sending to database for help. You can make use of Improve Question link to update your question.

Member 11956239 11-Jan-16 1:49am

public DateTime user_created_date { get; set; }
..................................................
DAL
class{
_cmd.Parameters.AddWithValue("@user_created_date", _obj.user_created_date)
}
.......................................
in sql i have given datatype
DATE

dan!sh 11-Jan-16 1:56am

You should update your question with code, format it properly and provide more details here rather than in comments. Once you have updated the question, delete this comment trail.

Patrice T 11-Jan-16 1:46am

And what is your date format ?

Member 11956239 11-Jan-16 3:04am

plese help me

Member 11956239 11-Jan-16 1:52am

mm/dd/yyyy

Richard MacCutchan 11-Jan-16 3:31am

Instead of posting cryptic one word replies, please edit your question and show the actual code where the error occurs, and include details of all variables that are causing the problem.

Member 11956239 11-Jan-16 4:18am

MOdel
>>>>>>>>>>>>>
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.ComponentModel.DataAnnotations;

namespace ResumeServicesApplication.Models
{
public class Model_tbl_user_personal_details
{
public int user_personaldetails_id { get; set; }
[Display(Name = "User Id")]
public int user_id { get; set; }
[Display(Name = "First Name")]
public string user_firstname { get; set; }
[Display(Name = "Middle Name")]
public string user_middlename { get; set; }
[Display(Name = "Last Name")]
public string user_lastname { get; set; }
[Display(Name = "Father Name")]
public string user_fathername { get; set; }
[Display(Name = "Gender")]
public string user_gender { get; set; }
[Display(Name = "Temparary Address 1")]
public string user_temporary_add1 { get; set; }
[Display(Name = "Temparary Address 2")]
public string user_temporary_add2 { get; set; }
[Display(Name = "Temparary Address 3")]
public string user_temporary_add3 { get; set; }
[Display(Name = "Temparary State")]
public string user_temporary_state { get; set; }
[Display(Name = "Temparary Country")]
public string user_temporary_country { get; set; }
[Display(Name = "Temparary Pin")]
public string user_temporary_pin { get; set; }
[Display(Name = "Perminant Address 1")]
public string user_permanent_add1 { get; set; }
[Display(Name = "Perminant Address 2")]
public string user_permanent_add2 { get; set; }
[Display(Name = "Perminant Address 3")]
public string user_permanent_add3 { get; set; }
[Display(Name = "Perminant State")]
public string user_permanent_state { get; set; }
[Display(Name = "Perminant Country")]
public string user_permanent_country { get; set; }
[Display(Name = "Perminant Pin")]
public string user_permanent_pin { get; set; }
[Display(Name = "Date Of Birth")]
public DateTime user_dob { get; set; }
[Display(Name = "Prefered Location")]
public string user_prefered_location { get; set; }
[Display(Name = "Hobbies")]
public string user_hobbies { get; set; }
[Display(Name = "Created By")]
public string user_created_by { get; set; }
[Display(Name = "Created Date")]
public DateTime user_created_date { get; set; }
[Display(Name = "Modified By")]
public string user_modified_by { get; set; }
[Display(Name = "Modified Date")]
public DateTime user_modified_date { get; set; }
[Display(Name = "Active")]
public byte user_personaldetails_isactive { get; set; }
}
}
DAL
>>>>>>>>>>>>>>>>>>>>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace ResumeServicesApplication.Models
{
public class DAL
{
SqlConnection _connectionDAL = new SqlConnection(ConfigurationManager.ConnectionStrings[Constents.connection].ConnectionString);

public int _SignUp(Model_tbl_user_personal_details _obj)
{

int active = 1;
int _result = 0;
_connectionDAL.Open();
SqlCommand _cmd = new SqlCommand("insert into tbl_user_personal_details values(@user_id,@user_firstname,@user_middlename,@user_lastname,@user_fathername,@user_gender,@user_temporary_add1,@user_temporary_add2,@user_temporary_add3,@user_temporary_state,@user_temporary_country,@user_temporary_pin,@user_permanent_add1,@user_permanent_add2,@user_permanent_add3,@user_permanent_state,@user_permanent_country,@user_permanent_pin,@user_dob,@user_prefered_location,@user_hobbies,@user_created_by,@user_created_date,@user_modified_by,@user_modified_date,@user_personaldetails

Matt T Heffron 11-Jan-16 14:29pm

As d@nish and Richard said, please use the Improve question above (just at the bottom of your original question) to edit the question. Be sure to use the correct formatting for the code. (That's the "code" button in the editor, choose "C#" from the displayed choices.)
When you have done that, then come and Delete this "comment" (since it is not very readable.)

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)