OK this is probably a total noob question, but I have been struggling with it greatly.



I have a website, bound to SQL Server data. My question is about formatting of the different datatypes and data entry.



For dates I have a binding format of {0:d} and am using calendar controls for theuser to enter the dates, so proper formatting of the data entry is not an issue.



I have other fields of type money and integer and no matter what I try, I get this, Input string was not in a correct format.



When I put a BindingFormat of {0:c} the money values look pretty but when the user enters data it throws up, likewise with the integer if they put a comma.



I am new to this method of formatting and before a few days ago had never see anything like {0:c} or {0:N3}.



Can you point me in the right direction? I am guessing that the user input must match exactly what the SQL Server is expecting, but i am having issues making that happen.



Thanks


Keith Chisarik

The problem is not with your data formatting... the problem is with the parsing of the data back into the properties on the business object.  You'll probably need to wrap the textbox or other control you are using for data input and override the Value property (or whatever property on the control returns the value entered by the user).  All data from the users is transmitted back to the server as a string, so the string must then be parsed back into an integer or double, or whatever data type you have specified.  So, when you override the Value property, you will want to strip off all of the commas, $'s, and other symbols that are not part of the actual number, so if the user typed this: $1,000.75  then the control would return this: 1000.75 from it's Value property

It's always fun on the web