how to handle this string conversion exception? whats wrong in my code?

Question

4.00/5 (1 vote)

See more:

C#

foreach (GridViewRow row in GridView1.Rows)
            {
                if ((row.FindControl("chkSelect") as CheckBox).Checked)
                {
                    string dd1 = row.Cells[1].Text;
                    //DropDownList ddl = (DropDownList)row.FindControl("DropDownList1");
                    int catid = int.Parse(row.Cells[2].Text);
                    DateTime date = DateTime.Parse(row.Cells[3].Text);
                    int dcno =int.Parse( row.Cells[4].Text);
                    string company = row.Cells[5].Text;

                    string name = row.Cells[6].Text;
                    string size = row.Cells[7].Text;
                    string batch = row.Cells[8].Text;
                    DateTime exp = DateTime.Parse(row.Cells[9].Text);
                    dt.Rows.Add(dd1, catid, date, company, name, size, batch, exp);


                }

i'm getting exception for int and datetime types. Datatypes in this code match with those given in database. then whats the error? for date and exp fields datatype in database is date not datetime. pls suggest the changes

Posted 30-Jan-15 1:06am

Member 11377180

Updated 4-Feb-15 7:38am

Liju Sankar

v4

Add a Solution

Comments

Zoltán Zörgő 30-Jan-15 7:12am

Where exactly? On Parse? And have you debugged to see what1s in those strings? Can it really be parsed? With dates you need to care about locale also.

Member 11377180 30-Jan-15 7:14am

im getting exception for int and datetime types. Datatypes in this code match with those given in database. then whats the error? for date and exp fields datatype in database is date not datetime. pls suggest the changes

Zoltán Zörgő 30-Jan-15 7:17am

Please edit your post and mark the code row, where the exception is thrown. Is it the last one?
What is the exact DDL of the table?

Member 11377180 30-Jan-15 8:58am

int catid = int.Parse(row.Cells[2].Text);
this line is throwing exception.

Zoltán Zörgő 30-Jan-15 9:21am

Ok, ad what exactly is in row.Cells[2].Text in that instant?

2 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)

Member 11377180 · Answer 1 · 2015-02-04T06:35:00

Solution 3

this gave me solution:

int catid;
                   int.TryParse(row.Cells[2].Text, out catid);
                   DateTime date;
                   DateTime.TryParse(row.Cells[3].Text, out date);
                   int dcno;
                   int.TryParse(row.Cells[4].Text, out dcno);

Posted 4-Feb-15 6:35am

Member 11377180

Dominic Abraham · Answer 2 · 2015-01-30T01:44:00

Solution 2

Hi
Please try

C#

DateTime dt ;
DateTimeStyles dtStyles = DateTimeStyles.None;
CultureInfo culture =  CultureInfo.CreateSpecificCulture("en-US");;

DateTime.TryParse(dateTimeString, culture, dtStyles, out dt);

Regards
Dominic

Posted 30-Jan-15 1:44am

Dominic Abraham

Comments

Philippe Mori 30-Jan-15 12:44pm

Or maybe the invariant culture or explicit format. In any case, it should be explicit.