problem with add money value from text box to SQL table

Hi...

I have problem with add money value from text box to SQL table

This is my statment

cmd.Parameters.Add(

"@.minbid", Data.SqlDbType.SmallMoney)

cmd.Parameters.Add(

"@.minIncrement", Data.SqlDbType.SmallMoney)

can any one help me

You might want to "describe" what the problem is. Perhaps post the error message?|||

Hi..

Tanke you for reply ...I think the problem is when the user enter to the text box int value ..

ex:

min bid = 100 --> The user inter it

I think to solve the problem is to format the user input to money value ...but how I do that

pleaze if any one have a solution to reply please as soon as posiple.

thanks alot

Problem whit "." or "," in field MONEY

Hi guys...

UPDATE PRODUCT SET PRICE='1,11' WHERE COD='001'

but, in field "PRICE" = 111,00

I don′t need "." but i need to use ","

UPDATE PRODUCT SET PRICE='1.11' WHERE COD='001'

Works perfectly... but all sql commands in applications use ","

In Server

User′s set LANGUAGE=PORTUGUESES

DEFAULT LANGUAGE = PORTUGUESES

Tks All

If i'm correct then you are using money or decimal for price.

use varchar for price and use CHAR(44) for ',' and format the string.