Entity framework error : input string was not in a correct format

Question

0.00/5 (No votes)

See more:

I'm trying to set row name in textbox from database table using Entity Model But I'm getting this message error "

"Input string was not in a correct format"

" in the query code :

var get = dc.table.Where(b => b.IdRow ==  id).SingleOrDefault();

I'm using "IdRow = key research"

it's not the first time I use this code !
Thank you for you help.

What I have tried:

private void IdRowtextBox_KeyUp(object sender, KeyEventArgs e)
       {
           if (e.KeyCode == Keys.Enter)
           {

                Entities dc = new Entities();
                int id = Convert.ToInt32(IdRowtextBox.Text) ;

                var get = dc.table.Where(b => b.IdRow ==  id).SingleOrDefault();
                nametextBox.Text = get.name.ToString ();

Posted 1-Mar-17 21:53pm

EM_Y

Updated 7-Mar-17 0:04am

v3

Add a Solution

2 solutions

Solution 1

use Int32.TryParse Method (System)[^]

int id;
           if (int.TryParse(IdRowtextBox.Text.Trim(), out id))
           {
               var get = dc.table.Where(b => b.IdRow == id).SingleOrDefault();
               nametextBox.Text = get.name.ToString();
           }

Posted 1-Mar-17 22:00pm

Karthik_Mahalingam

Comments

EM_Y 2-Mar-17 4:15am

Thank you but I'm Still getting same error !
Any other suggestions ?

Karthik_Mahalingam 2-Mar-17 4:16am

might be from some other place, please point the exact line.

EM_Y 2-Mar-17 4:19am

Errror shows in this line code :

" var get = dc.table.Where(b => b.IdRow == id).SingleOrDefault();"

Karthik_Mahalingam 2-Mar-17 4:23am

exact error message pls.
or post a screenshot

EM_Y 2-Mar-17 4:36am

Error Message Exception "Input string was not in a correct format".

Karthik_Mahalingam 2-Mar-17 4:37am

post a screenshot.

EM_Y 2-Mar-17 4:42am

Sorry I'm new in this Forum , I've never post a screen shot!

Karthik_Mahalingam 2-Mar-17 4:44am

sorry amna, here there is no option to post screenshot,
you shall post the image in www.imgur.com and share the url.

EM_Y 2-Mar-17 4:56am

Error :
http://imgur.com/M4wj5gG

EM_Y 2-Mar-17 4:54am

Error :
http://imgur.com/M4wj5gG

Karthik_Mahalingam 2-Mar-17 5:01am

what is the type of numdemandee

EM_Y 2-Mar-17 5:11am

it's the idRow with type : integer auto increment

Karthik_Mahalingam 2-Mar-17 5:20am

so weird

Karthik_Mahalingam 2-Mar-17 5:23am

try like this
foreach (var item in dc.table)
{
if(item.IdRow == id) {
nametextBox.Text = item.name.ToString();
break;
}
}

EM_Y 7-Mar-17 5:40am

It was a problem in the model table , I added a wrong association .
Thank you @Karthic for you help :)

Karthik_Mahalingam 7-Mar-17 5:44am

cool, Pls close this post

EM_Y 7-Mar-17 5:57am

How can I do that ?

Karthik_Mahalingam 7-Mar-17 6:01am

if this solution helped you, you shall click "Accept answer" or else you can post your own answer and close it.

EM_Y 7-Mar-17 6:06am

Done .
Thank you for your help :)

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)

EM_Y · Accepted Answer · 2017-03-07T00:04:00

Solution 3

It was a problem in the model entity  , I added a wrong association .

Posted 7-Mar-17 0:04am

EM_Y

Updated 7-Mar-17 0:06am

v2