HAI:
I am now ddeveloping a shopping cart.
my database is SQL 2000.

In table OrderdDetails, i change the datatype of the columns( SubTotal,TaxTotal and GrandTotal) and also in OrderItems table(cost) to money.
Then I received this error:



Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'SubTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'TaxTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'GrandTotal'. Use the CONVERT function to run this query.
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: Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'SubTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'TaxTotal'. Use the CONVERT function to run this query. Disallowed implicit conversion from data type nvarchar to data type money, table 'Flower.dbo.OrderDetails', column 'GrandTotal'. Use the CONVERT function to run this query.

Source Error:


Line 11:
Line 12: Sub btnCheckout_Click(sender As Object, e As System.EventArgs)
Line 13: WriteToDB1.Save()
Line 14: End Sub
Line 15:


Source File: d:\inetpub\wwwroot\Fragrance\cart\order.aspx Line: 13
__________________________________________________ __________________

i realize that it is some thing do with the CONVERT function Query in SQL Server.
So i try it out by right click the tblOrders and open the table by query.
Then i type this query statement:

SELECT

SubTotal
TaxTotal
GrandTotal

CONVERT
(varchar(50)
convert(money(8)))

FROM
OrderDetails


But sad to say that until now i have't get the right query yet.

Some syntax error, such as inccorect syntax near'GrandTotal'....

Any suggestion on how to solve this problem?
may be has other ways ?
Please help!

This article from MS may help clear up somethings
CAST and CONVERT
Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.

Syntax
Using CAST:

CAST ( expression AS data_type )

Using CONVERT:

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Arguments
expression

Is any valid Microsoft® SQL Server™ expression. For more information, see Expressions.

data_type

Is the target system-supplied data type, including bigint and sql_variant. User-defined data types cannot be used. For more information about available data types, see Data Types.

length

Is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types.

style

Is the style of date format used to convert datetime or smalldatetime data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types), or the string format when converting float, real, money, or smallmoney data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types).

SQL Server supports the date format in Arabic style, using Kuwaiti algorithm.

In the table, the two columns on the left represent the style values for datetime or smalldatetime conversion to character data. Add 100 to a style value to get a four-place year that includes the century (yyyy).