Try to save date from gridview cell to SQL

Question

0.00/5 (No votes)

See more:

hi,
I make gridview cell as a date time picker through progammicaly
now i want to save the grid view cell date in SQl . But i'm facing an error
please help me how can i solve it thousand time i search it from google but not get any solution
I'm getting this error message
"

System.Data.SqlTypes.SqlTypeException: 'SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.'

"

What I have tried:

 foreach (DataGridViewRow row in StockdataGridView.Rows)
             {
             using (SqlCommand cmd = new SqlCommand("USP_Insert_Stock_Info", conn1))
{
  cmd.CommandType = CommandType.StoredProcedure;
 DateTime expdate = Convert.ToDateTime(row.Cells[5].Value );
                            cmd.Parameters.AddWithValue("@ExpDate", expdate);
}     
        } {

Posted 21-Dec-18 21:20pm

Fahid Zahoor

Updated 21-Dec-18 21:28pm

v2

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)

RickZeeland · Answer 1 · 2018-12-21T21:29:00

Solution 1

I think you need to place a breakpoint at the line:

DateTime expdate = Convert.ToDateTime(row.Cells[5].Value );

and look what expdate looks like by hovering over it with the mouse, the format is probably not correct for your stored procedure.
You should also check if row.Cells[5].Value is not NULL first.

It might also be needed to explicity specify the SqlDbType, like this:

command.Parameters.Add(new SqlParameter("@ExpDate", SqlDbType.DateTime2) { Scale = 3, Value = expdate });

More info here: AddWithValue is Evil | Dan Guzman's Blog[^]

See example here for DateTimePicker usage: How to: Host Controls in Windows Forms DataGridView Cells | Microsoft Docs[^]

Posted 21-Dec-18 21:29pm

RickZeeland

Updated 21-Dec-18 22:05pm

v4

Comments

Fahid Zahoor 22-Dec-18 3:45am

when i hover the mouse on "expdate"
the value is {1/1/0001 12:00:00 AM}
but i cannot select this value i set today date .
now how can i refine it

Fahid Zahoor 22-Dec-18 3:49am

ohhh i checked it
if row.Cells[5].Value is not NULL.
it show null value but i set today date

RickZeeland 22-Dec-18 3:55am

Looks like you are on the right track now :) I will also update the solution with an interesting link about SqlDbType.

Fahid Zahoor 22-Dec-18 3:57am

but please tell me how can i correct it really worried

Fahid Zahoor 22-Dec-18 4:07am

I used it but now this error occur
System.InvalidCastException: 'Failed to convert parameter value from a DateTimePicker to a DateTime.'