Conversion from string to type 'Double' is not valid. how set this error

Question

1.00/5 (1 vote)

See more:

code:

SQL

If rdbPO.Checked = True And ddl_PO_Cod.SelectedValue.ToString <> -1 Then
         
  btnPrint.Attributes.Add("onclick", "window.open('Reports.aspx?rptid=11&val= '" & ddl_PO_Cod.SelectedValue.ToString & "','','location=0,resizable=0,ScrollBars=1,statusbar=1,width=980,height=800,left=20,top=10,moveable=0') ;return false")
           End If

REPORTS.ASPX CODE

SQL

Case "11"
               report.Load(Server.MapPath("Reports/RepOPODevice.rpt"))
               CRptViewer.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None
               report.RecordSelectionFormula = "{TBL_DEVMASTER.PONO}=" & Request.QueryString("Val").ToString
               Page.Title = "PODevice Reports"

Posted 15-Sep-13 0:33am

akhil.krish

Updated 15-Sep-13 0:40am

v3

Add a Solution

Comments

[no name] 15-Sep-13 6:46am

Was there, maybe, some sort of a question?

Richard MacCutchan 15-Sep-13 7:39am

Don't use ToString everywhere unless you understand what it is actually doing. For example, why are you converting a value to a string and then trying to compare it with the value -1?

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)

Jigar Sangoi · Accepted Answer · 2013-09-15T02:24:00

Solution 1

In your First line

VB

If rdbPO.Checked = True And ddl_PO_Cod.SelectedValue.ToString <> -1 Then

write condtion like this

VB

If rdbPO.Checked = True And ddl_PO_Cod.SelectedValue.ToString <> "-1" Then

OR

VB

If rdbPO.Checked = True And Convert.ToInt32(ddl_PO_Cod.SelectedValue) <> -1 Then

Like this..

When you are comparing two strings then strings must be in " "(i.e double inverted comma)

Or if you sure about your selected value is Integer then use

VB

Convert.ToInt32(combobox.SelectedValue)

Posted 15-Sep-13 2:24am

Jigar Sangoi

Comments

akhil.krish 16-Sep-13 1:53am

Thanks for reply

iam use same u r code... but error comes like this

A string is required here. Details: errorKind Error in File RepOPODevice {F2C06A73-C223-4BF9-ABFA-391D2B70062B}.rpt: Error in formula Record_Selection: '{TBL_DEVMASTER.PONO}= 6169/801//17' A string is required here. Details: errorKind

akhil.krish 16-Sep-13 1:55am

If rdbPO.Checked = True And ddl_PO_Cod.SelectedIndex <> "-1"

this is also same problem ....

Jigar Sangoi 16-Sep-13 2:13am

Now you are using SelectedIndex and selected index always a number
not a string, you have written -1 as String (i.e "-1") this is wrong

Write like this:
If rdbPO.Checked = True And ddl_PO_Cod.SelectedIndex <> -1

and now check what error comes and describe here

Jigar Sangoi 16-Sep-13 2:33am

Also change line and check your problem is solve or not

report.RecordSelectionFormula = "{TBL_DEVMASTER.PONO}='" & Request.QueryString("Val").ToString & "'"

akhil.krish 16-Sep-13 2:46am

Jigar Sangoi Thanks it's working fine but empty reports showing....please help it is very urgent...

Jigar Sangoi 16-Sep-13 3:14am

Add this Code in your case 11

CrystalReportViewer1.ReportSource = report
CrystalReportViewer1.Refresh()

If your problem is solved then please dont forget to mark this answer accepted which helps others too.

akhil.krish 16-Sep-13 3:39am

solve my problem... thanks for rply...

solution :

DeviceReportForm.aspx.vb

If rdbPO.Checked = True And ddl_PO_Cod.SelectedIndex <> 0 Then
Dim pono As String = Convert.ToString(ddl_PO_Cod.SelectedValue)
btnPrint.Attributes.Add("onclick", "window.open('Reports.aspx?rptid=11&val=" & pono & "','','location=0,resizable=0,ScrollBars=1,statusbar=1,width=980,height=800,left=20,top=10,moveable=0') ;return false")
End If

Reports.aspx.vb

Case "11"
report.Load(Server.MapPath("Reports/RepOPODevice.rpt"))
report.RecordSelectionFormula = "{TBL_DEVMASTER.PONO}='" & Request.QueryString("val") & "'"
Page.Title = "PODevice Reports"

Jigar Sangoi 16-Sep-13 5:24am

Hey Please Accept solution so that it will help others too. And Vote this answer also.

akhil.krish 17-Sep-13 1:56am

ok i accept solution.... thanks for rply...

gprawin@gmail.com this my mail id send u r mail id....