Exception while converting DateTime in C#

Question

0.00/5 (No votes)

See more:

Hi All,

I do have a requirement where i need to divide DateTime column as Date and Time column. So when i'm trying to convert the DateTime, it's giving me error stating "ArgumentOutofRangeException was unhandled" on line
dataGridView1.Rows[i].Cells[txtColumnName.Text.Replace(" ", "")].Value = Time.ToString("HH:mm:ss");

Below is my complete code:

C#

private void btnSplit_Click(object sender, EventArgs e)
{
    DataGridViewTextBoxColumn dgvcdate = new DataGridViewTextBoxColumn();
    dgvcdate.Name = cmbColumnCombo.Text;
    dgvcdate.HeaderText = cmbColumnCombo.Text;
    dataGridView1.Columns.Add(dgvcdate);

    DataGridViewTextBoxColumn dgvctime = new DataGridViewTextBoxColumn();
    dgvctime.Name = txtColumnName.Text.Replace(" ", "");
    dgvctime.HeaderText = txtColumnName.Text;
    dataGridView1.Columns.Add(dgvctime);

    for (int RowCount = 1; RowCount <= strfile.Length - 1; RowCount++)
    {
        if (strfile[RowCount].ToString() != "")
        {
            if (RowCount != 0)
            {
                string[] column = strfile[RowCount].Split('þ');
                for (int i = 1; i < column.Length - 1; i++)
                {
                    if ((cmbColumnCombo.SelectedIndex == ((i - 1) / 2)))
                    {
                        dataGridView1.Rows.Add();

                        if (column[i].ToString() != "\u0014")
                        {
                            DateTime Time = Convert.ToDateTime(column[i]);
                   //         DateTime Time = (DateTime)column[i]; 
                     dataGridView1.Rows[i].Cells[txtColumnName.Text.Replace(" ", "")].Value = Time.ToString("HH:mm:ss");
                         dataGridView1.Rows[i].Cells[cmbColumnCombo.Text].Value = Time.ToString("dd/MM/yyyy");
                            //dataGridView1.Rows[RowCount - 1].Cells[cmbColumn1.Text].Value += column[i].ToString();
                        }
                    }
                }
            }
        }

Please let me know how to resolve this error. Thanks in advance.

Posted 17-Jan-16 22:23pm

Member 8010354

Updated 17-Jan-16 22:40pm

Jochen Arndt

v2

Add a Solution

Comments

BillWoodruff 18-Jan-16 5:28am

In addition to the good advice on debugging here from OriginalGriff and FES SiteCore, why not use:

DateTime dateTime;

if(DateTime.TryParse(sourceString, out dateTime))
{
// valid
}

Also, take a look at DateTime.TryParseExact
else
{
// throw new .... ?
}

3 solutions

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)

OriginalGriff · Answer 1 · 2016-01-17T22:34:00

Start by using the debugger.
Put a breakpoint on the line, and run your program. When it gets to the line, execution will stop and wait for you to tell it what to do.
At this point you can look at the various parts you have there and work out exactly what is being converted to what, or is invalid data.
The most likely problem is either the textbox contains the wrong column name, or the DGV column is configured to a datatype that doesn't like the string you are passing it.

But we can't tell that: we can't run your code, and if we could, we couldn;t get the exact same conditions you are executing it under without your data, forms, and probably user as well!

Give it a try; see what you can find out. It should be pretty obvious when you have actual data to help you!

F-ES Sitecore · Answer 2 · 2016-01-17T22:50:00

Solution 2

C#

dataGridView1.Rows[i].Cells[txtColumnName.Text.Replace(" ", "")].Value = Time.ToString("HH:mm:ss");

For Rows[i], "i" probably refers to a row that doesn't exist. Eg you have 4 rows and i is 7. i is a loop on column.Length so you probably don't mean to use it for the row count as well, did you mean Rows[RowCount] instead?

As Griff said, we can't run your code or know your logic, only you can know that so get used to debugging your own code

Mastering Debugging in Visual Studio 2010 - A Beginner's Guide[^]

Posted 17-Jan-16 22:50pm

F-ES Sitecore

Comments

Member 8010354 18-Jan-16 7:49am

Actually, while debugging i observed that CODE: DateTime Time = Convert.ToDateTime(column[i]);
dataGridView1.Rows[i].Cells[txtColumnName.Text.Replace(" ", "")].Value = Time.ToString("HH:mm:ss");

Initially Time is taking
Date = {1/1/0001 12:00:00 AM} value and later on it's reading the dates in file but the DATE in the file is 5/4/2009 3:45 PM.

After cursor moving to the second line, then the TIME is having 5/4/2009 3:45 PM date.

Simon_Whale · Answer 3 · 2016-01-17T22:56:00

Solution 3

You need to check that the cell name in the line below (bolded part) is valid.

C#

dataGridView1.Rows[i].Cells[txtColumnName.Text.Replace(" ","")].Value = Time.ToString("HH:mm:ss");

Posted 17-Jan-16 22:56pm

Simon_Whale

Comments

Member 8010354 18-Jan-16 5:14am

Yeah it's a valid one.

Drpdownbox: No: of columns displayed (Have to select DateTime column)
TextBox: Need to enter new column value

DataGridView: It should display as a 2 columns.

Exception while converting DateTime in C#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us