Input string was not in a correct format.Couldn't store ..... Expected type is Int32.

Question

0.00/5 (No votes)

See more:

I know where is the problem, but do not know how to fix it.

Column that gives me the error in the database is tipe "NUMBER" and accept null values.

But when execute query ....

C#

Program.Connection.CommandText = "select Contracts.ContractId, Contracts.StartDate, Contracts.EndDate, Contracts.Procent, ContractItems.DeletedId AS ContracteActive, sum (ContractItems.Payment) AS Total_Platit, Now () AS DataCurenta from Contracts INNER JOIN ON ContractItems Contracts.ContractId = ContractItems.ContractId WHERE ClientID = @ ClientID "
                 + "GROUP BY Contracts.ContractId, Contracts.StartDate, Contracts.EndDate, Contracts.Procent, ContractItems.DeletedId ORDER BY Contracts.EndDate AND (((ContractItems.DeletedId) Is Null)), Contracts.EndDate DESC";
             Program.Connection.AddParameter ("@ ClientID", ClientID.Text);

the query when it finds a record that has null field, it gives me this error, how to read data whether that field is null or contain a number.?

Posted 7-Sep-12 4:11am

Aciobanita Costel

Updated 7-Sep-12 6:56am

Sandeep Mewara

v2

Add a Solution

Comments

[no name] 7-Sep-12 10:22am

The error that yo are getting has nothing to do with nulls but with type mismatch. It seems that it is expecting int32 and you are passing it something else.

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)

Bernhard Hiller · Answer 1 · 2012-09-07T04:24:00

Solution 1

Do you need those data where DeleteId is null? If not, you could add a WHERE statement like

SQL

WHERE ContractItems.DeletedId is not null

before the Group By clause.
But I have some doubts... Is ClientId also a number - and the TextBox ClientId contains other characters?
You could replace the line with e.g.

C#

Program.Connection.AddParameter ("@ClientID", Convert.ToInt32(ClientID.Text));

Posted 7-Sep-12 4:24am

Bernhard Hiller

Comments

Aciobanita Costel 7-Sep-12 10:57am

Yes, I need data whre DeleteId is null, or have a number.
ClientId is also a number, but is declared like:

.....

ClientID.Text = cboNumeClient.SelectedValue.ToString();

....

Bernhard Hiller 7-Sep-12 13:20pm

Then use COALESCE for that column. It's something like
COALESCE(ContractItems.DeletedId, -1) AS ContracteActive
and then use "ContracteActive" in the respective position in the Group By clause.

Lenin Mathi · Answer 2 · 2012-09-07T04:25:00

Solution 2

it's better u check with ISNULL function.
ISNULL(parameter, 0). in this if the parameter is null then the result is 0 else the value will be refelected.

Posted 7-Sep-12 4:25am

Lenin Mathi

Comments

Aciobanita Costel 7-Sep-12 11:05am

I try this, but it give a error:

Wrong number of arguments used with function in query expression

'ISNULL(ContractItems.DeletedId,0)'.

i use microsoft access for database

WebMaster · Answer 3 · 2012-09-07T07:20:00

Solution 3

You should check TextBox.Text before your code.
The TextBox.Text must convertable to Int32. If it contains any letter you would expect this error.

Posted 7-Sep-12 7:20am

WebMaster