asked on

I am trying to do a select and getting this error: Error converting data type nvarchar to float.

error msg:
Exception Details: System.Data.SqlClient.SqlException: Error converting data type nvarchar to float.
----------------
both Latitude & longitude are db float values
----------------

<asp:SqlDataSource ID="dsPopulateExtWA" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>"
SelectCommand="SELECT DISTINCT [State] + ' ' + [City] + ' ' + [Ext2] + ' ' + [Ext3] + ' ' + Latitude
+ ' ' + Longitude AS MyDataWA
FROM [trip4usdnn].[trip4usdnn].[Netism_MapExtreme_Locations] where state = 'WA'"></asp:SqlDataSource>

Manoj Patil

Try this

"SELECT DISTINCT [State] + ' ' + [City] + ' ' + [Ext2] + ' ' + [Ext3] + ' ' + CASE ISNUMERIC(Latitude) WHEN 1 THEN CAST(Latitude AS float) ELSE null END + ' ' + CASE ISNUMERIC(Longitude) WHEN 1 THEN CAST(Longitude AS float) ELSE null END AS MyDataWA
FROM [trip4usdnn].[trip4usdnn].[Netism_MapExtreme_Locations] where state = 'WA'"

westdh

ASKER

Iam getting the same error:

Error converting data type nvarchar to float.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Error converting data type nvarchar to float.

Manoj Patil

Is there any null data or which is not float or can't covert into float.... have u checked the DB Table

westdh

ASKER

No Nulls:

all I am doing is selecting the data and populating a dropdownlist?

ASKER CERTIFIED SOLUTION

Manoj Patil

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Manoj Patil

For more information chekc following link

http://aartemiou.blogspot.com/2009/07/error-converting-data-type-varchar-to.html

westdh

ASKER

Thanks Much