How to Insert Date in SQL Server By Using MVC 4

Question

0.00/5 (No votes)

See more:

When I want to insert the date into sql database it shows error

String was not recognized as a valid DateTime

.Please help me out how to insert date into sql server by using mvc franework.

This is the sql table

C#

SELECT TOP 1000 [Id]
      ,[FirstName]
      ,[LastName]
      ,[Email]
      ,[TelephoneNo]
      ,[Category]
      ,[Specifcation]
      ,[BuyBetweenDatesFrom]
      ,[BuyBetweenDatesTo]      
      ,[Details]
  FROM [Demo].[dbo].[Enquiry]

thsi is the CSHTML Code

HTML

@Html.TextBoxFor(x => x.BuyBetweenDatesFrom, new { @placeholder = "Select From Date ", id = "datepickerfrom", @class = "form-control" })
 @Html.TextBoxFor(x => x.BuyBetweenDatesTo, new { @placeholder = "Select To Date ", id = "datepicker", @class = "form-control " })

This is the jquery code for datetime picker.

<script>
$(function () {
$("#datepicker").datepicker();
});
</script>
<script>
$(function () {
$("#datepickerfrom").datepicker();
});
</script>

This is the Controller code.

C#

public ActionResult ProductInquiry(Enquirya)
        {
         
           Enquiry enquiry = new Enquiry();
           enquiry.FirstName=Request.Form["FirstName"];
           enquiry.LastName = Request.Form["LastName"];
           enquiry.Email=Request.Form["Email"];
           enquiry.TelephoneNo = Request.Form["TelephoneNo"];
           enquiry.Category=Request.Form["Category"];
           enquiry.Specifcation=Request.Form["Specification"];
           enquiry.BuyBetweenDatesFrom =Convert.ToDateTime(Request.Form["BuyBetweenDatesFrom"].ToString());
           enquiry.BuyBetweenDatesTo =Convert.ToDateTime(Request.Form["BuyBetweenDatesTo"].ToString());

Posted 23-Dec-15 0:27am

@shok kumar mishra

Updated 23-Dec-15 0:46am

v6

Add a Solution

1 solution

Add a Solution

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)

Bryan Tubbs · Answer 1 · 2015-12-23T08:34:00

The main problem is that you are not checking the value of the Request.Form variable. If that value is not in a correct format (or is empty), then your code will fail on the Convert.ToDateTime() call. Don't forget that just because you're allowing for the use of the jquery.datepicker to be used, doesn't mean that the data will be selected with a click of the mouse and that the value doesn't need to be validated before the conversion.

Based on this, you could change your Convert.ToDateTime to be a DateTime.TryParse call and you would be able to know whether the parse worked properly.

The real question here is why your POST isn't just using the Enquiry model that you're accepting as a parameter. This information will be populated by default based on the types of Html helpers you are using. Additionally, if your model defines those two fields as being 'DateTime?', it will be able to handle null values.