ASP.NET C# Datetime

Question

I want to save date through textbox to a SQL Server database using parameters as below:

SqlParameter p15 = new SqlParameter
{   
    SqlDbType = SqlDbType.Date,
    ParameterName = "prj_start_date",
    SqlValue = txtStartDate.Text
};

and the following error appear:

Conversion failed when converting the nvarchar value '12-12-2015' to data type int.

I have try use casting using convert but this was not worked

In addition textmode= date doesn't work in IE

Thanks in advance

Use debug, search in google how to use debug in C#! You are trying to convert 12-12-2015 to int somewhere, because of that you have this problem. — mybirthname
– mybirthname, Commented Jan 9, 2016 at 14:32

marc_s · Accepted Answer · 2016-01-09 15:07:25Z

1

It would be better if you use a jQuery DatePicker rather than using a user input which would save you from invalid inputs from end users.

You are getting this error because you are passing a String type to a Date Type.

Try this:

string enteredDate = txtStartDate.Text.Trim();
DateTime date = DateTime.Parse(enteredDate, InvariantCulture);

SqlParameter p15 = new SqlParameter
{
    SqlDbType = SqlDbType.Date,
    ParameterName = "prj_start_date",
    SqlValue = date;
};

edited Jan 9, 2016 at 15:07

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jan 9, 2016 at 15:02

Manish Badhan

414 bronze badges

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

2 Comments

Muotasem.HY Over a year ago

But how if i want to leave the textbox of date is null ??

Manish Badhan Over a year ago

You can check while passing SqlParameter if textbox value is empty. if(String.IsNullorEmpty(txtStartDate.Text.Trim())) { SqlDateTime s = SqlDateTime.Null; } And pass s as value to your Sqlparameter

Mykola · Accepted Answer · 2016-01-09 14:57:34Z

0

Have you considered parsing the text into a DateTime object in C# - ParseExact allows you to give a specific format string. Then you do not have to deal with Text on the SQL level, particularly given that your date form is non-ISO-standard and open to cultural interpretation.

edited Jan 9, 2016 at 14:57

Mykola

3,4136 gold badges27 silver badges40 bronze badges

answered Jan 9, 2016 at 14:42

TomTom

62.4k11 gold badges95 silver badges152 bronze badges

1 Comment

Muotasem.HY Over a year ago

Thank U :) Appreciate you efforts.

Collectives™ on Stack Overflow

ASP.NET C# Datetime

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related